◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 00:26:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17878461195</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_骨科刘清和特需号</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>232700196911106042</patientidcard><patientname>彭莉</patientname><patientsex>女</patientsex><patientbirthday>1969-11-10</patientbirthday><medicalrecord></medicalrecord><contactphone>17878461195</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 00:26:41
记录内容：select * from  pat_master_index where id_no='232700196911106042' and name='彭莉' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1969/11/10 0:00:0056
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 00:26:41
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '骨科刘清和特需号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 00:26:41
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7420,'骨科刘清和特需号','上午','4','10258557','彭莉','PENG LI','女','56','一般人员','自费','','特需号1','1','0312','CYLQH','1',to_date('2025/01/24 00:26:37','yyyy/mm/dd hh24:mi:ss'),'196','4','0.00','200','202501277420','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 00:26:41
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7420,'骨科刘清和特需号','上午','4','10258557','彭莉','PENG LI','女','56','一般人员','自费','','特需号1','1','0312','CYLQH','1',to_date('2025/01/24 00:26:37','yyyy/mm/dd hh24:mi:ss'),'196','4','0.00','200','202501277420','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/27', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘清和特需号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7420,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '骨科刘清和特需号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501277420</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>196</registrationfee><pinkey>202501277420</pinkey><ordertime>2025-01-24 00:26:41</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 04:34:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18331604171</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/6 0:00:00_上午_生殖男科富鹤</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199404010019</patientidcard><patientname>金瑶</patientname><patientsex>男</patientsex><patientbirthday>1994-04-01</patientbirthday><medicalrecord></medicalrecord><contactphone>18331604171</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 04:34:47
记录内容：select * from  pat_master_index where id_no='131028199404010019' and name='金瑶' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1994/4/1 0:00:0031
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 04:34:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/06','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 04:34:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/06','YYYY/MM/DD'),7580,'生殖男科富鹤','上午','1','100272329','金瑶','JIN YAO ','男','31','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2025/01/24 04:34:50','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502067580','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 04:34:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/06','YYYY/MM/DD'),7580,'生殖男科富鹤','上午','1','100272329','金瑶','JIN YAO ','男','31','一般人员','自费','','副主任号','1','0371','FH','1',to_date('2025/01/24 04:34:50','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502067580','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/02/06', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '生殖男科富鹤' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/02/06','YYYY/MM/DD'),7580,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/06','yyyy/mm/dd')
                    and clinic_label = '生殖男科富鹤' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202502067580</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202502067580</pinkey><ordertime>2025-01-24 04:34:47</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 06:03:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18632607975</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_心理咨询失眠李文</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028198510133528</patientidcard><patientname>刘微</patientname><patientsex>女</patientsex><patientbirthday>1985-10-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18632607975</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-24 06:03:47
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/25','YYYY-MM-DD')
            AND CLINIC_LABEL='心理咨询失眠李文' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='131028198510133528' and name='刘微' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 06:03:47
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 10:25:18
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15369642489</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_神经内科孔令辉</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028197003016824</patientidcard><patientname>杨玉芝</patientname><patientsex>女</patientsex><patientbirthday>1970-03-01</patientbirthday><medicalrecord></medicalrecord><contactphone>15369642489</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 10:25:18
记录内容：select * from  pat_master_index where id_no='131028197003016824' and name='杨玉芝' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/3/1 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 10:25:18
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '神经内科孔令辉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 10:25:18
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1682,'神经内科孔令辉','上午','1','10411591','杨玉芝','','女','55','一般人员','自费','','普通号','1','0303','KLH','1',to_date('2025/01/24 10:25:19','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501251682','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 10:25:18
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1682,'神经内科孔令辉','上午','1','10411591','杨玉芝','','女','55','一般人员','自费','','普通号','1','0303','KLH','1',to_date('2025/01/24 10:25:19','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501251682','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科孔令辉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1682,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '神经内科孔令辉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501251682</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501251682</pinkey><ordertime>2025-01-24 10:25:18</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 10:32:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15732178759</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_消化内科梁毅</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082197101150590</patientidcard><patientname>董建国</patientname><patientsex>男</patientsex><patientbirthday>1971-01-15</patientbirthday><medicalrecord></medicalrecord><contactphone>15732178759</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 10:32:03
记录内容：select * from  pat_master_index where id_no='131082197101150590' and name='董建国' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/1/15 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 10:32:03
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 10:32:03
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1845,'消化内科梁毅','上午','5','100158882','董建国','DONG JIAN GUO ','男','54','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/01/24 10:32:05','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501251845','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 10:32:03
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1845,'消化内科梁毅','上午','5','100158882','董建国','DONG JIAN GUO ','男','54','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/01/24 10:32:05','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501251845','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科梁毅' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1845,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501251845</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501251845</pinkey><ordertime>2025-01-24 10:32:03</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 10:37:01
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18859812113</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_神经外科普通号</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>350427197507143013</patientidcard><patientname>吴大勇</patientname><patientsex>男</patientsex><patientbirthday>1975-07-14</patientbirthday><medicalrecord></medicalrecord><contactphone>18859812113</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 10:37:01
记录内容：select * from  pat_master_index where id_no='350427197507143013' and name='吴大勇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1975/7/14 0:00:0050
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 10:37:02
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '神经外科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 10:37:02
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1968,'神经外科普通号','上午','2','00436788','吴大勇','WU DA YONG','男','50','一般人员','自费','','普通号','1','0313','','1',to_date('2025/01/24 10:37:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501251968','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 10:37:02
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1968,'神经外科普通号','上午','2','00436788','吴大勇','WU DA YONG','男','50','一般人员','自费','','普通号','1','0313','','1',to_date('2025/01/24 10:37:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501251968','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经外科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),1968,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '神经外科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501251968</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501251968</pinkey><ordertime>2025-01-24 10:37:02</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 11:16:55
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15210339829</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_儿科刘双英</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>410526201903050235</patientidcard><patientname>郭家瑞</patientname><patientsex>男</patientsex><patientbirthday>2019-03-05</patientbirthday><medicalrecord></medicalrecord><contactphone>15210339829</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 11:16:55
记录内容：select * from  pat_master_index where id_no='410526201903050235' and name='郭家瑞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2019/3/5 0:00:006
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:16:55
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '儿科刘双英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:16:55
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),2888,'儿科刘双英','上午','1','10699387','郭家瑞','','男','6','一般人员','自费','','知名专家','1','0304','LIUSY','1',to_date('2025/01/24 11:16:56','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501262888','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 11:16:55
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),2888,'儿科刘双英','上午','1','10699387','郭家瑞','','男','6','一般人员','自费','','知名专家','1','0304','LIUSY','1',to_date('2025/01/24 11:16:56','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501262888','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科刘双英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/26','YYYY/MM/DD'),2888,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '儿科刘双英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501262888</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501262888</pinkey><ordertime>2025-01-24 11:16:55</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 11:24:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13720078320</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_产科张洪英</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230125199211011823</patientidcard><patientname>倪美苹</patientname><patientsex>女</patientsex><patientbirthday>1992-11-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13720078320</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 11:24:28
记录内容：select * from  pat_master_index where id_no='230125199211011823' and name='倪美苹' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1992/11/1 0:00:0033
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:24:28
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:24:28
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),3018,'产科张洪英','上午','2','100302336','倪美苹','NI MEI PING ','女','33','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2025/01/24 11:24:29','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501273018','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 11:24:28
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),3018,'产科张洪英','上午','2','100302336','倪美苹','NI MEI PING ','女','33','一般人员','自费','','副主任号','1','0330','ZHY02','1',to_date('2025/01/24 11:24:29','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501273018','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/27', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科张洪英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/27','YYYY/MM/DD'),3018,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '产科张洪英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501273018</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501273018</pinkey><ordertime>2025-01-24 11:24:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 11:27:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13718573273</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_下午_产科王振燕</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>350500199303255544</patientidcard><patientname>陈婷婷</patientname><patientsex>女</patientsex><patientbirthday>1993-03-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13718573273</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 11:27:15
记录内容：select * from  pat_master_index where id_no='350500199303255544' and name='陈婷婷' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/3/25 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:27:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:27:15
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3070,'产科王振燕','下午','2','100466588','陈婷婷','CHEN   ','女','32','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 11:27:16','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501253070','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 11:27:15
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3070,'产科王振燕','下午','2','100466588','陈婷婷','CHEN   ','女','32','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 11:27:16','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501253070','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3070,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202501253070</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501253070</pinkey><ordertime>2025-01-24 11:27:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 11:27:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15210339829</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>410526201903050235</patientidcard><patientname>郭家瑞</patientname><patientsex>男</patientsex><patientbirthday>2019-03-05</patientbirthday><medicalrecord></medicalrecord><contactphone>15210339829</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 11:27:49
记录内容：select * from  pat_master_index where id_no='410526201903050235' and name='郭家瑞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2019/3/5 0:00:006
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:27:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:27:49
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3081,'儿科陈云平','上午','1','10699387','郭家瑞','','男','6','一般人员','自费','','知名专家','1','0304','CYP11','1',to_date('2025/01/24 11:27:50','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501253081','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 11:27:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3081,'儿科陈云平','上午','1','10699387','郭家瑞','','男','6','一般人员','自费','','知名专家','1','0304','CYP11','1',to_date('2025/01/24 11:27:50','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501253081','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3081,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501253081</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501253081</pinkey><ordertime>2025-01-24 11:27:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 11:40:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15701268920</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_白天_妇科李二雷</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>371581199301170048</patientidcard><patientname>柳冰源</patientname><patientsex>女</patientsex><patientbirthday>1993-01-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15701268920</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 11:40:13
记录内容：select * from  pat_master_index where id_no='371581199301170048' and name='柳冰源' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/1/17 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:40:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '妇科李二雷' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 11:40:13
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3240,'妇科李二雷','白天','3','10577587','柳冰源','','女','32','一般人员','自费','','副主任号','1','0316','LIEL','1',to_date('2025/01/24 11:40:14','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501253240','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 11:40:13
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3240,'妇科李二雷','白天','3','10577587','柳冰源','','女','32','一般人员','自费','','副主任号','1','0316','LIEL','1',to_date('2025/01/24 11:40:14','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501253240','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科李二雷' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3240,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '妇科李二雷' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501253240</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501253240</pinkey><ordertime>2025-01-24 11:40:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 12:08:12
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13261062203</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_泌尿外科田惠忠</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130828198910018011</patientidcard><patientname>徐兵</patientname><patientsex>男</patientsex><patientbirthday>1989-10-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13261062203</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 12:08:13
记录内容：select * from  pat_master_index where id_no='130828198910018011' and name='徐兵' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/10/1 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 12:08:13
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '泌尿外科田惠忠' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 12:08:13
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3475,'泌尿外科田惠忠','上午','3','100360691','徐兵','XU BING ','男','36','一般人员','自费','','CY主任号','1','0311','CYTHZ','1',to_date('2025/01/24 12:08:13','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501253475','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 12:08:13
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3475,'泌尿外科田惠忠','上午','3','100360691','徐兵','XU BING ','男','36','一般人员','自费','','CY主任号','1','0311','CYTHZ','1',to_date('2025/01/24 12:08:13','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501253475','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科田惠忠' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3475,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '泌尿外科田惠忠' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501253475</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501253475</pinkey><ordertime>2025-01-24 12:08:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 12:46:50
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18633427187</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_下午_消化内科刘正新</scheduleid><parttimeid>16:00-16:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082198010110010</patientidcard><patientname>姚国文</patientname><patientsex>男</patientsex><patientbirthday>1980-10-11</patientbirthday><medicalrecord></medicalrecord><contactphone>18633427187</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 12:46:50
记录内容：select * from  pat_master_index where id_no='131082198010110010' and name='姚国文' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1980/10/11 0:00:0045
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 12:46:50
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '消化内科刘正新' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 12:46:50
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),3574,'消化内科刘正新','下午','3','100466616','姚国文','YAO GUO WEN ','男','45','一般人员','自费','','CY知名专','1','0302','CYLZX','1',to_date('2025/01/24 12:46:50','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501273574','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 12:46:50
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),3574,'消化内科刘正新','下午','3','100466616','姚国文','YAO GUO WEN ','男','45','一般人员','自费','','CY知名专','1','0302','CYLZX','1',to_date('2025/01/24 12:46:50','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501273574','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/27', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科刘正新' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/27','YYYY/MM/DD'),3574,'16:00-16:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '消化内科刘正新' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202501273574</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501273574</pinkey><ordertime>2025-01-24 12:46:50</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 12:49:32
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15003160653</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200610227116</patientidcard><patientname>李胤彤</patientname><patientsex>男</patientsex><patientbirthday>2006-10-22</patientbirthday><medicalrecord></medicalrecord><contactphone>15003160653</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 12:49:32
记录内容：select * from  pat_master_index where id_no='131082200610227116' and name='李胤彤' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/10/22 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 12:49:32
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 12:49:32
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3581,'内分泌科马伟杰','上午','1','10074639','李胤彤','','男','19','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/01/24 12:49:33','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501253581','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 12:49:32
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3581,'内分泌科马伟杰','上午','1','10074639','李胤彤','','男','19','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/01/24 12:49:33','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501253581','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3581,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501253581</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501253581</pinkey><ordertime>2025-01-24 12:49:32</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 13:06:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18801263341</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_下午_呼吸内科高立静</scheduleid><parttimeid>15:00-15:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23082219700813115X</patientidcard><patientname>赵国胜</patientname><patientsex>男</patientsex><patientbirthday>1970-08-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18801263341</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 13:06:49
记录内容：select * from  pat_master_index where id_no='23082219700813115X' and name='赵国胜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/8/13 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:06:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:06:49
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),3701,'呼吸内科高立静','下午','1','100363004','赵国胜','ZHAO GUO SHENG ','男','55','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/24 13:06:50','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501263701','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 13:06:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),3701,'呼吸内科高立静','下午','1','100363004','赵国胜','ZHAO GUO SHENG ','男','55','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/24 13:06:50','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501263701','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/26','YYYY/MM/DD'),3701,'15:00-15:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202501263701</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501263701</pinkey><ordertime>2025-01-24 13:06:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 13:08:17
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15901483731</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_下午_皮肤科普通号</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>222401198603021239</patientidcard><patientname>金雄豪</patientname><patientsex>男</patientsex><patientbirthday>1986-03-02</patientbirthday><medicalrecord></medicalrecord><contactphone>15901483731</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 13:08:17
记录内容：select * from  pat_master_index where id_no='222401198603021239' and name='金雄豪' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/3/2 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:08:17
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '皮肤科普通号' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:08:17
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3715,'皮肤科普通号','下午','20','Z00219427','金雄豪','','男','39','一般人员','自费','','普通号','1','0318','','1',to_date('2025/01/24 13:08:18','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501253715','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 13:08:17
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3715,'皮肤科普通号','下午','20','Z00219427','金雄豪','','男','39','一般人员','自费','','普通号','1','0318','','1',to_date('2025/01/24 13:08:18','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501253715','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科普通号' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3715,'13:30-14:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '皮肤科普通号' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202501253715</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501253715</pinkey><ordertime>2025-01-24 13:08:17</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 13:20:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18611960879</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_产科王振燕</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199701060020</patientidcard><patientname>陈爽</patientname><patientsex>女</patientsex><patientbirthday>1997-01-06</patientbirthday><medicalrecord></medicalrecord><contactphone>18611960879</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 13:20:31
记录内容：select * from  pat_master_index where id_no='131028199701060020' and name='陈爽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1997/1/6 0:00:0028
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:20:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:20:31
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3883,'产科王振燕','上午','9','100463869','陈爽','CHEN SHUANG ','女','28','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 13:20:32','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501253883','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 13:20:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3883,'产科王振燕','上午','9','100463869','陈爽','CHEN SHUANG ','女','28','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 13:20:32','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501253883','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),3883,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501253883</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501253883</pinkey><ordertime>2025-01-24 13:20:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 13:57:04
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13194545321</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>239821195602020965</patientidcard><patientname>邵云</patientname><patientsex>女</patientsex><patientbirthday>1956-02-02</patientbirthday><medicalrecord></medicalrecord><contactphone>13194545321</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 13:57:05
记录内容：select * from  pat_master_index where id_no='239821195602020965' and name='邵云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1956/2/2 0:00:0069
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:57:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 13:57:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4452,'骨科刘海峰','上午','2','100352826','邵云','SHAO YUN','女','69','一般人员','自费','','副主任号','1','0312','LIUHF','1',to_date('2025/01/24 13:57:05','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501254452','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 13:57:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4452,'骨科刘海峰','上午','2','100352826','邵云','SHAO YUN','女','69','一般人员','自费','','副主任号','1','0312','LIUHF','1',to_date('2025/01/24 13:57:05','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501254452','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4452,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501254452</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501254452</pinkey><ordertime>2025-01-24 13:57:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 14:06:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17640089293</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_白天_妇科王兰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230224199612203526</patientidcard><patientname>李一楠</patientname><patientsex>女</patientsex><patientbirthday>1996-12-20</patientbirthday><medicalrecord></medicalrecord><contactphone>17640089293</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 14:06:38
记录内容：select * from  pat_master_index where id_no='230224199612203526' and name='李一楠' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/12/20 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:06:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:06:38
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),4609,'妇科王兰','白天','2','00400154','李一楠','LI YI NAN','女','29','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/01/24 14:06:39','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501264609','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 14:06:39
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),4609,'妇科王兰','白天','2','00400154','李一楠','LI YI NAN','女','29','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/01/24 14:06:39','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501264609','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科王兰' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/26','YYYY/MM/DD'),4609,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '妇科王兰' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501264609</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501264609</pinkey><ordertime>2025-01-24 14:06:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 14:26:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15010266180</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_产科王振燕</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>62282719930120494X</patientidcard><patientname>卢莉珍</patientname><patientsex>女</patientsex><patientbirthday>1993-01-20</patientbirthday><medicalrecord></medicalrecord><contactphone>15010266180</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 14:26:29
记录内容：select * from  pat_master_index where id_no='62282719930120494X' and name='卢莉珍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/1/20 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:26:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:26:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4927,'产科王振燕','上午','10','10391285','卢莉珍','LU LI ZHEN','女','32','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 14:26:30','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501254927','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 14:26:30
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4927,'产科王振燕','上午','10','10391285','卢莉珍','LU LI ZHEN','女','32','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 14:26:30','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501254927','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','10') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4927,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501254927</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501254927</pinkey><ordertime>2025-01-24 14:26:30</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 14:31:24
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15642885510</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_产科王振燕</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>210726198908183941</patientidcard><patientname>王佳</patientname><patientsex>女</patientsex><patientbirthday>1989-08-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15642885510</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 14:31:24
记录内容：select * from  pat_master_index where id_no='210726198908183941' and name='王佳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/8/18 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:31:24
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:31:24
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4995,'产科王振燕','上午','11','Z00418056','王佳','','女','36','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 14:31:24','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501254995','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','11') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 14:31:24
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4995,'产科王振燕','上午','11','Z00418056','王佳','','女','36','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/24 14:31:24','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501254995','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','11') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),4995,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501254995</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501254995</pinkey><ordertime>2025-01-24 14:31:24</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 14:45:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13935300611</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_皮肤科杨维玲</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>140302195901130017</patientidcard><patientname>赵新乡</patientname><patientsex>男</patientsex><patientbirthday>1959-01-13</patientbirthday><medicalrecord></medicalrecord><contactphone>13935300611</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 14:45:14
记录内容：select * from  pat_master_index where id_no='140302195901130017' and name='赵新乡' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1959/1/13 0:00:0066
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:45:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 14:45:14
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),5235,'皮肤科杨维玲','上午','8','100466630','赵新乡','ZHAO XIN XIANG ','男','66','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/01/24 14:45:14','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501265235','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 14:45:14
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),5235,'皮肤科杨维玲','上午','8','100466630','赵新乡','ZHAO XIN XIANG ','男','66','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/01/24 14:45:14','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501265235','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科杨维玲' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/26','YYYY/MM/DD'),5235,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '皮肤科杨维玲' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501265235</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501265235</pinkey><ordertime>2025-01-24 14:45:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 15:50:16
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13363609742</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_下午_骨科普通号</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23080420060429001X</patientidcard><patientname>李澎铠</patientname><patientsex>男</patientsex><patientbirthday>2006-04-29</patientbirthday><medicalrecord></medicalrecord><contactphone>13363609742</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 15:50:16
记录内容：select * from  pat_master_index where id_no='23080420060429001X' and name='李澎铠' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2006/4/29 0:00:0019
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 15:50:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '骨科普通号' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 15:50:16
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6158,'骨科普通号','下午','1','10508476','李澎铠','','男','19','一般人员','自费','','普通号','1','0312','','1',to_date('2025/01/24 15:50:16','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501256158','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 15:50:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6158,'骨科普通号','下午','1','10508476','李澎铠','','男','19','一般人员','自费','','普通号','1','0312','','1',to_date('2025/01/24 15:50:16','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501256158','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科普通号' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6158,'13:00-13:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '骨科普通号' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202501256158</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501256158</pinkey><ordertime>2025-01-24 15:50:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 15:56:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18701182556</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_产科辛俊英</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>141122199107220043</patientidcard><patientname>司青青</patientname><patientsex>女</patientsex><patientbirthday>1991-07-22</patientbirthday><medicalrecord></medicalrecord><contactphone>18701182556</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 15:56:09
记录内容：select * from  pat_master_index where id_no='141122199107220043' and name='司青青' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/7/22 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 15:56:09
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 15:56:09
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),6230,'产科辛俊英','上午','8','100466417','司青青','SI QING QING ','女','34','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/24 15:56:08','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501266230','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 15:56:09
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),6230,'产科辛俊英','上午','8','100466417','司青青','SI QING QING ','女','34','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/24 15:56:08','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501266230','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科辛俊英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/26','YYYY/MM/DD'),6230,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501266230</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501266230</pinkey><ordertime>2025-01-24 15:56:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 16:03:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19818688212</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>210922197404153926</patientidcard><patientname>赵明艳</patientname><patientsex>女</patientsex><patientbirthday>1974-04-15</patientbirthday><medicalrecord></medicalrecord><contactphone>19818688212</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 16:03:52
记录内容：select * from  pat_master_index where id_no='210922197404153926' and name='赵明艳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/4/15 0:00:0051
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:03:52
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:03:52
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6312,'内分泌科马伟杰','上午','3','100449573','赵明艳','ZHAO MING YAN','女','51','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/01/24 16:03:52','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501256312','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 16:03:52
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6312,'内分泌科马伟杰','上午','3','100449573','赵明艳','ZHAO MING YAN','女','51','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/01/24 16:03:52','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501256312','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6312,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501256312</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501256312</pinkey><ordertime>2025-01-24 16:03:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 16:21:53
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>16621071551</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_泌尿外科普通号</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>152104199910183819</patientidcard><patientname>刘德铭</patientname><patientsex>男</patientsex><patientbirthday>1999-10-18</patientbirthday><medicalrecord></medicalrecord><contactphone>16621071551</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 16:21:53
记录内容：select * from  pat_master_index where id_no='152104199910183819' and name='刘德铭' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1999/10/18 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:21:53
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '泌尿外科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:21:53
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6536,'泌尿外科普通号','上午','3','100466655','刘德铭','LIU DE MING ','男','26','一般人员','自费','','普通号','1','0311','','1',to_date('2025/01/24 16:21:53','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501256536','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 16:21:53
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6536,'泌尿外科普通号','上午','3','100466655','刘德铭','LIU DE MING ','男','26','一般人员','自费','','普通号','1','0311','','1',to_date('2025/01/24 16:21:53','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501256536','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6536,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '泌尿外科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501256536</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501256536</pinkey><ordertime>2025-01-24 16:21:53</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 16:40:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18813064492</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_产科辛俊英</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>211021199610100029</patientidcard><patientname>勾湖阳</patientname><patientsex>女</patientsex><patientbirthday>1996-10-10</patientbirthday><medicalrecord></medicalrecord><contactphone>18813064492</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 16:40:49
记录内容：select * from  pat_master_index where id_no='211021199610100029' and name='勾湖阳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1996/10/10 0:00:0029
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:40:49
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:40:49
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),6695,'产科辛俊英','上午','9','100137057','勾湖阳','GOU HU YANG ','女','29','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/24 16:40:48','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501266695','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 16:40:49
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),6695,'产科辛俊英','上午','9','100137057','勾湖阳','GOU HU YANG ','女','29','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/24 16:40:48','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501266695','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','7') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科辛俊英' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/26','YYYY/MM/DD'),6695,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '产科辛俊英' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501266695</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501266695</pinkey><ordertime>2025-01-24 16:40:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 16:54:27
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13691118335</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_心理咨询失眠李文</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>370702195001192620</patientidcard><patientname>韩冰清</patientname><patientsex>女</patientsex><patientbirthday>1950-01-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13691118335</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 16:54:27
记录内容：select * from  pat_master_index where id_no='370702195001192620' and name='韩冰清' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1950/1/19 0:00:0075
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:54:27
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 16:54:27
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6832,'心理咨询失眠李文','上午','5','10725506','韩冰清','','女','75','一般人员','自费','','CY副主任','1','0360','CYLW','1',to_date('2025/01/24 16:54:26','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501256832','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 16:54:27
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6832,'心理咨询失眠李文','上午','5','10725506','韩冰清','','女','75','一般人员','自费','','CY副主任','1','0360','CYLW','1',to_date('2025/01/24 16:54:26','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501256832','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心理咨询失眠李文' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6832,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '心理咨询失眠李文' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501256832</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501256832</pinkey><ordertime>2025-01-24 16:54:27</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 17:58:08
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13522985020</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_消化内科梁毅</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>512530198012187620</patientidcard><patientname>唐朝宣</patientname><patientsex>女</patientsex><patientbirthday>1980-12-18</patientbirthday><medicalrecord></medicalrecord><contactphone>13522985020</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 17:58:08
记录内容：select * from  pat_master_index where id_no='512530198012187620' and name='唐朝宣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1980/12/18 0:00:0045
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 17:58:08
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 17:58:08
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6926,'消化内科梁毅','上午','7','10339126','唐朝宣','TANG CHAO XUAN','女','45','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/01/24 17:58:07','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501256926','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 17:58:08
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6926,'消化内科梁毅','上午','7','10339126','唐朝宣','TANG CHAO XUAN','女','45','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/01/24 17:58:07','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501256926','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','6') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科梁毅' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6926,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501256926</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501256926</pinkey><ordertime>2025-01-24 17:58:08</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 18:02:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15233695321</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_眼科刘淑琴</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130828198702175725</patientidcard><patientname>辛秀娟</patientname><patientsex>女</patientsex><patientbirthday>1987-02-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15233695321</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 18:02:16
记录内容：select * from  pat_master_index where id_no='130828198702175725' and name='辛秀娟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/2/17 0:00:0038
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:02:16
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '眼科刘淑琴' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:02:16
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6930,'眼科刘淑琴','上午','6','10059883','辛秀娟','','女','38','一般人员','自费','','知名专家','1','0327','LSQ','1',to_date('2025/01/24 18:02:15','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501256930','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 18:02:16
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6930,'眼科刘淑琴','上午','6','10059883','辛秀娟','','女','38','一般人员','自费','','知名专家','1','0327','LSQ','1',to_date('2025/01/24 18:02:15','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501256930','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科刘淑琴' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6930,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '眼科刘淑琴' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501256930</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501256930</pinkey><ordertime>2025-01-24 18:02:16</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 18:11:45
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15027592248</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_产科杨芳</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130221200101286828</patientidcard><patientname>高明霞</patientname><patientsex>女</patientsex><patientbirthday>2001-01-28</patientbirthday><medicalrecord></medicalrecord><contactphone>15027592248</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 18:11:45
记录内容：select * from  pat_master_index where id_no='130221200101286828' and name='高明霞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2001/1/28 0:00:0024
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:11:45
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '产科杨芳' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:11:45
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),6935,'产科杨芳','上午','12','100377734','高明霞','GAO MING XIA ','女','24','一般人员','自费','','普通号','1','0330','YANGF1','1',to_date('2025/01/24 18:11:44','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501276935','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 18:11:45
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),6935,'产科杨芳','上午','12','100377734','高明霞','GAO MING XIA ','女','24','一般人员','自费','','普通号','1','0330','YANGF1','1',to_date('2025/01/24 18:11:44','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501276935','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/27', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科杨芳' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/27','YYYY/MM/DD'),6935,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '产科杨芳' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501276935</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501276935</pinkey><ordertime>2025-01-24 18:11:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 18:12:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15910993810</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_消化内科梁毅</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>320923195704081226</patientidcard><patientname>蔡秀云</patientname><patientsex>女</patientsex><patientbirthday>1957-04-08</patientbirthday><medicalrecord></medicalrecord><contactphone>15910993810</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 18:12:57
记录内容：select * from  pat_master_index where id_no='320923195704081226' and name='蔡秀云' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1957/4/8 0:00:0068
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:12:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:12:57
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6937,'消化内科梁毅','上午','9','100458327','蔡秀云','CAI XIU YUN ','女','68','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/01/24 18:12:56','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501256937','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','8') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 18:12:58
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6937,'消化内科梁毅','上午','9','100458327','蔡秀云','CAI XIU YUN ','女','68','一般人员','自费','','主任号','1','0302','LIANGYI','1',to_date('2025/01/24 18:12:56','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501256937','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','8') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '消化内科梁毅' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6937,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '消化内科梁毅' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501256937</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501256937</pinkey><ordertime>2025-01-24 18:12:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 18:23:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13403342387</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_白天_影像科宇文谦</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130824198411283528</patientidcard><patientname>代敬敏</patientname><patientsex>女</patientsex><patientbirthday>1984-11-28</patientbirthday><medicalrecord></medicalrecord><contactphone>13403342387</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 18:23:29
记录内容：select * from  pat_master_index where id_no='130824198411283528' and name='代敬敏' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1984/11/28 0:00:0041
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:23:29
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '影像科宇文谦' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 18:23:29
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6955,'影像科宇文谦','白天','1','100466659','代敬敏','DAI JING MIN ','女','41','一般人员','自费','','副主任号','1','0342','YWQ','1',to_date('2025/01/24 18:23:28','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501256955','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 18:23:29
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6955,'影像科宇文谦','白天','1','100466659','代敬敏','DAI JING MIN ','女','41','一般人员','自费','','副主任号','1','0342','YWQ','1',to_date('2025/01/24 18:23:28','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501256955','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '影像科宇文谦' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),6955,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '影像科宇文谦' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202501256955</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501256955</pinkey><ordertime>2025-01-24 18:23:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 19:38:31
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18632219598</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_内分泌科马伟杰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130626199902010133</patientidcard><patientname>高培淇</patientname><patientsex>男</patientsex><patientbirthday>1999-02-01</patientbirthday><medicalrecord></medicalrecord><contactphone>18632219598</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 19:38:31
记录内容：select * from  pat_master_index where id_no='130626199902010133' and name='高培淇' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1999/2/1 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 19:38:31
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 19:38:31
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7024,'内分泌科马伟杰','上午','6','10600143','高培淇','','男','26','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/01/24 19:38:30','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501257024','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 19:38:31
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7024,'内分泌科马伟杰','上午','6','10600143','高培淇','','男','26','一般人员','自费','','副主任号','1','0315','MAWJ','1',to_date('2025/01/24 19:38:30','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501257024','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科马伟杰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7024,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '内分泌科马伟杰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257024</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501257024</pinkey><ordertime>2025-01-24 19:38:31</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 19:45:59
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18531634616</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_心血管内安立敏普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150425195709136779</patientidcard><patientname>何凤臣</patientname><patientsex>男</patientsex><patientbirthday>1957-09-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18531634616</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-24 19:45:59
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/25','YYYY-MM-DD')
            AND CLINIC_LABEL='心血管内安立敏普' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='150425195709136779' and name='何凤臣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 19:45:59
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 19:50:47
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13639475630</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_骨科刘海峰</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>372424197008197515</patientidcard><patientname>王永青</patientname><patientsex>男</patientsex><patientbirthday>1970-08-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13639475630</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 19:50:47
记录内容：select * from  pat_master_index where id_no='372424197008197515' and name='王永青' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1970/8/19 0:00:0055
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 19:50:47
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 19:50:47
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7030,'骨科刘海峰','上午','3','100466662','王永青','WANG YONG QING ','男','55','一般人员','自费','','副主任号','1','0312','LIUHF','1',to_date('2025/01/24 19:50:46','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501257030','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 19:50:48
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7030,'骨科刘海峰','上午','3','100466662','王永青','WANG YONG QING ','男','55','一般人员','自费','','副主任号','1','0312','LIUHF','1',to_date('2025/01/24 19:50:46','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501257030','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '骨科刘海峰' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7030,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '骨科刘海峰' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257030</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501257030</pinkey><ordertime>2025-01-24 19:50:48</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 19:59:34
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15269985409</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_泌尿外科田惠忠</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230225195909281013</patientidcard><patientname>聂宗举</patientname><patientsex>男</patientsex><patientbirthday>1959-09-28</patientbirthday><medicalrecord></medicalrecord><contactphone>15269985409</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 19:59:34
记录内容：select * from  pat_master_index where id_no='230225195909281013' and name='聂宗举' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1959/9/28 0:00:0066
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 19:59:35
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '泌尿外科田惠忠' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 19:59:35
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7044,'泌尿外科田惠忠','上午','4','10618663','聂宗举','','男','66','一般人员','自费','','CY主任号','1','0311','CYTHZ','1',to_date('2025/01/24 19:59:33','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501257044','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 19:59:35
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7044,'泌尿外科田惠忠','上午','4','10618663','聂宗举','','男','66','一般人员','自费','','CY主任号','1','0311','CYTHZ','1',to_date('2025/01/24 19:59:33','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501257044','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '泌尿外科田惠忠' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7044,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '泌尿外科田惠忠' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257044</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501257044</pinkey><ordertime>2025-01-24 19:59:35</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 19:59:54
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18531634616</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_心血管内安立敏普</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150425195709136779</patientidcard><patientname>何凤臣</patientname><patientsex>男</patientsex><patientbirthday>1957-09-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18531634616</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-24 19:59:54
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/25','YYYY-MM-DD')
            AND CLINIC_LABEL='心血管内安立敏普' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='150425195709136779' and name='何凤臣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 19:59:54
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 20:22:50
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18531634616</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_心血管内科陶林森</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>150425195709136779</patientidcard><patientname>何凤臣</patientname><patientsex>男</patientsex><patientbirthday>1957-09-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18531634616</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-24 20:22:50
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/25','YYYY-MM-DD')
            AND CLINIC_LABEL='心血管内科陶林森' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='150425195709136779' and name='何凤臣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 20:22:50
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 20:38:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15901181606</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_呼吸内科高立静</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>210821195411102421</patientidcard><patientname>纪广丽</patientname><patientsex>女</patientsex><patientbirthday>1954-11-10</patientbirthday><medicalrecord></medicalrecord><contactphone>15901181606</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 20:38:10
记录内容：select * from  pat_master_index where id_no='210821195411102421' and name='纪广丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1954/11/10 0:00:0071
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 20:38:10
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 20:38:10
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7101,'呼吸内科高立静','上午','2','10385242','纪广丽','','女','71','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/24 20:38:08','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501257101','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 20:38:10
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7101,'呼吸内科高立静','上午','2','10385242','纪广丽','','女','71','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/24 20:38:08','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501257101','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '呼吸内科高立静' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7101,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '呼吸内科高立静' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257101</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501257101</pinkey><ordertime>2025-01-24 20:38:10</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 21:28:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15932061211</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_神经内科孔令辉</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130722200407174312</patientidcard><patientname>张俊杰</patientname><patientsex>男</patientsex><patientbirthday>2004-07-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15932061211</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-24 21:28:13
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/25','YYYY-MM-DD')
            AND CLINIC_LABEL='神经内科孔令辉' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='130722200407174312' and name='张俊杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 21:28:13
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 21:30:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15210562593</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_神经内科孔令辉</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132522198106033226</patientidcard><patientname>袁利英</patientname><patientsex>女</patientsex><patientbirthday>1981-06-03</patientbirthday><medicalrecord></medicalrecord><contactphone>15210562593</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 21:30:38
记录内容：select * from  pat_master_index where id_no='132522198106033226' and name='袁利英' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1981/6/3 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 21:30:38
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '神经内科孔令辉' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 21:30:38
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7183,'神经内科孔令辉','上午','2','10300895','袁利英','','女','44','一般人员','自费','','普通号','1','0303','KLH','1',to_date('2025/01/24 21:30:36','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257183','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 21:30:38
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7183,'神经内科孔令辉','上午','2','10300895','袁利英','','女','44','一般人员','自费','','普通号','1','0303','KLH','1',to_date('2025/01/24 21:30:36','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257183','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科孔令辉' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7183,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '神经内科孔令辉' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257183</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501257183</pinkey><ordertime>2025-01-24 21:30:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 21:34:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15932061211</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_神经内科孔令辉</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130722200407174312</patientidcard><patientname>张俊杰</patientname><patientsex>男</patientsex><patientbirthday>2004-07-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15932061211</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-24 21:34:58
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/25','YYYY-MM-DD')
            AND CLINIC_LABEL='神经内科孔令辉' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='130722200407174312' and name='张俊杰' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 21:34:58
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>0</returncode><errormsg>挂号失败！医保卡不允许线上挂号，请新建一张自费就诊卡挂号!</errormsg></returnresult><outputvalues><orderid></orderid><reservefee></reservefee><clinicfee></clinicfee><registrationfee></registrationfee><pinkey></pinkey><ordertime></ordertime><payregfee></payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 22:00:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15103361322</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_下午_神经内科王卫</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082197707160275</patientidcard><patientname>张冲</patientname><patientsex>男</patientsex><patientbirthday>1977-07-16</patientbirthday><medicalrecord></medicalrecord><contactphone>15103361322</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 22:00:15
记录内容：select * from  pat_master_index where id_no='131082197707160275' and name='张冲' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1977/7/16 0:00:0048
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:00:15
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:00:15
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7218,'神经内科王卫','下午','1','100160146','张冲','ZHANG CHONG ','男','48','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/01/24 22:00:13','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501277218','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 22:00:15
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7218,'神经内科王卫','下午','1','100160146','张冲','ZHANG CHONG ','男','48','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/01/24 22:00:13','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501277218','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/27', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '神经内科王卫' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7218,'14:00-14:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '神经内科王卫' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202501277218</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501277218</pinkey><ordertime>2025-01-24 22:00:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 22:26:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15133421233</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/1 0:00:00_白天_妇科韩卫灵副主任</scheduleid><parttimeid>10:30-11:00</parttimeid><certtypeno>1</certtypeno><patientidcard>220421198205064122</patientidcard><patientname>赫晓丽</patientname><patientsex>女</patientsex><patientbirthday>1982-05-06</patientbirthday><medicalrecord></medicalrecord><contactphone>15133421233</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 22:26:56
记录内容：select * from  pat_master_index where id_no='220421198205064122' and name='赫晓丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/5/6 0:00:0043
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:26:56
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/01','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:26:56
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/01','YYYY/MM/DD'),7243,'妇科韩卫灵副主任','白天','1','10534579','赫晓丽','','女','43','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2025/01/24 22:26:54','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502017243','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 22:26:56
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/02/01','YYYY/MM/DD'),7243,'妇科韩卫灵副主任','白天','1','10534579','赫晓丽','','女','43','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2025/01/24 22:26:54','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202502017243','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/02/01', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '妇科韩卫灵副主任' AND TIME_DESC = '白天' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/02/01','YYYY/MM/DD'),7243,'10:30-11:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/01','yyyy/mm/dd')
                    and clinic_label = '妇科韩卫灵副主任' and visit_time_desc = '白天'）</errormsg></returnresult><outputvalues><orderid>202502017243</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202502017243</pinkey><ordertime>2025-01-24 22:26:56</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 22:29:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15133421233</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_眼科普通号</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220421198205064122</patientidcard><patientname>赫晓丽</patientname><patientsex>女</patientsex><patientbirthday>1982-05-06</patientbirthday><medicalrecord></medicalrecord><contactphone>15133421233</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 22:29:57
记录内容：select * from  pat_master_index where id_no='220421198205064122' and name='赫晓丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1982/5/6 0:00:0043
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:29:57
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '眼科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:29:57
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7246,'眼科普通号','上午','1','10534579','赫晓丽','','女','43','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/24 22:29:56','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257246','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 22:29:58
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7246,'眼科普通号','上午','1','10534579','赫晓丽','','女','43','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/24 22:29:56','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257246','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7246,'11:00-11:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '眼科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257246</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501257246</pinkey><ordertime>2025-01-24 22:29:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 22:59:34
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18801449257</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_儿科陈云平</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082202107182511</patientidcard><patientname>李祐霖</patientname><patientsex>男</patientsex><patientbirthday>2021-07-18</patientbirthday><medicalrecord></medicalrecord><contactphone>18801449257</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 22:59:34
记录内容：select * from  pat_master_index where id_no='131082202107182511' and name='李祐霖' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2021/7/18 0:00:004
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:59:34
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 22:59:34
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7272,'儿科陈云平','上午','2','100198958','李祐霖','LI DAI LIN','男','4','一般人员','自费','','知名专家','1','0304','CYP11','1',to_date('2025/01/24 22:59:32','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501257272','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 22:59:34
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7272,'儿科陈云平','上午','2','100198958','李祐霖','LI DAI LIN','男','4','一般人员','自费','','知名专家','1','0304','CYP11','1',to_date('2025/01/24 22:59:32','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501257272','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '儿科陈云平' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7272,'8:30-9:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '儿科陈云平' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257272</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501257272</pinkey><ordertime>2025-01-24 22:59:34</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 23:04:02
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18032437602</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_皮肤科普通号</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200503190522</patientidcard><patientname>刘江慧</patientname><patientsex>女</patientsex><patientbirthday>2005-03-19</patientbirthday><medicalrecord></medicalrecord><contactphone>18032437602</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 23:04:02
记录内容：select * from  pat_master_index where id_no='131082200503190522' and name='刘江慧' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/3/19 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:04:02
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '皮肤科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:04:02
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),7282,'皮肤科普通号','上午','44','100355220','刘江慧','LIU JIANG HUI ','女','20','一般人员','自费','','普通号','1','0318','','1',to_date('2025/01/24 23:04:00','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501267282','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 23:04:03
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/26','YYYY/MM/DD'),7282,'皮肤科普通号','上午','44','100355220','刘江慧','LIU JIANG HUI ','女','20','一般人员','自费','','普通号','1','0318','','1',to_date('2025/01/24 23:04:00','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501267282','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/26', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '皮肤科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/26','YYYY/MM/DD'),7282,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/26','yyyy/mm/dd')
                    and clinic_label = '皮肤科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501267282</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501267282</pinkey><ordertime>2025-01-24 23:04:03</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 23:32:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15233695321</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_眼科普通号</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130828198702175725</patientidcard><patientname>辛秀娟</patientname><patientsex>女</patientsex><patientbirthday>1987-02-17</patientbirthday><medicalrecord></medicalrecord><contactphone>15233695321</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 23:32:05
记录内容：select * from  pat_master_index where id_no='130828198702175725' and name='辛秀娟' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1987/2/17 0:00:0038
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:32:05
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '眼科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:32:05
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7313,'眼科普通号','上午','2','10059883','辛秀娟','','女','38','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/24 23:32:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257313','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 23:32:05
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7313,'眼科普通号','上午','2','10059883','辛秀娟','','女','38','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/24 23:32:03','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257313','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7313,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '眼科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257313</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501257313</pinkey><ordertime>2025-01-24 23:32:05</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 23:40:25
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18324691985</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_下午_眼科普通号</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082199806281020</patientidcard><patientname>柳娜</patientname><patientsex>女</patientsex><patientbirthday>1998-06-28</patientbirthday><medicalrecord></medicalrecord><contactphone>18324691985</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 23:40:26
记录内容：select * from  pat_master_index where id_no='131082199806281020' and name='柳娜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1998/6/28 0:00:0027
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:40:26
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '眼科普通号' and visit_time_desc = '下午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:40:26
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7317,'眼科普通号','下午','1','100466677','柳娜','LIU NA ','女','27','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/24 23:40:23','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501277317','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 23:40:26
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7317,'眼科普通号','下午','1','100466677','柳娜','LIU NA ','女','27','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/24 23:40:23','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501277317','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/27', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '眼科普通号' AND TIME_DESC = '下午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/27','YYYY/MM/DD'),7317,'14:30-15:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/27','yyyy/mm/dd')
                    and clinic_label = '眼科普通号' and visit_time_desc = '下午'）</errormsg></returnresult><outputvalues><orderid>202501277317</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501277317</pinkey><ordertime>2025-01-24 23:40:26</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-24 23:52:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13288883131</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/25 0:00:00_上午_耳鼻喉科普通号</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130929199510195111</patientidcard><patientname>邵志</patientname><patientsex>男</patientsex><patientbirthday>1995-10-19</patientbirthday><medicalrecord></medicalrecord><contactphone>13288883131</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-24 23:52:33
记录内容：select * from  pat_master_index where id_no='130929199510195111' and name='邵志' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/10/19 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:52:33
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科普通号' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-24 23:52:33
记录内容： INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7321,'耳鼻喉科普通号','上午','12','Z00411745','邵志','','男','30','一般人员','自费','','普通号','1','0306','','1',to_date('2025/01/24 23:52:31','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257321','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-24 23:52:33
记录内容：<?xml version="1.0" encoding="utf-8"?><response><returnresult><returncode>1</returncode><errormsg>成功（影响条数2 INSERT INTO clinic_master (visit_date,visit_no,clinic_label,visit_time_desc,serial_no,patient_id,name,name_phonetic,sex,age,identity,charge_type,insurance_no,clinic_type,first_visit_indicator,visit_dept,doctor,registration_status,registering_date,regist_fee,clinic_fee,other_fee,clinic_charge,CLINIC_NO,operator,mode_code,card_name,mr_provided_indicator,patient_source,media_source,clinic_self,PAY_WAY,trade_no,fund_fee,cash_fee,self_fee,insur_flag,serial_no_actual) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7321,'耳鼻喉科普通号','上午','12','Z00411745','邵志','','男','30','一般人员','自费','','普通号','1','0306','','1',to_date('2025/01/24 23:52:31','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501257321','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') update clinic_for_regist set current_no=current_no+1,registration_num=registration_num+1
                    where  clinic_date = to_date('2025/01/25', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '耳鼻喉科普通号' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/25','YYYY/MM/DD'),7321,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/25','yyyy/mm/dd')
                    and clinic_label = '耳鼻喉科普通号' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501257321</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501257321</pinkey><ordertime>2025-01-24 23:52:33</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆