public function indexAction() { echo '<pre>'; $tTime = time(); $tH = date('H', $tTime); $tWhere = ' and PUNCTURE_NURSE is not NULL'; if ($tH >= 22 && $tH <= 23) { $tWhere = ''; } $tTRMO = new BqetreatmentrecordModel(); $tUAMO = new UserassessmentModel(); $tDWLMO = new DryweightlogModel(); $tUMO = new UserModel(); $tOci = new Orm_Oci(); $tHSql = 'select patient_id,treatment_times,fluid_volume,dialyzer,dialysis_mach,volume_na,volume_ca,volume_hc,volume_quantity,vascular_access,body_weight,bodyweight_bef,bodyweight_increase,ultrafilt_quantity,ufr,treat_time,blood_quantity,first_agent,maitain,additional,total_quantity,t,p,r,bp1,bp2,actual_treat_time,bodyweight_after,actual_ultrafilt_quantity,t_after,p_after,bp1_after,bp2_after,treate_summary,puncture_nurse,treate_nurse,doctor_user,to_char(treate_date,\'YYYY-mm-dd\') treate_date,treate_mode,dfz,vein_puncture,artery_puncture,kidney_solidification,dialyze_allergy,takeoff_needle from treatment_record where to_char(TREATE_DATE,\'YYYY-mm-dd\') = \'' . date('Y-m-d', $tTime) . '\' ' . $tWhere; #$tHSql = 'select patient_id,treatment_times,fluid_volume,dialyzer,dialysis_mach,volume_na,volume_ca,volume_hc,volume_quantity,vascular_access,body_weight,bodyweight_bef,bodyweight_increase,ultrafilt_quantity,ufr,treat_time,blood_quantity,first_agent,maitain,additional,total_quantity,t,p,r,bp1,bp2,actual_treat_time,bodyweight_after,actual_ultrafilt_quantity,t_after,p_after,bp1_after,bp2_after,treate_summary,puncture_nurse,treate_nurse,doctor_user,to_char(treate_date,\'YYYY-mm-dd\') treate_date,treate_mode,dfz,vein_puncture,artery_puncture,kidney_solidification,dialyze_allergy,takeoff_needle from treatment_record where to_char(TREATE_DATE,\'YYYY-mm-dd\') between \'2015-10-08\' and \'2015-12-08\''; $tDatas = $tOci->getAll($tHSql); foreach ($tDatas as $tRow) { $tTRRow = $tTRMO->field('count(0) c')->where('patient_id = \'' . $tRow['PATIENT_ID'] . '\' and treate_date = \'' . $tRow['TREATE_DATE'] . '\'')->fRow(); if (!empty($tTRRow['c'])) { continue; } foreach ($tRow as $k => $v) { $k = strtolower($k); $tData[$k] = $v; } $tUARow = $tUAMO->field('uid')->where('patient_id = \'' . $tRow['PATIENT_ID'] . '\'')->fRow(); $tData['uid'] = empty($tUARow['uid']) ? 0 : $tUARow['uid']; echo $tTRMO->insert($tData); echo "\r\n"; if (empty($tRow['BODY_WEIGHT'])) { continue; } if (!empty($tUid) && date('Y-m-d', $tTime) == $tRow['TREATE_DATE']) { #用户存在 并且干体重记录日期是今日 的话更新用户信息表 $tData = array('id' => $tUid, 'dry_weight' => $tRow['BODY_WEIGHT']); $tUMO->update($tData); } $tDWLRow = $tDWLMO->field('id')->where('patient_id = \'' . $tRow['PATIENT_ID'] . '\' and date = \'' . $tRow['TREATE_DATE'] . '\'')->fRow(); if (!empty($tDWLRow['id'])) { $tData = array('id' => $tDWLRow['id'], 'weight' => $tRow['BODY_WEIGHT'], 'updated' => $tTime); $tDWLMO->update($tData); } else { #干体重log $tData = array('weight' => $tRow['BODY_WEIGHT'], 'created' => $tTime, 'date' => $tRow['TREATE_DATE'], 'month' => date('Y-m', strtotime($tRow['TREATE_DATE'])), 'year' => date('Y', strtotime($tRow['TREATE_DATE'])), 'patient_id' => $tRow['PATIENT_ID']); $tDWLMO->insert($tData); } } exit; }