Notice: Undefined variable: emp_first_name in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 17
Notice: Undefined variable: emp_last_name in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 17
Notice: Undefined variable: anrap in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 19
Notice: Undefined variable: lunarap in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 19
Notice: Undefined variable: lunarap in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 23
Notice: Undefined variable: anrap in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 23
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 34
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 35
Notice: Undefined variable: cnpmedic in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 64
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "servnom2010" does not exist
LINE 23: from servnom2010
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: select
sn_cnp as cnp,
sn_nume as nume,
sn_prenume as prenume,
case when sn_strain=true then 'T' else 'F' end as strain,
substr(sn_datan::text,1,4) || substr(sn_datan::text,6,2) || substr(sn_datan::text,9,2) as datan,
sn_sex as sex,
case when sn_facultativ=true then 'T' else 'F' end as facultativ,
case when sn_minimal=true then 'T' else 'F' end as minimal,
case when sn_cet_ue=true then 'T' else 'F' end as cet_ue,
substr(sn_cd1::text,1,4) || substr(sn_cd1::text,6,2) || substr(sn_cd1::text,9,2) as cd1,
sn_codcd as codcd,
substr(sn_cd2::text,1,4) || substr(sn_cd2::text,6,2) || substr(sn_cd2::text,9,2) as cd2,
substr(sn_cc::text,1,4) || substr(sn_cc::text,6,2) || substr(sn_cc::text,9,2) as cc,
sn_codcc as codcc,
substr(sn_ca1::text,1,4) || substr(sn_ca1::text,6,2) || substr(sn_ca1::text,9,2) as ca1,
sn_codca as codca,
substr(sn_ca2::text,1,4) || substr(sn_ca2::text,6,2) || substr(sn_ca2::text,9,2) as ca2,
substr(sn_ca3::text,1,4) || substr(sn_ca3::text,6,2) || substr(sn_ca3::text,9,2) as ca3,
sn_luna as luna,
sn_an as an,
sn_cnpmedic as cnpmedic
from servnom2010
-- left join patients on sn_cnp=pat_cnp
where sn_cnpmedic='' and sn_luna=0 and sn_an=0
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
Fatal error: Call to undefined function dbase_create() in C:\Data\web\backup-si\simm\dbf\sn2dbf.php on line 76