public function diethomeAction() { $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(); $tDWLMO = new DryweightlogModel(); $tDatas = array(); $tDWLRow['weight'] = $tDWLMO->is_dryweight($this->tUid, $pDate); $tArr = $tFMO->diet('protein', $tDWLRow['weight']); $tDatas['protein']['total'] = $tArr['start']; $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); $tDatas['protein']['surplus'] = 0; $tDatas['protein']['number'] = 0; if (!count($tList)) { Tool_Fnc::ajaxMsg('', 1, $tDatas); } #已经摄取 foreach ($tList as $tRow) { $tDatas['protein']['number'] += $tRow['protein'] / 100 * $tRow['weight']; #蛋白质 } unset($tList); #应摄取 #蛋白质 $tSurplus = $tArr['end'] - $tDatas['protein']['number']; $tDatas['protein']['surplus'] = $tSurplus <= 0 ? 0 : $tSurplus; Tool_Fnc::ajaxMsg('', 1, $tDatas); exit; }
public function dietAction() { $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('日期不正确'); } $tFAMO = new I_FoodaddModel(); $tFMO = new FoodModel(); $tSql = 'select * from (select fid,unit,amount,weight from ' . $tFAMO->table . ' where did = \'' . $pDid . '\' 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); $tDatas['carbohydrate']['number'] = round($tRow['carbohydrate'] / 100 * $tRow['weight'], 2); #碳水化合物 $tDatas['phosphor']['number'] = round($tRow['phosphor'] / 100 * $tRow['weight'] / 1000, 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); $tDatas['kalium']['number'] = round($tRow['kalium'] / 100 * $tRow['weight'] / 1000, 2); #钾 $tDatas['natrium']['number'] = round($tRow['natrium'] / 100 * $tRow['weight'] / 1000, 2); #钠 $tDatasother['thiamine']['number'] = round($tRow['thiamine'] / 100 * $tRow['weight'], 2); $tDatas['protein']['number'] = round($tRow['protein'] / 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); } unset($tList); #钠 $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; #钾 # $tArr = $tFMO->diet('kalium'); # $tDatas['kalium']['total'] = implode('-',$tArr); # $tSurplus = $tArr['end']-$tDatas['kalium']['number']; # $tDatas['kalium']['surplus'] = ($tSurplus <= 0)?0:$tSurplus; $tDatas['kalium']['total'] = 10; $tDatas['kalium']['surplus'] = 0; $tDatas['protein']['total'] = 0; $tDatas['protein']['surplus'] = 0; $tDatas['carbohydrate']['total'] = 0; $tDatas['carbohydrate']['surplus'] = 0; Tool_Fnc::ajaxMsg('', 1, array('main' => $tDatas, 'other' => $tDatasother)); exit; }