private function move() { $tRedis = Cache_Redis::instance(); $tKeys = $tRedis->hKeys('dakang_incognito_real'); if (!count($tKeys)) { return; } $tIBPMO = new I_BloodpressureModel(); $tRBPMO = new R_BloodpressureModel(); $tIFAMO = new I_FoodaddModel(); $tRFAMO = new R_FoodaddModel(); $tIWMO = new I_WeightModel(); $tRWMO = new R_WeightModel(); foreach ($tKeys as $tDid) { $tRWMO->begin(); $tUid = $tRedis->hget('dakang_incognito_real', $tDid); if (empty($tUid)) { continue; } $tRedis->hdel('dakang_incognito_real', $tDid); #血压 $tIBPDatas = $tIBPMO->field('*')->where('did = \'' . $tDid . '\'')->fList(); foreach ($tIBPDatas as $tRow) { $tID = $tRow['id']; unset($tRow['id']); unset($tRow['did']); $tRow['uid'] = $tUid; if (!$tRBPMO->insert($tRow)) { $tRWMO->back(); continue; } $tSql = 'delete from ' . $tIBPMO->table . ' where id = ' . $tID; if (!$tIBPMO->exec($tSql)) { $tRWMO->back(); continue; } } #饮食记录 $tIFADatas = $tIFAMO->field('*')->where('did = \'' . $tDid . '\'')->fList(); foreach ($tIFADatas as $tRow) { $tID = $tRow['id']; unset($tRow['id']); unset($tRow['did']); $tRow['uid'] = $tUid; if (!$tRFAMO->insert($tRow)) { $tRWMO->back(); continue; } $tSql = 'delete from ' . $tIFAMO->table . ' where id = ' . $tID; if (!$tIFAMO->exec($tSql)) { $tRWMO->back(); continue; } } #体重 $tIWDatas = $tIWMO->field('*')->where('did = \'' . $tDid . '\'')->fList(); foreach ($tIWDatas as $tRow) { $tID = $tRow['id']; unset($tRow['id']); unset($tRow['did']); $tRow['uid'] = $tUid; if (!$tRWMO->insert($tRow)) { $tRWMO->back(); continue; } $tSql = 'delete from ' . $tIWMO->table . ' where id = ' . $tID; if (!$tIWMO->exec($tSql)) { $tRWMO->back(); continue; } } $tRWMO->commit(); } }
public function listAction() { $p = $_REQUEST; $pDate = empty($p['date']) ? Tool_Fnc::ajaxMsg('日期不能为空') : trim($p['date']); $pDid = empty($p['did']) ? Tool_Fnc::ajaxMsg('DID不能为空') : trim($p['did']); if (!Tool_Validate::az09($pDid)) { Tool_Fnc::ajaxMsg('did格式不正确'); } if (!Tool_Validate::is_date($pDate)) { Tool_Fnc::ajaxMsg('日期不正确'); } $tImgUrl = Yaf_Registry::get("config")->web->url->img; $tFAMO = new I_FoodaddModel(); $tFUMO = new FoodunitsModel(); $tDatas = array(); $tFADatas = $tFAMO->field('id,fid,mt_id,mt_name,title,unit,amount,weight,protein,tag,concat(\'' . $tImgUrl . '\',thumb_img) thumb_img')->where('did = \'' . $pDid . '\' and created >=' . strtotime($pDate) . ' and created <=' . strtotime($pDate . ' 23:59:59'))->fList(); foreach ($tFADatas as $tKey => $tRow) { $tUnits = $tFUMO->field('amount,unit,weight')->where('fid = ' . $tRow['fid'])->fList(); $tDatas[$tRow['mt_id']][] = array_merge($tRow, array('units' => $tUnits)); } Tool_Fnc::ajaxMsg('', 1, $tDatas); }