public function is_dryweight($pUid, $pDate)
{
$tTime = time();
$tDatetime = strtotime($pDate);
if ($tTime < $tDatetime) {
return false;
}
$tDWLMO = new DryweightlogModel();
$tRow = $tDWLMO->field('weight')->where('uid = ' . $pUid . ' and date = \'' . $pDate . '\'')->fRow();
if (isset($tRow['weight'])) {
return $tRow['weight'];
}
#判断该日期之前的干体重
$tDWLRow = $tDWLMO->field('weight')->where('uid = ' . $pUid . ' and date < ' . $pDate)->order('date desc')->limit('1')->fRow();
if (count($tDWLRow)) {
self::add_weight($pUid, $pDate, $tDWLRow['weight']);
return $tDWLRow['weight'];
}
#判断该日期之后临近的干体重
$tDWLRow = $tDWLMO->field('weight')->where('uid = ' . $pUid . ' and date > ' . $pDate)->order('date desc')->limit('1')->fRow();
if (count($tDWLRow)) {
self::add_weight($pUid, $pDate, $tDWLRow['weight']);
return $tDWLRow['weight'];
}
#用户干体重
$tUMO = new UserModel();
$tURow = $tUMO->field('dry_weight weight')->where('id = ' . $pUid)->fRow();
if (count($tURow)) {
self::add_weight($pUid, $pDate, $tURow['weight']);
return $tURow['weight'];
}
}
public function editAction()
{
$p = $_REQUEST;
$pWeight = empty($p['weight']) ? Tool_Fnc::ajaxMsg('干体重不能为空') : floatval($p['weight']);
$tTime = time();
$tDWLMO = new DryweightlogModel();
$tDWLRow = $tDWLMO->field('id')->where('uid = ' . $this->tUid . ' and date = \'' . date('Y-m-d', $tTime) . '\'')->fRow();
$tUMO = new UserModel();
$tURow = $tUMO->field('user_type')->where(' id = ' . $this->tUid)->fRow();
if ($tURow['user_type'] == 1) {
Tool_Fnc::ajaxMsg('操作异常');
}
$tData = array('weight' => $pWeight);
if (empty($tDWLRow['id'])) {
$tData = array_merge($tData, array('created' => $tTime, 'uid' => $this->tUid, 'date' => date('Y-m-d', $tTime), 'year' => date('Y', $tTime), 'month' => date('Y-m', $tTime)));
} else {
$tData = array_merge($tData, array('updated' => $tTime, 'id' => $tDWLRow['id']));
}
$tUMO->begin();
if (!$tDWLMO->save($tData)) {
$tUMO->back();
Tool_Fnc::ajaxMsg('修改失败 001');
}
$tUData = array('id' => $this->tUid, 'dry_weight' => $pWeight, 'updated' => $tTime);
if (!$tUMO->update($tUData)) {
$tUMO->back();
Tool_Fnc::ajaxMsg('修改失败 002');
}
$tUMO->commit();
Tool_Fnc::ajaxMsg('操作成功', 1);
}
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;
}
public function indexAction()
{
$tUMO = new UserModel();
$tDWLMO = new DryweightlogModel();
$tUDatas = $tUMO->field('id,dry_weight')->fList();
$tTime = time();
$tDate = date('Y-m-d', $tTime);
foreach ($tUDatas as $tURow) {
$tDWLRow = $tDWLMO->field('id')->where('uid = ' . $tURow['id'] . ' and date = \'' . $tDate . '\'')->fRow();
if (!empty($tDWLRow['id'])) {
continue;
}
$tData = array('weight' => $tURow['dry_weight'], 'uid' => $tURow['id'], 'created' => $tTime, 'date' => $tDate, 'year' => date('Y', $tTime), 'month' => date('Y-m', $tTime));
$tDWLMO->insert($tData);
}
exit;
}
public function dietAction()
{
$p = $_REQUEST;
$pDate = empty($p['date']) ? Tool_Fnc::ajaxMsg('日期不能为空') : trim($p['date']);
if (!Tool_Validate::is_date($pDate)) {
Tool_Fnc::ajaxMsg('日期不正确');
}
$tFAMO = new R_FoodaddModel();
$tFMO = new FoodModel();
$tSql = 'select * from (select fid,unit,amount,weight from ' . $tFAMO->table . ' where uid = ' . $this->tUid . ' and created >=' . strtotime($pDate) . ' and created <=' . strtotime($pDate . ' 23:59:59') . ') fa, ' . $tFMO->table . ' f where fa.fid = f.id';
$tList = $tFMO->query($tSql);
# if(!count($tList)){Tool_Fnc::ajaxMsg('',1);}
$tDatas = array();
$tDatasother = array();
#已经摄取
isset($tDatasother['calcium']['number']) ? '' : ($tDatasother['calcium']['number'] = 0);
isset($tDatasother['vitamin_a']['number']) ? '' : ($tDatasother['vitamin_a']['number'] = 0);
isset($tDatasother['zinc']['number']) ? '' : ($tDatasother['zinc']['number'] = 0);
isset($tDatasother['magnesium']['number']) ? '' : ($tDatasother['magnesium']['number'] = 0);
isset($tDatasother['vitamin_c']['number']) ? '' : ($tDatasother['vitamin_c']['number'] = 0);
isset($tDatasother['fiber_dietary']['number']) ? '' : ($tDatasother['fiber_dietary']['number'] = 0);
isset($tDatasother['selenium']['number']) ? '' : ($tDatasother['selenium']['number'] = 0);
isset($tDatasother['copper']['number']) ? '' : ($tDatasother['copper']['number'] = 0);
isset($tDatasother['fat']['number']) ? '' : ($tDatasother['fat']['number'] = 0);
isset($tDatasother['niacin']['number']) ? '' : ($tDatasother['niacin']['number'] = 0);
isset($tDatasother['vitamin_e']['number']) ? '' : ($tDatasother['vitamin_e']['number'] = 0);
isset($tDatasother['manganese']['number']) ? '' : ($tDatasother['manganese']['number'] = 0);
isset($tDatasother['cholesterol']['number']) ? '' : ($tDatasother['cholesterol']['number'] = 0);
isset($tDatasother['iron']['number']) ? '' : ($tDatasother['iron']['number'] = 0);
isset($tDatasother['thiamine']['number']) ? '' : ($tDatasother['thiamine']['number'] = 0);
isset($tDatasother['lactoflavin']['number']) ? '' : ($tDatasother['lactoflavin']['number'] = 0);
isset($tDatasother['calory']['number']) ? '' : ($tDatasother['calory']['number'] = 0);
isset($tDatasother['carotene']['number']) ? '' : ($tDatasother['carotene']['number'] = 0);
isset($tDatas['carbohydrate']['number']) ? '' : ($tDatas['carbohydrate']['number'] = 0);
isset($tDatas['phosphor']['number']) ? '' : ($tDatas['phosphor']['number'] = 0);
isset($tDatas['kalium']['number']) ? '' : ($tDatas['kalium']['number'] = 0);
isset($tDatas['natrium']['number']) ? '' : ($tDatas['natrium']['number'] = 0);
isset($tDatas['protein']['number']) ? '' : ($tDatas['protein']['number'] = 0);
foreach ($tList as $tRow) {
$tDatasother['calcium']['number'] += round($tRow['calcium'] / 100 * $tRow['weight'], 2);
$tDatasother['vitamin_a']['number'] += round($tRow['vitamin_a'] / 100 * $tRow['weight'], 2);
$tDatasother['zinc']['number'] += round($tRow['zinc'] / 100 * $tRow['weight'], 2);
$tDatasother['magnesium']['number'] += round($tRow['magnesium'] / 100 * $tRow['weight'], 2);
$tDatasother['vitamin_c']['number'] += round($tRow['vitamin_c'] / 100 * $tRow['weight'], 2);
$tDatasother['fiber_dietary']['number'] += round($tRow['fiber_dietary'] / 100 * $tRow['weight'], 2);
$tDatasother['selenium']['number'] += round($tRow['selenium'] / 100 * $tRow['weight'], 2);
$tDatasother['copper']['number'] += round($tRow['copper'] / 100 * $tRow['weight'], 2);
$tDatasother['fat']['number'] += round($tRow['fat'] / 100 * $tRow['weight'], 2);
$tDatasother['niacin']['number'] += round($tRow['niacin'] / 100 * $tRow['weight'], 2);
$tDatasother['vitamin_e']['number'] += round($tRow['vitamin_e'] / 100 * $tRow['weight'], 2);
$tDatasother['manganese']['number'] += round($tRow['manganese'] / 100 * $tRow['weight'], 2);
$tDatasother['cholesterol']['number'] += round($tRow['cholesterol'] / 100 * $tRow['weight'], 2);
$tDatasother['iron']['number'] += round($tRow['iron'] / 100 * $tRow['weight'], 2);
$tDatasother['thiamine']['number'] += round($tRow['thiamine'] / 100 * $tRow['weight'], 2);
$tDatasother['lactoflavin']['number'] += round($tRow['lactoflavin'] / 100 * $tRow['weight'], 2);
$tDatasother['calory']['number'] += round($tRow['calory'] / 100 * $tRow['weight'], 2);
$tDatasother['carotene']['number'] += round($tRow['carotene'] / 100 * $tRow['weight'], 2);
$tDatas['carbohydrate']['number'] += round($tRow['carbohydrate'] / 100 * $tRow['weight'], 2);
#碳水化合物
$tDatas['phosphor']['number'] += round($tRow['phosphor'] / 100 * $tRow['weight'] / 1000, 2);
#磷
#$tDatas['kalium']['number'] += round(($tRow['kalium']/100)*$tRow['weight']/1000,2);#钾
$tDatas['natrium']['number'] += round($tRow['natrium'] / 100 * $tRow['weight'] / 1000, 2);
#钠
$tDatas['protein']['number'] += round($tRow['protein'] / 100 * $tRow['weight'], 2);
#蛋白质
}
unset($tList);
#干体重
$tDWLMO = new DryweightlogModel();
$tDWLRow = $tDWLMO->field('weight')->where('uid = ' . $this->tUid . ' and date = \'' . $pDate . '\'')->fRow();
if (!count($tDWLRow)) {
Tool_Fnc::ajaxMsg('', 1);
}
#应摄取
#蛋白质
$tArr = $tFMO->diet('protein', $tDWLRow['weight']);
$tDatas['protein']['total'] = implode('-', $tArr);
$tSurplus = $tArr['end'] - $tDatas['protein']['number'];
$tDatas['protein']['surplus'] = $tSurplus <= 0 ? 0 : $tSurplus;
#碳水化合物
$tArr = $tFMO->diet('carbohydrate', $tDWLRow['weight']);
$tDatas['carbohydrate']['total'] = implode('-', $tArr);
$tSurplus = $tArr['end'] - $tDatas['carbohydrate']['number'];
$tDatas['carbohydrate']['surplus'] = $tSurplus <= 0 ? 0 : $tSurplus;
#钠
$tArr = $tFMO->diet('natrium');
$tDatas['natrium']['total'] = implode('-', $tArr);
$tSurplus = $tArr['end'] - $tDatas['natrium']['number'];
$tDatas['natrium']['surplus'] = $tSurplus <= 0 ? 0 : $tSurplus;
#磷
$tArr = $tFMO->diet('phosphor');
$tDatas['phosphor']['total'] = implode('-', $tArr);
$tSurplus = $tArr['end'] - $tDatas['phosphor']['number'];
$tDatas['phosphor']['surplus'] = $tSurplus <= 0 ? 0 : $tSurplus;
#营养摄入评判
#蛋白质
$tDatas['protein']['status'] = $tFMO->diet_status('protein', $tDatas['protein']['number'], $tDWLRow['weight']);
#碳水化合物
$tDatas['carbohydrate']['status'] = $tFMO->diet_status('carbohydrate', $tDatas['carbohydrate']['number'], $tDWLRow['weight']);
#钠
$tDatas['natrium']['status'] = $tFMO->diet_status('natrium', $tDatas['natrium']['number']);
#磷
$tDatas['phosphor']['status'] = $tFMO->diet_status('phosphor', $tDatas['phosphor']['number']);
#控钾单独处理
$tUMO = new UserModel();
$tODDMO = new OrdinarydialysisdateModel();
$tBSDMO = new BqeschedulingdetailModel();
$tURow = $tUMO->field('user_type')->where('id = ' . $this->tUid)->fRow();
$tStart = $pDate;
$tEnd = $pDate;
if ($tURow['user_type'] == 0) {
#非白求恩
$tODDRow = $tODDMO->field('date')->where('uid = \'' . $this->tUid . '\' and date < \'' . $pDate . '\'')->order('date desc')->limit('1')->fRow();
if (!empty($tODDRow['date'])) {
$tStart = date('Y-m-d', strtotime($tODDRow['date']) + 86400);
}
} else {
#白求恩
$tBSDRow = $tBSDMO->field('scheduling_date')->where('uid = \'' . $this->tUid . '\' and scheduling_date < \'' . $pDate . '\'')->order('scheduling_date desc')->limit('1')->fRow();
if (!empty($tBSDRow['scheduling_date'])) {
$tStart = date('Y-m-d', strtotime($tBSDRow['scheduling_date']) + 86400);
}
}
$tSql = 'select fid,unit,amount,weight,kalium from (select fid,unit,amount,weight from ' . $tFAMO->table . ' where uid = ' . $this->tUid . ' and created >=' . strtotime($tStart) . ' and created <=' . strtotime($tEnd . ' 23:59:59') . ') fa, ' . $tFMO->table . ' f where fa.fid = f.id';
$tList = $tFMO->query($tSql);
foreach ($tList as $tRow) {
$tDatas['kalium']['number'] += round($tRow['kalium'] / 100 * $tRow['weight'] / 1000, 2);
#钾
}
#钾
$tArr = $tFMO->diet('kalium');
#$tDatas['kalium']['total'] = implode('-',$tArr);
$tDatas['kalium']['total'] = 10;
$tSurplus = $tArr['end'] - $tDatas['kalium']['number'];
$tDatas['kalium']['surplus'] = $tSurplus <= 0 ? 0 : $tSurplus;
$tDatas['kalium']['status'] = $tFMO->diet_status('kalium', $tDatas['kalium']['number']);
Tool_Fnc::ajaxMsg('', 1, array('main' => $tDatas, 'other' => $tDatasother));
exit;
}
public function yearAction()
{
$p = $_REQUEST;
$pDate = empty($p['date']) ? '' : trim($p['date']);
$pOpt = empty($p['opt']) ? 'left' : Tool_Fnc::safe_string($p['opt']);
if (!empty($pDate) && !Tool_Validate::is_date($pDate)) {
Tool_Fnc::ajaxMsg('日期不正确');
}
$tWhere = '';
$tTime = strtotime($pDate);
if ($pOpt == 'left') {
if (!empty($pDate)) {
$tEnd = date('Y-m-d', $tTime - 86400);
} else {
$tTime = time();
$tEnd = date('Y-m-d');
}
$tStart = date('Y-m-d', $tTime - 86400 * 364);
} else {
if (!empty($pDate)) {
$tStart = date('Y-m-d', $tTime + 86400);
} else {
$tTime = time();
$tStart = date('Y-m-d');
}
$tEnd = date('Y-m-d', $tTime + 86400 * 364);
}
$tTRMO = new BqetreatmentrecordModel();
$tTRDatas = $tTRMO->field('bodyweight_bef,bodyweight_after,treate_date')->where('uid = ' . $this->tUid . ' and treate_date between \'' . $tStart . '\' and \'' . $tEnd . '\'')->order('treate_date asc')->fList();
$tDWLMO = new DryweightlogModel();
$tDWLDatas = $tDWLMO->field('weight,date')->where('uid = ' . $this->tUid . ' and date between \'' . $tStart . '\' and \'' . $tEnd . '\'')->fList();
//最开始日期
$tSql = 'select treate_date from ' . $tTRMO->table . ' where uid = ' . $this->tUid . ' order by treate_date asc limit 1';
$tTRMOList = $tTRMO->query($tSql);
#用户最新干体重
$tUMO = new UserModel();
$tURow = $tUMO->field('dry_weight')->where('id = ' . $this->tUid)->fRow();
//如果没有干体重 初始化
$tDatearr = array();
for ($i = 0; $i < 364; $i++) {
$tDatearr[] = date('Y-m-d', strtotime($tStart) + 86400 * $i);
}
$tDWLDate = array();
foreach ($tDWLDatas as $tRow) {
$tDWLDate[] = $tRow['date'];
}
$tDatediff = array_diff($tDatearr, $tDWLDate);
$tDiffarr = array();
foreach ($tDatediff as $tDate) {
break;
#判断该日期之前的干体重
$tDWLRow = $tDWLMO->field('weight')->where('uid = ' . $this->tUid . ' and date < ' . $tDate)->order('date desc')->limit('1')->fRow();
if (count($tDWLRow)) {
$tDWLDatas[] = $tDiffarr[] = array('date' => $tDate, 'weight' => $tDWLRow['weight']);
continue;
}
#判断该日期之后临近的干体重
$tDWLRow = $tDWLMO->field('weight')->where('uid = ' . $this->tUid . ' and date > ' . $tDate)->order('date desc')->limit('1')->fRow();
if (count($tDWLRow)) {
$tDWLDatas[] = $tDiffarr[] = array('date' => $tDate, 'weight' => $tDWLRow['weight']);
continue;
}
#当前用户干体重
$tDWLDatas[] = $tDiffarr[] = array('date' => $tDate, 'weight' => $tURow['dry_weight']);
}
#将没有干体重的天入库
foreach ($tDiffarr as $tRow) {
break;
if ($tDWLMO->in_weight($this->tUid, $tRow['date'])) {
continue;
}
$tData = array('weight' => $tRow['weight'], 'uid' => $this->tUid, 'created' => $tTime, 'date' => $tRow['date'], 'month' => date('Y-m', strtotime($tRow['date'])), 'year' => date('Y-m', strtotime($tRow['date'])));
$tDWLMO->insert($tData);
}
#排除 只要有体重的 干体重╮(╯▽╰)╭
$tTRDate = array();
foreach ($tTRDatas as $tRow) {
$tTRDate[] = $tRow['treate_date'];
}
foreach ($tDWLDatas as $tKey => $tRow) {
if (!in_array($tRow['date'], $tTRDate)) {
unset($tDWLDatas[$tKey]);
}
}
$tDWLDatas = Tool_Fnc::arraySort($tDWLDatas, 'date', 'asc');
Tool_Fnc::ajaxMsg('', 1, array('dry_weight' => $tDWLDatas, 'weight' => $tTRDatas, 'start_treate_date' => $tTRMOList[0]['treate_date']));
}
public function editAction()
{
$p = $_REQUEST;
$tUMO = new UserModel();
$tURow = $tUMO->field('user_type')->where(' id = ' . $this->tUid)->fRow();
if ($tURow['user_type'] == 1) {
Tool_Fnc::ajaxMsg('操作异常');
}
$tData = array();
if (isset($p['name'])) {
$tData = array_merge($tData, array('nickname' => Tool_Fnc::safe_string($p['name'])));
}
if (isset($p['date_of_birth'])) {
$tData = array_merge($tData, array('date_of_birth' => date('Y-m-d', strtotime($p['date_of_birth']))));
}
if (isset($p['sex'])) {
$tData = array_merge($tData, array('sex' => intval($p['sex'])));
}
$tTime = time();
//存在干体重修改,则更新干体重记录
$pDryWeight = !isset($p['dry_weight']) ? '' : floatval($p['dry_weight']);
$tUMO->begin();
if (!empty($pDryWeight)) {
$tData = array_merge($tData, array('dry_weight' => $pDryWeight));
$tDWLMO = new DryweightlogModel();
$tDWLRow = $tDWLMO->field('id')->where('uid = ' . $this->tUid . ' and date = \'' . date('Y-m-d', $tTime) . '\'')->fRow();
if (empty($tDWLRow['id'])) {
$tDWLData = array('weight' => $pDryWeight, 'uid' => $this->tUid, 'created' => $tTime, 'date' => date('Y-m-d', $tTime), 'month' => date('Y-m', $tTime), 'year' => date('Y', $tTime));
} else {
$tDWLData = array('weight' => $pDryWeight, 'updated' => $tTime, 'id' => $tDWLRow['id']);
}
if (!$tDWLMO->save($tDWLData)) {
$tUMO->back();
Tool_Fnc::ajaxMsg('修改失败 001');
}
}
//存在名字修改，则更新健康档案中的名字字段
if (isset($p['name']) && !empty($p['name'])) {
$tUAMO = new UserassessmentModel();
$tUARow = $tUAMO->field('id,name')->where('uid = ' . $this->tUid)->fRow();
if (!empty($tUARow['id'])) {
$tUADatas = array('id' => $tUARow['id'], 'name' => Tool_Fnc::safe_string($p['name']), 'updated' => $tTime);
if (!$tUAMO->update($tUADatas)) {
$tUMO->back();
Tool_Fnc::ajaxMsg('修改失败 002');
}
} else {
$tUADatas = array('uid' => $this->tUid, 'name' => Tool_Fnc::safe_string($p['name']), 'created' => $tTime);
if (!$tUAMO->insert($tUADatas)) {
$tUMO->back();
Tool_Fnc::ajaxMsg('修改失败 002');
}
}
}
$tData = array_merge($tData, array('id' => $this->tUid, 'updated' => $tTime));
if (!$tUMO->update($tData)) {
$tUMO->back();
Tool_Fnc::ajaxMsg('修改失败 003');
}
$tUMO->commit();
Tool_Fnc::ajaxMsg('操作成功', 1);
}
public function yearAction()
{
$tDays = 365;
$tTime = time();
$tD = date('Y-m-d', $tTime);
$tD = date('Y-m-d');
$tDWLMO = new DryweightlogModel();
$tMO = new R_WeightModel();
$tYearDatas = $tMO->field('year')->where('uid = ' . $this->tUid)->group('year')->fList();
#获取记录体重年
if (empty($tYearDatas[0]['year'])) {
Tool_Fnc::ajaxMsg('', 1);
}
//获得干体重
$tDWLDatas = $tDWLMO->field('date,weight')->where('uid = ' . $this->tUid)->fList();
$tDWLArr = array();
foreach ($tDWLDatas as $tRow) {
$tDWLArr[$tRow['date']] = $tRow['weight'];
}
$tCDate = array();
$tCYear = array();
foreach ($tYearDatas as $tYearRow) {
$tCYear[] = $tYearRow['year'];
$tDatas = $tMO->field('*')->where('uid = ' . $this->tUid . ' and year = \'' . $tYearRow['year'] . '\'')->fList();
#查询当月的日期
foreach ($tDatas as $tDsRow) {
$tCDate[$tDsRow['date']][] = $tDsRow;
}
}
unset($tYearDatas);
sort($tCYear);
$tYDatas = array();
foreach ($tCYear as $tYVal) {
$tDays += date('L', strtotime($tYVal . '-01-01'));
$tDatas = array();
for ($i = 0; $i < $tDays; $i++) {
$tDate = date('Y-m-d', strtotime($tYVal . '-01-01') + 86400 * $i);
if ($tDate > $tD) {
continue;
}
if (isset($tCDate[$tDate])) {
#
//计算
$tTmp = array();
foreach ($tCDate[$tDate] as $tCDRow) {
$tStatus = $this->weightstatus($tDWLArr[$tDate], $tCDRow['number']);
if (!isset($tTmp[$tDate])) {
$tTmp[$tDate] = array();
}
if (!in_array($tStatus, $tTmp[$tDate])) {
$tTmp[$tDate][] = $tStatus;
}
}
foreach ($tTmp as $tTmparr) {
if (count($tTmparr) == 2) {
foreach ($tTmparr as $tT) {
$tDatas[$tT] += 0.5;
}
} else {
if (isset($tDatas[$tTmparr[0]])) {
$tDatas[$tTmparr[0]] += 1;
} else {
$tDatas[$tTmparr[0]] = 1;
}
}
}
unset($tTmp);
} else {
#未记录
if (isset($tDatas[5])) {
$tDatas[5] += 1;
} else {
$tDatas[5] = 1;
}
}
}
$tYDatas[$tYVal] = $tDatas;
unset($tDatas);
}
Tool_Fnc::ajaxMsg('', 1, $tYDatas);
exit;
}
