◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 00:37:05
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18502937626</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/1 0:00:00_上午_泌尿外科田惠忠</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230102195002171019</patientidcard><patientname>胡宝林</patientname><patientsex>男</patientsex><patientbirthday>1950-02-17</patientbirthday><medicalrecord></medicalrecord><contactphone>18502937626</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 00:37:06
记录内容：select * from  pat_master_index where id_no='230102195002171019' and name='胡宝林' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1950/2/17 0:00:0075
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 00:37:06
记录内容：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-25 00:37:06
记录内容： 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'),7355,'泌尿外科田惠忠','上午','1','100466680','胡宝林','HU BAO LIN ','男','75','一般人员','自费','','CY主任号','1','0311','CYTHZ','1',to_date('2025/01/25 00:37:03','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202502017355','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 00:37:06
记录内容：<?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'),7355,'泌尿外科田惠忠','上午','1','100466680','胡宝林','HU BAO LIN ','男','75','一般人员','自费','','CY主任号','1','0311','CYTHZ','1',to_date('2025/01/25 00:37:03','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202502017355','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'),7355,'9:00-9:30') 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>202502017355</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202502017355</pinkey><ordertime>2025-01-25 00:37:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 01:58:44
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18033653531</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_下午_心理咨询失眠李文</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082201112090529</patientidcard><patientname>王轶煊</patientname><patientsex>女</patientsex><patientbirthday>2011-12-09</patientbirthday><medicalrecord></medicalrecord><contactphone>18033653531</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 01:58:45
记录内容：select * from  pat_master_index where id_no='131082201112090529' and name='王轶煊' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2011/12/9 0:00:0014
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 01:58:45
记录内容：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-25 01:58: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/26','YYYY/MM/DD'),7401,'心理咨询失眠李文','下午','1','100466682','王轶煊','WANG   ','女','14','一般人员','自费','','CY副主任','1','0360','CYLW','1',to_date('2025/01/25 01:58:42','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501267401','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 01:58: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/26','YYYY/MM/DD'),7401,'心理咨询失眠李文','下午','1','100466682','王轶煊','WANG   ','女','14','一般人员','自费','','CY副主任','1','0360','CYLW','1',to_date('2025/01/25 01:58:42','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501267401','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'),7401,'14:00-14: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>202501267401</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501267401</pinkey><ordertime>2025-01-25 01:58:45</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 07:37:06
记录内容：<?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/27 0:00:00_上午_脊柱微创刘兴超</scheduleid><parttimeid>9:00-9:30</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-25 07:37:06
记录内容：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-25 07:37:06
记录内容：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-25 07:37:06
记录内容： 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'),7574,'脊柱微创刘兴超','上午','1','100352826','邵云','SHAO YUN','女','69','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/01/25 07:37:09','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501277574','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 07:37:06
记录内容：<?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'),7574,'脊柱微创刘兴超','上午','1','100352826','邵云','SHAO YUN','女','69','一般人员','自费','','副主任号','1','0312','LIUXC','1',to_date('2025/01/25 07:37:09','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501277574','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'),7574,'9:00-9: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>202501277574</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501277574</pinkey><ordertime>2025-01-25 07:37:06</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 08:04:50
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18404804333</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_下午_医疗美容科普通号</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230230198905281168</patientidcard><patientname>赵丽丽</patientname><patientsex>女</patientsex><patientbirthday>1989-05-28</patientbirthday><medicalrecord></medicalrecord><contactphone>18404804333</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 08:04:50
记录内容：select * from  pat_master_index where id_no='230230198905281168' and name='赵丽丽' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/5/28 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 08:04:50
记录内容：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-25 08:04: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/26','YYYY/MM/DD'),7758,'医疗美容科普通号','下午','1','10621565','赵丽丽','','女','36','一般人员','自费','','普通号','1','03109','','1',to_date('2025/01/25 08:04:53','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501267758','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 08:04:51
记录内容：<?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'),7758,'医疗美容科普通号','下午','1','10621565','赵丽丽','','女','36','一般人员','自费','','普通号','1','03109','','1',to_date('2025/01/25 08:04:53','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501267758','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'),7758,'14:00-14: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>202501267758</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501267758</pinkey><ordertime>2025-01-25 08:04:51</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 08:11:40
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15383866203</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_神经内科王卫</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>232724200505220026</patientidcard><patientname>石沐佳</patientname><patientsex>女</patientsex><patientbirthday>2005-05-22</patientbirthday><medicalrecord></medicalrecord><contactphone>15383866203</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 08:11:40
记录内容：select * from  pat_master_index where id_no='232724200505220026' and name='石沐佳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2005/5/22 0:00:0020
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 08:11:40
记录内容：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-25 08:11:40
记录内容： 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'),7884,'神经内科王卫','上午','7','Z00278332','石沐佳','','女','20','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/01/25 08:11:43','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501277884','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 08:11:40
记录内容：<?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'),7884,'神经内科王卫','上午','7','Z00278332','石沐佳','','女','20','一般人员','自费','','知名专家','1','0303','WANGWEI1','1',to_date('2025/01/25 08:11:43','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501277884','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'),7884,'10:00-10: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>202501277884</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501277884</pinkey><ordertime>2025-01-25 08:11:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 08:17:26
记录内容：<?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/26 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-25 08:17:26
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/26','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-25 08:17:26
记录内容：<?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-25 08:19:50
记录内容：<?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/26 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-25 08:19:50
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/26','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-25 08:19: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-25 08:38:02
记录内容：<?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/26 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-25 08:38:02
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/26','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-25 08:38:02
记录内容：<?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-25 08:41:28
记录内容：<?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/26 0:00:00_上午_神经内科卢向丽</scheduleid><parttimeid>9:30-10:00</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-25 08:41:29
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/26','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-25 08:41:29
记录内容：<?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-25 08:44:31
记录内容：<?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/26 0:00:00_上午_神经内科卢向丽</scheduleid><parttimeid>9:30-10:00</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-25 08:44:31
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/26','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-25 08:44:31
记录内容：<?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-25 08:54:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18600741267</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_产科辛俊英</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23052319900222002X</patientidcard><patientname>王婷婷</patientname><patientsex>女</patientsex><patientbirthday>1990-02-22</patientbirthday><medicalrecord></medicalrecord><contactphone>18600741267</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 08:54:14
记录内容：select * from  pat_master_index where id_no='23052319900222002X' and name='王婷婷' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/2/22 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 08:54: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-25 08:54: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'),8948,'产科辛俊英','上午','11','00387981','王婷婷','WANG TING TING','女','35','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/25 08:54:17','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501268948','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','9') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 08:54: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'),8948,'产科辛俊英','上午','11','00387981','王婷婷','WANG TING TING','女','35','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/25 08:54:17','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501268948','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/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'),8948,'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>202501268948</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501268948</pinkey><ordertime>2025-01-25 08:54:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 09:33:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15576459115</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/29 0:00:00_上午_产科王振燕</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>430523200001098221</patientidcard><patientname>杨澜</patientname><patientsex>女</patientsex><patientbirthday>2000-01-09</patientbirthday><medicalrecord></medicalrecord><contactphone>15576459115</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 09:33:22
记录内容：select * from  pat_master_index where id_no='430523200001098221' and name='杨澜' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/1/9 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 09:33:22
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/29','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 09:33:22
记录内容： 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/29','YYYY/MM/DD'),76,'产科王振燕','上午','4','100465429','杨澜','YANG LAN ','女','25','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/25 09:33:25','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501290076','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','4') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 09:33:22
记录内容：<?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/29','YYYY/MM/DD'),76,'产科王振燕','上午','4','100465429','杨澜','YANG LAN ','女','25','一般人员','自费','','主任号','1','0330','WZY','1',to_date('2025/01/25 09:33:25','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501290076','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/29', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '产科王振燕' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/29','YYYY/MM/DD'),76,'9:30-10:00') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/29','yyyy/mm/dd')
                    and clinic_label = '产科王振燕' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>2025012976</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>2025012976</pinkey><ordertime>2025-01-25 09:33:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 10:10:03
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18330615889</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_全科医学科普通号</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082199501234522</patientidcard><patientname>许欣</patientname><patientsex>女</patientsex><patientbirthday>1995-01-23</patientbirthday><medicalrecord></medicalrecord><contactphone>18330615889</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 10:10:04
记录内容：select * from  pat_master_index where id_no='131082199501234522' and name='许欣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1995/1/23 0:00:0030
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 10:10:04
记录内容：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-25 10:10:04
记录内容： 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'),1116,'全科医学科普通号','上午','2','Z00345588','许欣','','女','30','一般人员','自费','','普通号','1','0396','','1',to_date('2025/01/25 10:10:06','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501261116','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 10:10:04
记录内容：<?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'),1116,'全科医学科普通号','上午','2','Z00345588','许欣','','女','30','一般人员','自费','','普通号','1','0396','','1',to_date('2025/01/25 10:10:06','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501261116','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'),1116,'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>202501261116</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501261116</pinkey><ordertime>2025-01-25 10:10:04</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 10:33:15
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13945148275</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_泌尿外科普通号</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230102196303091367</patientidcard><patientname>陈英环</patientname><patientsex>女</patientsex><patientbirthday>1963-03-09</patientbirthday><medicalrecord></medicalrecord><contactphone>13945148275</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 10:33:15
记录内容：select * from  pat_master_index where id_no='230102196303091367' and name='陈英环' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1963/3/9 0:00:0062
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 10:33:15
记录内容：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-25 10:33: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/26','YYYY/MM/DD'),1716,'泌尿外科普通号','上午','5','100331752','陈英环','CHEN YING HUAN ','女','62','一般人员','自费','','普通号','1','0311','','1',to_date('2025/01/25 10:33:17','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501261716','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 10:33: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/26','YYYY/MM/DD'),1716,'泌尿外科普通号','上午','5','100331752','陈英环','CHEN YING HUAN ','女','62','一般人员','自费','','普通号','1','0311','','1',to_date('2025/01/25 10:33:17','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501261716','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'),1716,'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>202501261716</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501261716</pinkey><ordertime>2025-01-25 10:33:15</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 10:49:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18074184429</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_老年病科王诗男</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230182197805064429</patientidcard><patientname>侣玉梅</patientname><patientsex>女</patientsex><patientbirthday>1978-05-06</patientbirthday><medicalrecord></medicalrecord><contactphone>18074184429</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 10:49:52
记录内容：select * from  pat_master_index where id_no='230182197805064429' and name='侣玉梅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1978/5/6 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 10:49:52
记录内容：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-25 10:49: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/27','YYYY/MM/DD'),2147,'老年病科王诗男','上午','4','100343943','侣玉梅','LV YU MEI ','女','47','一般人员','自费','','副主任号','1','0354','WSN','1',to_date('2025/01/25 10:49:54','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501272147','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 10:49: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/27','YYYY/MM/DD'),2147,'老年病科王诗男','上午','4','100343943','侣玉梅','LV YU MEI ','女','47','一般人员','自费','','副主任号','1','0354','WSN','1',to_date('2025/01/25 10:49:54','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501272147','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'),2147,'10:00-10: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>202501272147</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501272147</pinkey><ordertime>2025-01-25 10:49:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 10:50:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18632684900</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/2/4 0:00:00_上午_内分泌科姚合斌</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199311181222</patientidcard><patientname>李玉博</patientname><patientsex>女</patientsex><patientbirthday>1993-11-18</patientbirthday><medicalrecord></medicalrecord><contactphone>18632684900</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 10:50:46
记录内容：select * from  pat_master_index where id_no='131028199311181222' and name='李玉博' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1993/11/18 0:00:0032
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 10:50:46
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/04','yyyy/mm/dd')
                    and clinic_label = '内分泌科姚合斌' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 10:50:46
记录内容： 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/04','YYYY/MM/DD'),2175,'内分泌科姚合斌','上午','1','Z00074475','李玉博','','女','32','一般人员','自费','','知名专家','1','0315','YHB','1',to_date('2025/01/25 10:50:48','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202502042175','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 10:50:46
记录内容：<?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/04','YYYY/MM/DD'),2175,'内分泌科姚合斌','上午','1','Z00074475','李玉博','','女','32','一般人员','自费','','知名专家','1','0315','YHB','1',to_date('2025/01/25 10:50:48','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202502042175','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/04', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '内分泌科姚合斌' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/02/04','YYYY/MM/DD'),2175,'10:00-10:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/02/04','yyyy/mm/dd')
                    and clinic_label = '内分泌科姚合斌' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202502042175</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202502042175</pinkey><ordertime>2025-01-25 10:50:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 11:02:49
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18074184429</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_心血管内郭晓光普</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230182197805064429</patientidcard><patientname>侣玉梅</patientname><patientsex>女</patientsex><patientbirthday>1978-05-06</patientbirthday><medicalrecord></medicalrecord><contactphone>18074184429</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 11:02:49
记录内容：select * from  pat_master_index where id_no='230182197805064429' and name='侣玉梅' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1978/5/6 0:00:0047
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 11:02: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-25 11:02: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'),2409,'心血管内郭晓光普','上午','1','100343943','侣玉梅','LV YU MEI ','女','47','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/01/25 11:02:51','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501262409','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 11:02: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'),2409,'心血管内郭晓光普','上午','1','100343943','侣玉梅','LV YU MEI ','女','47','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/01/25 11:02:51','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501262409','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'),2409,'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>202501262409</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501262409</pinkey><ordertime>2025-01-25 11:02:49</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 12:14:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>19333168789</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_下午_产科辛俊英</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>152627198005183744</patientidcard><patientname>朱燕芳</patientname><patientsex>女</patientsex><patientbirthday>1980-05-18</patientbirthday><medicalrecord></medicalrecord><contactphone>19333168789</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 12:14:56
记录内容：select * from  pat_master_index where id_no='152627198005183744' and name='朱燕芳' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1980/5/18 0:00:0045
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 12:14:56
记录内容：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-25 12:14: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/01/26','YYYY/MM/DD'),3255,'产科辛俊英','下午','2','Z00421343','朱燕芳','ZHU YAN FANG','女','45','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/25 12:14:58','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501263255','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 12:14: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/01/26','YYYY/MM/DD'),3255,'产科辛俊英','下午','2','Z00421343','朱燕芳','ZHU YAN FANG','女','45','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/25 12:14:58','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501263255','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'),3255,'14:30-15: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>202501263255</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501263255</pinkey><ordertime>2025-01-25 12:14:56</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 12:28:01
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15732639910</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_消化内科刘正新</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028200012070018</patientidcard><patientname>田永澍</patientname><patientsex>男</patientsex><patientbirthday>2000-12-07</patientbirthday><medicalrecord></medicalrecord><contactphone>15732639910</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 12:28:01
记录内容：select * from  pat_master_index where id_no='131028200012070018' and name='田永澍' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2000/12/7 0:00:0025
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 12:28:01
记录内容：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-25 12:28:01
记录内容： 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'),3283,'消化内科刘正新','上午','3','10569754','田永澍','','男','25','一般人员','自费','','CY知名专','1','0302','CYLZX','1',to_date('2025/01/25 12:28:02','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501273283','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 12:28:01
记录内容：<?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'),3283,'消化内科刘正新','上午','3','10569754','田永澍','','男','25','一般人员','自费','','CY知名专','1','0302','CYLZX','1',to_date('2025/01/25 12:28:02','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501273283','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'),3283,'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>202501273283</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501273283</pinkey><ordertime>2025-01-25 12:28:01</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 12:48:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18518959116</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_皮肤科杨维玲</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131082200706180818</patientidcard><patientname>田道藩</patientname><patientsex>男</patientsex><patientbirthday>2007-06-18</patientbirthday><medicalrecord></medicalrecord><contactphone>18518959116</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 12:48:39
记录内容：select * from  pat_master_index where id_no='131082200706180818' and name='田道藩' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2007/6/18 0:00:0018
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 12:48:39
记录内容：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-25 12:48:39
记录内容： 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'),3299,'皮肤科杨维玲','上午','11','100269607','田道藩','TIAN DAO FAN ','男','18','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/01/25 12:48:40','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501263299','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 12:48: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'),3299,'皮肤科杨维玲','上午','11','100269607','田道藩','TIAN DAO FAN ','男','18','一般人员','自费','','知名专家','1','0318','YWL','1',to_date('2025/01/25 12:48:40','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501263299','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/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'),3299,'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>202501263299</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501263299</pinkey><ordertime>2025-01-25 12:48:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 12:48:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18246979645</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_白天_妇科韩卫灵副主任</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230125197105143129</patientidcard><patientname>韩晓婷</patientname><patientsex>女</patientsex><patientbirthday>1971-05-14</patientbirthday><medicalrecord></medicalrecord><contactphone>18246979645</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 12:48:39
记录内容：select * from  pat_master_index where id_no='230125197105143129' and name='韩晓婷' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/5/14 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 12:48:39
记录内容：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-25 12:48:39
记录内容： 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'),3300,'妇科韩卫灵副主任','白天','5','100464889','韩晓婷','HAN XIAO  ','女','54','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2025/01/25 12:48:41','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501273300','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','5') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 12:48: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/27','YYYY/MM/DD'),3300,'妇科韩卫灵副主任','白天','5','100464889','韩晓婷','HAN XIAO  ','女','54','一般人员','自费','','副主任号','1','0316','HANWL','1',to_date('2025/01/25 12:48:41','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501273300','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/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'),3300,'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>202501273300</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501273300</pinkey><ordertime>2025-01-25 12:48:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 12:52:14
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13691045257</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/28 0:00:00_上午_心慌门诊谭琛</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>23030319650801432x</patientidcard><patientname>魏雅荣</patientname><patientsex>女</patientsex><patientbirthday>1965-08-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13691045257</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 12:52:14
记录内容：select * from  pat_master_index where id_no='23030319650801432x' and name='魏雅荣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1965/8/1 0:00:0060
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 12:52:14
记录内容：select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/28','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 12:52: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/28','YYYY/MM/DD'),3309,'心慌门诊谭琛','上午','1','100466720','魏雅荣','WEI YA RONG ','女','60','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/01/25 12:52:15','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501283309','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 12:52: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/28','YYYY/MM/DD'),3309,'心慌门诊谭琛','上午','1','100466720','魏雅荣','WEI YA RONG ','女','60','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/01/25 12:52:15','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501283309','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/28', 'YYYY-MM-DD')
                    AND CLINIC_LABEL = '心慌门诊谭琛' AND TIME_DESC = '上午' INSERT INTO TB_RegistrationResolve (VISIT_DATE,VISIT_NO,VISIT_TEXT) VALUES (to_date('2025/01/28','YYYY/MM/DD'),3309,'9:00-9:30') select max(serial_no_actual)+1 aa from clinic_master  where visit_date=to_date('2025/01/28','yyyy/mm/dd')
                    and clinic_label = '心慌门诊谭琛' and visit_time_desc = '上午'）</errormsg></returnresult><outputvalues><orderid>202501283309</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501283309</pinkey><ordertime>2025-01-25 12:52:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 13:26:06
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18051560010</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_医疗美容科普通号</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>412728198908205284</patientidcard><patientname>孙慧敏</patientname><patientsex>女</patientsex><patientbirthday>1989-08-20</patientbirthday><medicalrecord></medicalrecord><contactphone>18051560010</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 13:26:06
记录内容：select * from  pat_master_index where id_no='412728198908205284' and name='孙慧敏' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1989/8/20 0:00:0036
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 13:26:06
记录内容：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-25 13:26:06
记录内容： 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'),3637,'医疗美容科普通号','上午','1','Z00433539','孙慧敏','','女','36','一般人员','自费','','普通号','1','03109','','1',to_date('2025/01/25 13:26:08','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501273637','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 13:26:07
记录内容：<?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'),3637,'医疗美容科普通号','上午','1','Z00433539','孙慧敏','','女','36','一般人员','自费','','普通号','1','03109','','1',to_date('2025/01/25 13:26:08','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501273637','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'),3637,'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>202501273637</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501273637</pinkey><ordertime>2025-01-25 13:26:07</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 15:33:29
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15101833316</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_消化内科普通号</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>622429195906180023</patientidcard><patientname>权月琴</patientname><patientsex>女</patientsex><patientbirthday>1959-06-18</patientbirthday><medicalrecord></medicalrecord><contactphone>15101833316</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 15:33:29
记录内容：select * from  pat_master_index where id_no='622429195906180023' and name='权月琴' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1959/6/18 0:00:0066
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 15:33:29
记录内容：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-25 15:33: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/26','YYYY/MM/DD'),5300,'消化内科普通号','上午','3','100172322','权月琴','QUAN YUE QIN','女','66','一般人员','自费','','普通号','1','0302','','1',to_date('2025/01/25 15:33:30','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501265300','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 15:33: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/26','YYYY/MM/DD'),5300,'消化内科普通号','上午','3','100172322','权月琴','QUAN YUE QIN','女','66','一般人员','自费','','普通号','1','0302','','1',to_date('2025/01/25 15:33:30','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501265300','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'),5300,'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>202501265300</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501265300</pinkey><ordertime>2025-01-25 15:33:29</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 15:57:22
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17717143388</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_中医骨伤李国强</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>342821194808181822</patientidcard><patientname>王结花</patientname><patientsex>女</patientsex><patientbirthday>1948-08-18</patientbirthday><medicalrecord></medicalrecord><contactphone>17717143388</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 15:57:22
记录内容：select * from  pat_master_index where id_no='342821194808181822' and name='王结花' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1948/8/18 0:00:0077
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 15:57:22
记录内容：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-25 15:57:22
记录内容： 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'),5528,'中医骨伤李国强','上午','1','100466730','王结花','WANG JIE HUA ','女','77','一般人员','自费','','主任号','1','0301','LIGQ','1',to_date('2025/01/25 15:57:22','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501265528','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 15:57:22
记录内容：<?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'),5528,'中医骨伤李国强','上午','1','100466730','王结花','WANG JIE HUA ','女','77','一般人员','自费','','主任号','1','0301','LIGQ','1',to_date('2025/01/25 15:57:22','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501265528','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'),5528,'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>202501265528</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501265528</pinkey><ordertime>2025-01-25 15:57:22</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 15:59:58
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13426278667</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_中医针灸马艾菲</scheduleid><parttimeid>11:00-11:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230702198104250945</patientidcard><patientname>梁丽颖</patientname><patientsex>女</patientsex><patientbirthday>1981-04-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13426278667</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 15:59:58
记录内容：select * from  pat_master_index where id_no='230702198104250945' and name='梁丽颖' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1981/4/25 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 15:59:58
记录内容：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-25 15:59:58
记录内容： 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'),5552,'中医针灸马艾菲','上午','1','100466580','梁丽颖','LIANG LI YING ','女','44','一般人员','自费','','副主任号','1','0301','MAAF','1',to_date('2025/01/25 15:59:59','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265552','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 15:59: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/26','YYYY/MM/DD'),5552,'中医针灸马艾菲','上午','1','100466580','梁丽颖','LIANG LI YING ','女','44','一般人员','自费','','副主任号','1','0301','MAAF','1',to_date('2025/01/25 15:59:59','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265552','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'),5552,'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>202501265552</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501265552</pinkey><ordertime>2025-01-25 15:59:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 16:00:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18833659933</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_中医科陈光献</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131028200209030028</patientidcard><patientname>黄頔</patientname><patientsex>女</patientsex><patientbirthday>2002-09-03</patientbirthday><medicalrecord></medicalrecord><contactphone>18833659933</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 16:00:57
记录内容：select * from  pat_master_index where id_no='131028200209030028' and name='黄頔' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日2002/9/3 0:00:0023
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 16:00:57
记录内容：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-25 16:00: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/26','YYYY/MM/DD'),5561,'中医科陈光献','上午','4','10382247','黄頔','HUANG SUI','女','23','一般人员','自费','','副主任号','1','0301','CGXIAN','1',to_date('2025/01/25 16:00:58','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265561','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 16:00:57
记录内容：<?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'),5561,'中医科陈光献','上午','4','10382247','黄頔','HUANG SUI','女','23','一般人员','自费','','副主任号','1','0301','CGXIAN','1',to_date('2025/01/25 16:00:58','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265561','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'),5561,'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>202501265561</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501265561</pinkey><ordertime>2025-01-25 16:00:57</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 16:10:28
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13426278667</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_中医针灸马艾菲</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230702198104250945</patientidcard><patientname>梁丽颖</patientname><patientsex>女</patientsex><patientbirthday>1981-04-25</patientbirthday><medicalrecord></medicalrecord><contactphone>13426278667</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 16:10:28
记录内容：select * from  pat_master_index where id_no='230702198104250945' and name='梁丽颖' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1981/4/25 0:00:0044
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 16:10:28
记录内容：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-25 16:10: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/26','YYYY/MM/DD'),5627,'中医针灸马艾菲','上午','2','100466580','梁丽颖','LIANG LI YING ','女','44','一般人员','自费','','副主任号','1','0301','MAAF','1',to_date('2025/01/25 16:10:29','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265627','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 16:10: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/26','YYYY/MM/DD'),5627,'中医针灸马艾菲','上午','2','100466580','梁丽颖','LIANG LI YING ','女','44','一般人员','自费','','副主任号','1','0301','MAAF','1',to_date('2025/01/25 16:10:29','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265627','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'),5627,'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>202501265627</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501265627</pinkey><ordertime>2025-01-25 16:10:28</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 16:18:56
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18824248448</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_呼吸内科高立静</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>220104198603131842</patientidcard><patientname>胡文超</patientname><patientsex>女</patientsex><patientbirthday>1986-03-13</patientbirthday><medicalrecord></medicalrecord><contactphone>18824248448</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 16:18:56
记录内容：select * from  pat_master_index where id_no='220104198603131842' and name='胡文超' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1986/3/13 0:00:0039
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 16:18:56
记录内容：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-25 16:18: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/01/26','YYYY/MM/DD'),5674,'呼吸内科高立静','上午','3','100466733','胡文超','HU WEN CHAO ','女','39','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/25 16:18:57','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265674','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 16:18: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/01/26','YYYY/MM/DD'),5674,'呼吸内科高立静','上午','3','100466733','胡文超','HU WEN CHAO ','女','39','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/25 16:18:57','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501265674','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'),5674,'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>202501265674</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501265674</pinkey><ordertime>2025-01-25 16:18:56</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 16:26:57
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13520919151</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_泌尿外科杨云波</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>410923199010011039</patientidcard><patientname>王增垒</patientname><patientsex>男</patientsex><patientbirthday>1990-10-01</patientbirthday><medicalrecord></medicalrecord><contactphone>13520919151</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 16:26:58
记录内容：select * from  pat_master_index where id_no='410923199010011039' and name='王增垒' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1990/10/1 0:00:0035
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 16:26:58
记录内容：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-25 16:26:58
记录内容： 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'),5728,'泌尿外科杨云波','上午','1','100421038','王增垒','WANG ZENG LEI ','男','35','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2025/01/25 16:26:58','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501265728','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 16:26: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/26','YYYY/MM/DD'),5728,'泌尿外科杨云波','上午','1','100421038','王增垒','WANG ZENG LEI ','男','35','一般人员','自费','','主任号','1','0311','YYB','1',to_date('2025/01/25 16:26:58','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501265728','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'),5728,'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>202501265728</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501265728</pinkey><ordertime>2025-01-25 16:26:58</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 16:40:46
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13701249738</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_心血管内郭晓光普</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132337197107231645</patientidcard><patientname>郭云霞</patientname><patientsex>女</patientsex><patientbirthday>1971-07-23</patientbirthday><medicalrecord></medicalrecord><contactphone>13701249738</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 16:40:46
记录内容：select * from  pat_master_index where id_no='132337197107231645' and name='郭云霞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1971/7/23 0:00:0054
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 16:40:46
记录内容：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-25 16:40:46
记录内容： 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'),5857,'心血管内郭晓光普','上午','3','100466734','郭云霞','GUO YUN XIA ','女','54','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/01/25 16:40:47','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501265857','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 16:40:46
记录内容：<?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'),5857,'心血管内郭晓光普','上午','3','100466734','郭云霞','GUO YUN XIA ','女','54','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/01/25 16:40:47','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501265857','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'),5857,'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>202501265857</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501265857</pinkey><ordertime>2025-01-25 16:40:46</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 18:10:26
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15201557916</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_肛肠门诊赵磊</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>320321197406050476</patientidcard><patientname>王海举</patientname><patientsex>男</patientsex><patientbirthday>1974-06-05</patientbirthday><medicalrecord></medicalrecord><contactphone>15201557916</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 18:10:26
记录内容：select * from  pat_master_index where id_no='320321197406050476' and name='王海举' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1974/6/5 0:00:0051
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 18:10: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-25 18:10: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'),6063,'肛肠门诊赵磊','上午','3','100466739','王海举','WANG HAI JU ','男','51','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2025/01/25 18:10:26','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501276063','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 18:10: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'),6063,'肛肠门诊赵磊','上午','3','100466739','王海举','WANG HAI JU ','男','51','一般人员','自费','','副主任号','1','0335','ZHAOL','1',to_date('2025/01/25 18:10:26','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501276063','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'),6063,'10:00-10: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>202501276063</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501276063</pinkey><ordertime>2025-01-25 18:10:26</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 18:48:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18310923800</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_眼科普通号</scheduleid><parttimeid>9:00-9:30</parttimeid><certtypeno>1</certtypeno><patientidcard>130635199111270031</patientidcard><patientname>王玮</patientname><patientsex>男</patientsex><patientbirthday>1991-11-27</patientbirthday><medicalrecord></medicalrecord><contactphone>18310923800</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 18:48:39
记录内容：select * from  pat_master_index where id_no='130635199111270031' and name='王玮' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1991/11/27 0:00:0034
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 18:48:39
记录内容：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-25 18:48:39
记录内容： 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'),6103,'眼科普通号','上午','1','100444828','王玮','WANG  ','男','34','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/25 18:48:38','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501266103','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 18:48: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'),6103,'眼科普通号','上午','1','100444828','王玮','WANG  ','男','34','一般人员','自费','','普通号','1','0327','','1',to_date('2025/01/25 18:48:38','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501266103','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'),6103,'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>202501266103</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501266103</pinkey><ordertime>2025-01-25 18:48:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 19:14:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17832767516</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_内分泌科普通号</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>430421197510010045</patientidcard><patientname>李芬</patientname><patientsex>女</patientsex><patientbirthday>1975-10-01</patientbirthday><medicalrecord></medicalrecord><contactphone>17832767516</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 19:14:40
记录内容：select * from  pat_master_index where id_no='430421197510010045' and name='李芬' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1975/10/1 0:00:0050
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 19:14:40
记录内容：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-25 19:14:40
记录内容： 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'),6133,'内分泌科普通号','上午','1','100466740','李芬','LI FEN ','女','50','一般人员','自费','','普通号','1','0315','','1',to_date('2025/01/25 19:14:39','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501276133','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 19:14:40
记录内容：<?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'),6133,'内分泌科普通号','上午','1','100466740','李芬','LI FEN ','女','50','一般人员','自费','','普通号','1','0315','','1',to_date('2025/01/25 19:14:39','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501276133','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'),6133,'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>202501276133</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501276133</pinkey><ordertime>2025-01-25 19:14:40</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 19:42:33
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>15100626528</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_口腔科普通号</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197307021223</patientidcard><patientname>田海潮</patientname><patientsex>女</patientsex><patientbirthday>1973-07-02</patientbirthday><medicalrecord></medicalrecord><contactphone>15100626528</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-25 19:42:33
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/27','YYYY-MM-DD')
            AND CLINIC_LABEL='口腔科普通号' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='132822197307021223' and name='田海潮' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 19:42:33
记录内容：<?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-25 19:56:42
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13520130255</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_下午_呼吸内科高立静</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>450881198808106679</patientidcard><patientname>杨锐桂</patientname><patientsex>男</patientsex><patientbirthday>1988-08-10</patientbirthday><medicalrecord></medicalrecord><contactphone>13520130255</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 19:56:43
记录内容：select * from  pat_master_index where id_no='450881198808106679' and name='杨锐桂' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1988/8/10 0:00:0037
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 19:56:43
记录内容：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-25 19:56:43
记录内容： 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'),6201,'呼吸内科高立静','下午','3','Z00444572','杨锐桂','','男','37','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/25 19:56:42','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266201','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 19:56:43
记录内容：<?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'),6201,'呼吸内科高立静','下午','3','Z00444572','杨锐桂','','男','37','一般人员','自费','','副主任号','1','0317','GLJ','1',to_date('2025/01/25 19:56:42','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266201','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'),6201,'14:30-15: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>202501266201</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501266201</pinkey><ordertime>2025-01-25 19:56:43</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 20:03:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17310126761</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_上午_心血管内郭晓光普</scheduleid><parttimeid>8:30-9:00</parttimeid><certtypeno>1</certtypeno><patientidcard>231003196404092010</patientidcard><patientname>邱世昌</patientname><patientsex>男</patientsex><patientbirthday>1964-04-09</patientbirthday><medicalrecord></medicalrecord><contactphone>17310126761</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 20:03:13
记录内容：select * from  pat_master_index where id_no='231003196404092010' and name='邱世昌' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1964/4/9 0:00:0061
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 20:03:13
记录内容：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-25 20:03: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/26','YYYY/MM/DD'),6211,'心血管内郭晓光普','上午','4','Z00197879','邱世昌','','男','61','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/01/25 20:03:13','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501266211','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 20:03: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/26','YYYY/MM/DD'),6211,'心血管内郭晓光普','上午','4','Z00197879','邱世昌','','男','61','一般人员','自费','','普通号','1','0359','GXG','1',to_date('2025/01/25 20:03:13','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501266211','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/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'),6211,'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>202501266211</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501266211</pinkey><ordertime>2025-01-25 20:03:13</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 20:06:13
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13394312897</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_白天_妇科王兰</scheduleid><parttimeid>13:00-13:30</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197601183549</patientidcard><patientname>施海霞</patientname><patientsex>女</patientsex><patientbirthday>1976-01-18</patientbirthday><medicalrecord></medicalrecord><contactphone>13394312897</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 20:06:13
记录内容：select * from  pat_master_index where id_no='132822197601183549' and name='施海霞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1976/1/18 0:00:0049
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 20:06:13
记录内容：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-25 20:06: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/26','YYYY/MM/DD'),6218,'妇科王兰','白天','5','Z00038743','施海霞','SHI HAI XIA','女','49','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/01/25 20:06:13','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266218','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 20:06: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'),6218,'妇科王兰','白天','5','Z00038743','施海霞','SHI HAI XIA','女','49','一般人员','自费','','副主任号','1','0316','WANGL','1',to_date('2025/01/25 20:06:13','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266218','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/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'),6218,'13:00-13: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>202501266218</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501266218</pinkey><ordertime>2025-01-25 20:06:14</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 20:09:12
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>13394312897</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_白天_胃肠肿瘤钱海龙</scheduleid><parttimeid>13:30-14:00</parttimeid><certtypeno>1</certtypeno><patientidcard>132822197601183549</patientidcard><patientname>施海霞</patientname><patientsex>女</patientsex><patientbirthday>1976-01-18</patientbirthday><medicalrecord></medicalrecord><contactphone>13394312897</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 20:09:12
记录内容：select * from  pat_master_index where id_no='132822197601183549' and name='施海霞' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1976/1/18 0:00:0049
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 20:09:12
记录内容：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-25 20:09:12
记录内容： 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'),6219,'胃肠肿瘤钱海龙','白天','1','Z00038743','施海霞','SHI HAI XIA','女','49','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2025/01/25 20:09:12','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266219','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 20:09:12
记录内容：<?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'),6219,'胃肠肿瘤钱海龙','白天','1','Z00038743','施海霞','SHI HAI XIA','女','49','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2025/01/25 20:09:12','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266219','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'),6219,'13:30-14: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>202501266219</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501266219</pinkey><ordertime>2025-01-25 20:09:12</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 20:12:39
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18571641685</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_白天_胃肠肿瘤钱海龙</scheduleid><parttimeid>14:00-14:30</parttimeid><certtypeno>1</certtypeno><patientidcard>131028199806051243</patientidcard><patientname>孙施施</patientname><patientsex>女</patientsex><patientbirthday>1998-06-05</patientbirthday><medicalrecord></medicalrecord><contactphone>18571641685</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 20:12:39
记录内容：select * from  pat_master_index where id_no='131028199806051243' and name='孙施施' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1998/6/5 0:00:0027
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 20:12:39
记录内容：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-25 20:12:39
记录内容： 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'),6227,'胃肠肿瘤钱海龙','白天','2','100466743','孙施施','SUN SHI SHI ','女','27','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2025/01/25 20:12:39','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266227','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 20:12: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'),6227,'胃肠肿瘤钱海龙','白天','2','100466743','孙施施','SUN SHI SHI ','女','27','一般人员','自费','','副主任号','1','0335','QHL','1',to_date('2025/01/25 20:12:39','yyyy/mm/dd hh24:mi:ss'),'6','4','0.00','10','202501266227','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'),6227,'14:00-14: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>202501266227</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>6</registrationfee><pinkey>202501266227</pinkey><ordertime>2025-01-25 20:12:39</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 21:44:09
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>17710527374</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_心慌门诊谭琛</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>131082197310030544</patientidcard><patientname>刘树侠</patientname><patientsex>女</patientsex><patientbirthday>1973-10-03</patientbirthday><medicalrecord></medicalrecord><contactphone>17710527374</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 21:44:09
记录内容：select * from  pat_master_index where id_no='131082197310030544' and name='刘树侠' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1973/10/3 0:00:0052
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 21:44:09
记录内容：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-25 21:44: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/27','YYYY/MM/DD'),6305,'心慌门诊谭琛','上午','2','100466748','刘树侠','LIU SHU XIA ','女','52','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/01/25 21:44:08','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501276305','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','2') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 21:44: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/27','YYYY/MM/DD'),6305,'心慌门诊谭琛','上午','2','100466748','刘树侠','LIU SHU XIA ','女','52','一般人员','自费','','知名专家','1','0359','TANC','1',to_date('2025/01/25 21:44:08','yyyy/mm/dd hh24:mi:ss'),'46','4','0.00','50','202501276305','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'),6305,'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>202501276305</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>46</registrationfee><pinkey>202501276305</pinkey><ordertime>2025-01-25 21:44:09</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 22:16:52
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>16632489296</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_下午_产科辛俊英</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130828199905113721</patientidcard><patientname>周宇欣</patientname><patientsex>女</patientsex><patientbirthday>1999-05-11</patientbirthday><medicalrecord></medicalrecord><contactphone>16632489296</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 22:16:52
记录内容：select * from  pat_master_index where id_no='130828199905113721' and name='周宇欣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1999/5/11 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 22:16:52
记录内容：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-25 22:16: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/26','YYYY/MM/DD'),6328,'产科辛俊英','下午','3','100466749','周宇欣','ZHOU YU XIN ','女','26','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/25 22:16:51','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501266328','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','3') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 22:16: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/26','YYYY/MM/DD'),6328,'产科辛俊英','下午','3','100466749','周宇欣','ZHOU YU XIN ','女','26','一般人员','自费','','主任号','1','0330','XINJY','1',to_date('2025/01/25 22:16:51','yyyy/mm/dd hh24:mi:ss'),'16','4','0.00','20','202501266328','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/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'),6328,'14:30-15: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>202501266328</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>16</registrationfee><pinkey>202501266328</pinkey><ordertime>2025-01-25 22:16:52</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 22:19:38
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>16632489296</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/26 0:00:00_下午_产科陈静</scheduleid><parttimeid>14:30-15:00</parttimeid><certtypeno>1</certtypeno><patientidcard>130828199905113721</patientidcard><patientname>周宇欣</patientname><patientsex>女</patientsex><patientbirthday>1999-05-11</patientbirthday><medicalrecord></medicalrecord><contactphone>16632489296</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：入参
记录时间：2025-01-25 22:19:38
记录内容：select * from  pat_master_index where id_no='130828199905113721' and name='周宇欣' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc获取的生日1999/5/11 0:00:0026
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：预约语句
记录时间：2025-01-25 22:19: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-25 22:19: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'),6330,'产科陈静','下午','8','100466749','周宇欣','ZHOU YU XIN ','女','26','一般人员','自费','','普通号','1','0330','CJ21','1',to_date('2025/01/25 22:19:37','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501266330','9328','Y','','0','无','无','1','微信','','0.00','0.00','0.00','0','1') 
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 22:19: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/26','YYYY/MM/DD'),6330,'产科陈静','下午','8','100466749','周宇欣','ZHOU YU XIN ','女','26','一般人员','自费','','普通号','1','0330','CJ21','1',to_date('2025/01/25 22:19:37','yyyy/mm/dd hh24:mi:ss'),'1','4','0.00','5','202501266330','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'),6330,'14:30-15: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>202501266330</orderid><reservefee>0.00</reservefee><clinicfee>4</clinicfee><registrationfee>1</registrationfee><pinkey>202501266330</pinkey><ordertime>2025-01-25 22:19:38</ordertime><payregfee>0</payregfee></outputvalues></response>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：新建订单并锁号 的入参
记录时间：2025-01-25 23:32:43
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18033646520</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_白天_痤疮门诊普通号</scheduleid><parttimeid>9:30-10:00</parttimeid><certtypeno>1</certtypeno><patientidcard>230208199002100052</patientidcard><patientname>姜俊全</patientname><patientsex>男</patientsex><patientbirthday>1990-02-10</patientbirthday><medicalrecord></medicalrecord><contactphone>18033646520</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-25 23:32:44
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/27','YYYY-MM-DD')
            AND CLINIC_LABEL='痤疮门诊普通号' AND TIME_DESC='白天'0select * from  pat_master_index where id_no='230208199002100052' and name='姜俊全' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 23:32:44
记录内容：<?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-25 23:35:20
记录内容：<?xml version="1.0" encoding="utf-8"?><request><invoker><requestid>cyys_2017@123</requestid><password>cyys_2017@123</password></invoker><requestdata><reservemobile>18033646520</reservemobile><hospitalid>1001</hospitalid><scheduleid>2025/1/27 0:00:00_上午_皮肤科普通号</scheduleid><parttimeid>10:00-10:30</parttimeid><certtypeno>1</certtypeno><patientidcard>230208199002100052</patientidcard><patientname>姜俊全</patientname><patientsex>男</patientsex><patientbirthday>1990-02-10</patientbirthday><medicalrecord></medicalrecord><contactphone>18033646520</contactphone><familyaddress></familyaddress><payregfee>1</payregfee></requestdata></request>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：没有找到患者或号源为0
记录时间：2025-01-25 23:35:20
记录内容：=!=挂号失败：号源：！1;人员：0select * from  clinic_for_regist   where  clinic_date=to_date('2025/01/27','YYYY-MM-DD')
            AND CLINIC_LABEL='皮肤科普通号' AND TIME_DESC='上午'0select * from  pat_master_index where id_no='230208199002100052' and name='姜俊全' and CHARGE_TYPE='自费'  order  by CREATE_DATE desc
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆
◆◆◆◆◆◆◆◆◆◆日志记录开始◆◆◆◆◆◆◆◆◆
记录描述：返回参数
记录时间：2025-01-25 23:35:20
记录内容：<?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>
◆◆◆◆◆◆◆◆◆◆日志记录结束◆◆◆◆◆◆◆◆◆