Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 8
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 8
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 1: delete from services where srv_date between '' and '' and sr...
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: delete from services where srv_date between '' and '' and srv_ms_code in ('B3','B4','B2.1','B2.2','B2.3','B2.4','B2.5','B2.6','B2.7','B2.8','B2.9','B2.10','B2.11','B15','B16','B16A','B19','B20','B21','B23','B10.4','S2','B7.11','S5.2','S8.06','S8.07','S8.08','S8.09','S8.10','S8.11','S8.12','S8.13','S8.14','S8.15','S8.16','S9','S10','S5.01','S5.02','S5.03','S5.04','S11','S15.01','S15.02','S15.03')
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 18
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 18
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 19
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 19
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 22
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 22
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 23
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 23
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 24
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 24
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 25
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 25
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 26
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 7: where (emp_valid_to is null or emp_valid_to>='') and ctr_va...
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select distinct ev_cons_id,ctr_contract_no,pat_cnp, CASE WHEN length(ev_rms_code) > 2 THEN ev_rms_code ELSE ev_ms_code END as ms_code, 'BAZA',ev_data,emp_stencil_no,'1' from employees
left join contracts on emp_pro_uic=ctr_pro_uic
inner join patients on pat_emp_stencil_no=emp_stencil_no
inner join patients_data on pat_cnp=patd_cnp
inner join reg_evaluari on ev_pat_cnp=pat_cnp
where (emp_valid_to is null or emp_valid_to>='') and ctr_valid_from <= '' and (ctr_valid_to is null or ctr_valid_to >= '')
and ev_data between '' and ''
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= ev_data)
--and ev_ms_code ilike 'B2.%'
and ((pat_cnp,ev_data,ev_ms_code ) not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date between '' and ''))
--and pat_cnp not in (select srv_pat_cnp from services where srv_date between '' and '' and srv_ms_code not like 'B1.%')
--and pat_cnp not in (select rcs_pat_cnp from reg_controale_sarcina where rcs_date between '' and '' and rcs_ms_code like 'B%')
--and pat_cnp not in (select cons_cnp from consultatii where date(cons_time) between '' and '' and cons_rap_mscode in ('S5.2','S9','S10'))
order by pat_cnp;
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 96
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 96
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 96
Notice: Undefined variable: parafa in C:\Data\web\backup-si\simm\raport\prerap.php on line 98
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 6: ...in contracts on (emp_pro_uic=ctr_pro_uic and date('') betwee...
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select distinct pim_cons_id,cons_reg_no,ctr_contract_no,pim_pat_cnp,case when pim_ms_code='B1.T1' then 'B1.T1' else pim_ms_code end, case when substr(pim_ms_code,1,1)='B' then 'BAZA' when substr(pim_ms_code,1,1)='M' then 'MINIMAL' when substr(pim_ms_code,1,1)='F' then 'FACULTATIV' end ,pim_date_imm,pat_emp_stencil_no,'1'
from pat_immunizations
inner join patients on pat_cnp=pim_pat_cnp
inner join consultatii on cons_id=pim_cons_id
inner join employees on pat_emp_stencil_no=emp_stencil_no inner join contracts on (emp_pro_uic=ctr_pro_uic and date('') between ctr_valid_from and ctr_valid_to)
where pim_date_imm between '' and '' and pat_emp_stencil_no=''
and (pim_pat_cnp,pim_ms_code) not in (select srv_pat_cnp,srv_ms_code from services where srv_date=pim_date_imm)
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 112
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 115
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 9: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select cons_id,cons_reg_no,ctr_contract_no,cons_cnp,cons_rap_mscode as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where cons_rap_mscode in ('S10','S9','S5.2','S5.01','S5.02','S5.03','S11','S5.04','S5.05','S5.06','S5.07','S5.08','S10.01','S10.02','S10.03')
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date( cons_time),cons_rap_mscode) not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp;
Notice: Undefined variable: parafa in C:\Data\web\backup-si\simm\raport\prerap.php on line 124
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 126
Notice: Undefined variable: from in C:\Data\web\backup-si\simm\raport\prerap.php on line 126
Notice: Undefined variable: to in C:\Data\web\backup-si\simm\raport\prerap.php on line 128
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 6: ...n contracts on ctr_pro_uic=emp_pro_uic and ctr_valid_to > ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select distinct
rcs_cons_id,cons_reg_no,ctr_contract_no,pat_cnp,rcs_ms_code,rcs_msp_code,rcs_date,pat_emp_stencil_no,'1'
from reg_controale_sarcina inner join patients on rcs_pat_cnp=pat_cnp and pat_emp_stencil_no=''
inner join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic and ctr_valid_to > ''
left join consultatii on rcs_cons_id=cons_id
where rcs_date between '' and ''
and length(rcs_ms_code)>2
and (pat_cnp,rcs_date,rcs_ms_code) not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=rcs_date)
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B15' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b15=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B15') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B16' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b16=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B16') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B16A' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b16a=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B16A') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B17' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b17=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B17') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B19' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b19=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B19') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B20' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b20=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B20') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B21' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b21=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B21') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B23' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b23=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B23') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B24' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b24=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B24') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B25' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b25=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B25') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B10.4' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b10_4=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B10.4') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type date: ""
LINE 10: and ctr_valid_to >= ''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: insert into services(srv_cons_id,srv_cons_reg_no,srv_ctr_contract_no,srv_pat_cnp,srv_ms_code,srv_msp_code,srv_date,srv_emp_stencil_no,srv_quantity)
select DISTINCT on (cons_cnp || date(cons_time)::text)
cons_id,cons_reg_no,ctr_contract_no,cons_cnp,'B7.11' as ms_code,'BAZA' as srv_pkg,date( cons_time) as date,pat_emp_stencil_no as stencil,1 as quantity from consultatii as a
inner join patients_data on cons_cnp=patd_cnp
inner join patients on cons_cnp=pat_cnp
left join employees on emp_stencil_no=pat_emp_stencil_no
left join contracts on ctr_pro_uic=emp_pro_uic
where (cons_b7_11=true)
and patd_entry_date is not null and (patd_exit_date is null or patd_exit_date <= date( cons_time))
and ctr_valid_to >= ''
and (emp_valid_to is null or emp_valid_to >='')
and (pat_cnp,date(cons_time),'B7.11') not in (select srv_pat_cnp,srv_date,srv_ms_code from services where srv_date=date(cons_time))
order by cons_cnp || date(cons_time)::text;
Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "servnom2010" does not exist
LINE 1: select * from servnom2010 where sn_cnpmedic=''
^ in C:\Data\web\backup-si\simm\serv\db_pgsql.php on line 55
Query esuat: select * from servnom2010 where sn_cnpmedic=''
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
| Servicii |
|---|
| CNP | Data | Cod Serviciu | Observaţii |
|---|