Notice: Undefined variable: cons_id in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 18
Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at end of input
LINE 4: WHERE cons_id =
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: SELECT cons_id, cons_time, cons_cnp, pat_cid, pat_emp_stencil_no as stencil, cons_msp_code, cons_rap_mscode, cons_rap_diagnostictype, cons_rap_dgcode, ctr_contract_no as contractno, ctr_contract_type as contracttype, ctr_category_code as reporttype, date(now()) as reportdate, ctr_ou_code as insurancehouse, pro_uic as providercode, pro_name as providername, date_trunc('second', cons_time) as servdate, pat_card_no as nrcard, date(cons_time) as srvdate
FROM consultatii left join patients on pat_cnp=cons_cnp left join employees on pat_emp_stencil_no = emp_stencil_no left join providers on emp_pro_uic = pro_uic left join contracts on ctr_pro_uic = pro_uic and date(cons_time) between ctr_valid_from and ctr_valid_to
WHERE cons_id =
Warning: pg_num_fields(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 78
Notice: Undefined variable: arr in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 102
Warning: array_diff_key() [function.array-diff-key]: Argument #1 is not an array in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 102
Warning: Variable passed to each() is not an array or object in C:\Data\web\backup-si\simm\serv\data_functions.php on line 17
Notice: Undefined variable: srvdate in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 23
Notice: Undefined variable: cons_time in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: cons_id in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: cons_cnp in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: pat_cid in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: stencil in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: cons_msp_code in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: cons_rap_mscode in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: cons_rap_dgcode in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 121
Notice: Undefined variable: stencil in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: contractno in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: contracttype in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: reporttype in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: reportdate in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: insurancehouse in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: providercode in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: providername in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 123
Notice: Undefined variable: cons_id in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 124
Notice: Undefined variable: cons_cnp in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 124
Notice: Undefined variable: pat_cid in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 124
Notice: Undefined variable: cons_rap_mscode in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 124
Notice: Undefined variable: cons_msp_code in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 124
Notice: Undefined variable: srvdate in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 124
Notice: Undefined variable: stencil in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 124
Notice: Undefined variable: cons_rap_dgcode in C:\Data\web\backup-si\simm\serv\validare_consultatie.php.f5h on line 128
Warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near ","
LINE 1: ...s_code,psrv_dg_icd9_code,psrv_req_xml) VALUES ('',,'','','',...
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: INSERT INTO pat_services (psrv_time,psrv_cons_id,psrv_cnp,psrv_pid, psrv_stencil, psrv_msp_code,psrv_ms_code,psrv_dg_icd9_code,psrv_req_xml) VALUES ('',,'','','','','','',
'
') RETURNING psrv_id
Warning: pg_num_fields(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 78
Notice: Undefined variable: arr in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 102
Warning: array_diff_key() [function.array-diff-key]: Argument #1 is not an array in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 102
Warning: Variable passed to each() is not an array or object in C:\Data\web\backup-si\simm\serv\data_functions.php on line 17