Notice: Undefined variable: emp_first_name in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 17

Notice: Undefined variable: emp_last_name in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 17

Notice: Undefined variable: anrap in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 19

Notice: Undefined variable: lunarap in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 19

Notice: Undefined variable: lunarap in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 24

Notice: Undefined variable: anrap in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 24

Notice: Undefined variable: lunarap in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 26

Notice: Undefined variable: anrap in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 26

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 30

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 31

Notice: Undefined variable: lunarap in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 34

Notice: Undefined variable: cnpmedic in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 37

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 37

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 37

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...r emp_valid_to>date(now())) and ctr_valid_from <= '' and (ct... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select emp_cnp as cnpmedic,emp_stencil_no as stencil,emp_last_name || ' ' || emp_first_name as medic,emp_pro_uic as uic,ctr_contract_no as contract, pro_name as unitatea, pro_attorney as reprezentant, case when pro_cmi='f' then 'SC' else '' end as formaorg, ou_name as cascontract,dst_name as ujud,cit_name as uloc, proad_st_name || ' nr. ' || proad_street_no as uaddr from employees left join contracts on emp_pro_uic=ctr_pro_uic left join providers on pro_uic=emp_pro_uic left join org_units on ctr_ou_code=ou_code left join provider_addresses on (proad_pro_id=pro_id and proad_activ=true) left join districts on proad_dst_code=dst_code left join cities on proad_cit_code=cit_code where emp_cnp='' and (emp_valid_to is null or emp_valid_to>date(now())) and ctr_valid_from <= '' and (ctr_valid_to is null or ctr_valid_to >= '')
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: Variable passed to each() is not an array or object in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 40

Notice: Undefined variable: stencil in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 41

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 45

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 45

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 46

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 46

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 47

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 47

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 49

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 49

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 50

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 50

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 52

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 52

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 53

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 53

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 54

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 54

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 55

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 55

Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 56

Notice: Undefined variable: to in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 56

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...ents on pat_cnp=pr_pat_cnp where pr_date between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(pr_date::text,9,2)::int as zi,count(*) as nr from prescriptions inner join patients on pat_cnp=pr_pat_cnp where pr_date between '' and '' and pat_emp_stencil_no='' and pr_id in (select distinct prit_pr_id from prescription_items where prit_clt_copayment_percent=100) group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...ents on pat_cnp=pr_pat_cnp where pr_date between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(pr_date::text,9,2)::int as zi,count(*) as nr from prescriptions inner join patients on pat_cnp=pr_pat_cnp where pr_date between '' and '' and pat_emp_stencil_no='' and pr_id in (select distinct prit_pr_id from prescription_items where prit_clt_copayment_percent<100) group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...re cons_referat=true and date(cons_time) between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(cons_time::text,9,2)::int as zi,count(*) as nr from consultatii inner join patients on pat_cnp=cons_cnp where cons_referat=true and date(cons_time) between '' and '' and pat_emp_stencil_no='' group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ... pat_cnp=cons_cnp where date(cons_time) between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(cons_time::text,9,2)::int as zi,count(*) as nr from consultatii inner join patients on pat_cnp=cons_cnp where date(cons_time) between '' and '' and pat_emp_stencil_no='' and cons_anulat=false group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...r srv_ms_code='B14') and date(cons_time) between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(cons_time::text,9,2)::int as zi,count(*) as nr from consultatii inner join patients on pat_cnp=cons_cnp left join services on cons_id=srv_cons_id and srv_ms_code='B14' where (cons_b22=true or srv_ms_code='B14') and date(cons_time) between '' and '' and pat_emp_stencil_no='' and cons_anulat=false group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...t_cnp where mn_mnt_code='1' and mn_date between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(mn_date::text,9,2)::int as zi,count(*) as nr from medical_notes inner join patients on pat_cnp=mn_pat_cnp where mn_mnt_code='1' and mn_date between '' and '' and pat_emp_stencil_no='' group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...t_cnp where mn_mnt_code='9' and mn_date between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(mn_date::text,9,2)::int as zi,count(*) as nr from medical_notes inner join patients on pat_cnp=mn_pat_cnp where mn_mnt_code='9' and mn_date between '' and '' and pat_emp_stencil_no='' group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...t_cnp where mn_mnt_code='2' and mn_date between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(mn_date::text,9,2)::int as zi,count(*) as nr from medical_notes inner join patients on pat_cnp=mn_pat_cnp where mn_mnt_code='2' and mn_date between '' and '' and pat_emp_stencil_no='' group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...like '%POLICLINICA%' and date(cons_time) between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(cons_time::text,9,2)::int as zi,count(*) as nr from consultatii inner join medical_letters on cons_id=ml_cons_id inner join patients on pat_cnp=ml_pat_cnp where ml_type ilike '%POLICLINICA%' and date(cons_time) between '' and '' and pat_emp_stencil_no='' group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: "" LINE 1: ...ype ilike '%SPITAL%' and date(cons_time) between '' and '' ... ^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55

Query esuat: select substring(cons_time::text,9,2)::int as zi,count(*) as nr from consultatii inner join medical_letters on cons_id=ml_cons_id inner join patients on pat_cnp=ml_pat_cnp where ml_type ilike '%SPITAL%' and date(cons_time) between '' and '' and pat_emp_stencil_no='' group by zi order by zi
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: pg_free_result(): supplied argument is not a valid PostgreSQL result resource in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 120

Notice: Undefined variable: cnpmedic in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 133

Fatal error: Call to undefined function dbase_create() in C:\Data\web\backup-si\simm\dbf\ret2dbf.php on line 143