Notice: Undefined variable: pcoid in C:\Data\web\backup-si\simm\pdf\concediu.php.bak on line 108
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: ""
LINE 20: where pco_id=''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: select pco_mce_code as urgenta,pco_icd_code as infectioase,case when pco_continuare=true then 'X' else '' end as continuu, case when pco_continuare=false then 'X' else '' end as initial, case when length(trim(pco_prev_serial_code))>0 then pco_prev_serial_no else '' end as serie_initial, pco_month as luna, substring(pco_year::text,3,2) as an, pco_sli_code as indemnizatie, pat_last_name || ' ' || pat_first_name as nume_prenume, ou_name as "CAS",pat_cnp as "CNP", pat_ou_code as "cu_CAS",pat_fisa as fisa, pat_emp_stencil_no as parafa, addr_cit_code as cod_loc,addr_dst_code as cod_judet,
case when length(addr_stt_code)>0 then addr_stt_code || ' ' || addr_st_name else addr_st_name end as strada,addr_street_no as nr,addr_building as bloc,addr_entrance as scara,addr_floor as etaj,addr_apartment as ap,
a.cit_name as localitate, ja.dst_name as judet, pco_cons_reg_no as inregistrare, substr(pco_amb_date::text,9,2) || substr(pco_amb_date::text,6,2) || substr(pco_amb_date::text,3,2) as data_acordare, substr(pco_from::text,9,2) || substr(pco_from::text,6,2) || substr(pco_from::text,3,2) as de_la, substr(pco_to::text,9,2) || substr(pco_to::text,6,2) || substr(pco_to::text,3,2) as pana_la, pco_days_no as nr_zile, pco_icd10_code as diagnostic, case when pco_dgt_code='0' then 'X' else '' end as acut, case when pco_dgt_code='1' then 'X' else '' end as subacut, case when pco_dgt_code='2' then 'X' else '' end as cronic, pco_conv_code as conventie,
-- ctr_contract_no as contract,ctr_category_code as categ_contract,emp_cnp as cnpmedic ,
pro_uic as "CUI", pro_name as unitatea
--, 'Adresa: ' || jb.dst_name || ' - ' || b.cit_name || ', ' || proad_st_name || ' ' || proad_street_no as uaddr, jb.dst_name as ujud, ctr_ou_code as cas_contract
from patients
inner join pat_concedii on pat_cnp=pco_pat_cnp
left join org_units on pat_ou_code=ou_code
left join addresses on pat_addr_id=addr_id
left join cities a on addr_cit_code=a.cit_code
left join streets on (addr_st_name=st_name and addr_cit_code=st_cit_code)
left join districts ja on addr_dst_code=ja.dst_code
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on emp_pro_uic=ctr_pro_uic
left join providers on emp_pro_uic=pro_uic
left join provider_addresses on (pro_uic=proad_pro_uic and proad_activ=true)
left join cities b on proad_cit_code=b.cit_code
left join districts jb on b.cit_dst_code=jb.dst_code
where pco_id=''
and emp_valid_from=(select min(emp_valid_from) from employees where emp_stencil_no=pat_emp_stencil_no)
and ctr_valid_to=(select max(ctr_valid_to) from contracts where ctr_pro_uic=emp_pro_uic)
limit 1
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
FPDF error: Some data has already been output, can't send PDF file