public function addAction() { $p = $_REQUEST; $pFid = empty($p['fid']) ? Tool_Fnc::ajaxMsg('食物ID不能为空') : intval($p['fid']); $pUnit = empty($p['unit']) ? Tool_Fnc::ajaxMsg('单位不能为空') : Tool_Fnc::safe_string($p['unit']); $pAmount = empty($p['amount']) ? Tool_Fnc::ajaxMsg('数量不能为空') : floatval($p['amount']); $pWeight = empty($p['weight']) ? Tool_Fnc::ajaxMsg('重量不能为空') : floatval($p['weight']); $pMtid = empty($p['mt_id']) ? Tool_Fnc::ajaxMsg('餐类型不能为空') : intval($p['mt_id']); $tTime = time(); $tFMO = new FoodModel(); $tFRow = $tFMO->field('title,protein,thumb_img,tag,count')->where('id = ' . $pFid)->fRow(); if (!count($tFRow)) { Tool_Fnc::ajaxMsg('食物不存在'); } $tMTMO = new MealtypeModel(); $tMTRow = $tMTMO->field('name')->where('id = ' . $pMtid)->fRow(); if (!count($tMTRow)) { Tool_Fnc::ajaxMsg('餐类型不存在'); } $tRFDMO = new R_FoodaddModel(); $tData = array('title' => $tFRow['title'], 'unit' => $pUnit, 'amount' => $pAmount, 'weight' => $pWeight, 'mt_id' => $pMtid, 'mt_name' => $tMTRow['name'], 'created' => $tTime, 'fid' => $pFid, 'uid' => $this->tUid, 'thumb_img' => $tFRow['thumb_img'], 'tag' => $tFRow['tag'], 'protein' => $tFRow['protein'] / 100 * $pWeight); if (!$tRFDMO->insert($tData)) { Tool_Fnc::ajaxMsg('添加失败'); } //食物被添加的次数加一 $tDRDatas = array('id' => $pFid, 'count' => $tFRow['count'] + 1, 'updated' => $tTime); $tFMO->update($tDRDatas); Tool_Fnc::ajaxMsg('添加成功', 1); }
public function editAction() { $p = $_REQUEST; $pId = empty($p['id']) ? die('ID不能为空') : intval($p['id']); $tMO = new FoodModel(); $tCateRow = $tMO->where('id = ' . $pId)->fRow(); $this->assign('tId', $pId); $this->assign('tCateRow', $tCateRow); $tFT = new FoodtagModel(); $tTagList = $tFT->field('id,concat(title,\'_tag\') title,fid,flag')->where('fid = ' . $pId)->fList(); foreach ($tTagList as $v) { if (is_array($v)) { foreach ($v as $k => $v1) { if ($k == 'title' || $k == 'flag') { if ($k == 'title') { $t1 = $v1; } elseif ($k == 'flag') { $t2 = $v1; } } } $tTagRow[$t1] = $t2; } } $this->assign('tTagRow', isset($tTagRow) ? $tTagRow : null); $tTP = new FoodcategoryModel(); $pType = $tTP->field('id,title')->fList(); $this->assign('pType', $pType); if ($_SERVER['REQUEST_METHOD'] == "POST") { $pPhoto = isset($_FILES['photo']) ? $_FILES['photo'] : null; if ($pPhoto) { $subPath = date("Ymd", time()); $tUpload = new Tool_Upload($pPhoto, APPLICATION_PATH . '/public/upload/food/' . $subPath . '/'); $tSavename = $tUpload->getSaveName(); $tRes = $tUpload->upload($tSavename); $tExt = $tUpload->extension; if ($tRes == 1) { $tUpload->createThumb('300', '300', APPLICATION_PATH . '/public/upload/food/' . $subPath . '_small/'); $tSFile = '/upload/food/' . $subPath . '_small/' . $tSavename . '.' . $tExt; $tFile = '/upload/food/' . $subPath . '/' . $tSavename . '.' . $tExt; } else { Tool_Fnc::ajaxMsg('图片上传失败'); die; } } $pTitle = empty($p['title']) ? Tool_Fnc::ajaxMsg('食物名称不能为空') : Tool_Fnc::safe_string($p['title']); $pProtein = empty($p['protein']) ? Tool_Fnc::ajaxMsg('蛋白质不能为空') : floatval($p['protein']); $pCalory = !isset($p['calory']) ? '' : floatval($p['calory']); $pFat = !isset($p['fat']) ? '' : floatval($p['fat']); $pCarbohydrate = !isset($p['carbohydrate']) ? '' : floatval($p['carbohydrate']); $pFiber = !isset($p['fiber_dietary']) ? '' : floatval($p['fiber_dietary']); $pCalcium = !isset($p['calcium']) ? '' : floatval($p['calcium']); $pZinc = !isset($p['zinc']) ? '' : floatval($p['zinc']); $pVitamin_a = !isset($p['vitamin_a']) ? '' : floatval($p['vitamin_a']); $pVitamin_c = !isset($p['vitamin_c']) ? '' : floatval($p['vitamin_c']); $pMagnesium = !isset($p['magnesium']) ? '' : floatval($p['magnesium']); $pSelenium = !isset($p['selenium']) ? '' : floatval($p['selenium']); $pCopper = !isset($p['copper']) ? '' : floatval($p['copper']); $pPhosphor = !isset($p['phosphor']) ? '' : floatval($p['phosphor']); $pNiacin = !isset($p['niacin']) ? '' : floatval($p['niacin']); $pVitamin_e = !isset($p['vitamin_e']) ? '' : floatval($p['vitamin_e']); $pManganese = !isset($p['manganese']) ? '' : floatval($p['manganese']); $pCholesterol = !isset($p['cholesterol']) ? '' : floatval($p['cholesterol']); $pIron = !isset($p['iron']) ? '' : floatval($p['iron']); $pKalium = !isset($p['kalium']) ? '' : floatval($p['kalium']); $pNatrium = !isset($p['natrium']) ? '' : floatval($p['natrium']); $pThiamine = !isset($p['thiamine']) ? '' : floatval($p['thiamine']); $pLactoflavin = !isset($p['lactoflavin']) ? '' : floatval($p['lactoflavin']); $pCarotene = !isset($p['carotene']) ? '' : floatval($p['carotene']); $pTag = array(); empty($p['calory_tag']) ? '' : ($pTag['calory'] = Tool_Fnc::safe_string($p['calory_tag'])); empty($p['protein_tag']) ? '' : ($pTag['protein'] = Tool_Fnc::safe_string($p['protein_tag'])); empty($p['fat_tag']) ? '' : ($pTag['fat'] = Tool_Fnc::safe_string($p['fat_tag'])); empty($p['carbohydrate_tag']) ? '' : ($pTag['carbohydrate'] = Tool_Fnc::safe_string($p['carbohydrate_tag'])); empty($p['fiber_dietary_tag']) ? '' : ($pTag['fiber_dietary'] = Tool_Fnc::safe_string($p['fiber_dietary_tag'])); $pTags = empty($pTag) ? '' : implode('|', $pTag); $pSuggest = $p['suggest']; $pUpdated = time(); $pCid = empty($p['c_id']) ? Tool_Fnc::ajaxMsg('食物没有分类') : floatval($p['c_id']); $tRow = $tTP->field('id,title')->where('id= \'' . $pCid . '\'')->fRow(); $tData = array('id' => $pId, 'title' => $pTitle, 'calory' => $pCalory, 'protein' => $pProtein, 'fat' => $pFat, 'carbohydrate' => $pCarbohydrate, 'fiber_dietary' => $pFiber, 'calcium' => $pCalcium, 'zinc' => $pZinc, 'vitamin_a' => $pVitamin_a, 'vitamin_c' => $pVitamin_c, 'magnesium' => $pMagnesium, 'selenium' => $pSelenium, 'copper' => $pCopper, 'phosphor' => $pPhosphor, 'niacin' => $pNiacin, 'vitamin_e' => $pVitamin_e, 'manganese' => $pManganese, 'cholesterol' => $pCholesterol, 'iron' => $pIron, 'kalium' => $pKalium, 'natrium' => $pNatrium, 'thiamine' => $pThiamine, 'lactoflavin' => $pLactoflavin, 'carotene' => $pCarotene, 'tag' => $pTags, 'updated' => $pUpdated, 'suggest' => $pSuggest, 'c_id' => $tRow['id'], 'c_title' => $tRow['title']); $tData['large_img'] = isset($tFile) ? $tFile : $p['large_img']; $tData['thumb_img'] = isset($tSFile) ? $tSFile : $p['thumb_img']; $tFF = new FoodtagModel(); if ($tMO->update($tData)) { $tFF->where(' fid =' . $pId)->del(); foreach ($pTag as $k => $v) { $values['title'] = $k; $values['fid'] = $pId; $values['flag'] = $v; $tFF->insert($values); } Tool_Fnc::ajaxMsg('修改成功', 1); } else { Tool_Fnc::ajaxMsg('修改失败'); } } }