/** * 根据idlist获取产品农药或者化肥使用的详细信息 * @param $idList 信息的id列表 * @param type 0:化肥,1:农药 * @return 返回使用列表,同时返回总数 */ public function getProductFerOrPesByIdList($idList, $pageNum = 1, $pageSize = 10) { $res = array(); if (!empty($idList)) { $dao = new DaoProductFerPes(); $res['Item'] = $dao->getFerOrPesListByIdList($idList, $pageNum, $pageSize); $res['Total'] = $dao->getFerOrPesCountByIdList($idList); } return $res; }
/** * 保存农药肥料使用表 */ private function saveFerPesUse($fertilizer, $pesticides, $conn) { $res = array("result" => true); if (empty($fertilizer)) { $res['ferIdList'] = ""; } else { //肥料 //use_timelist 使用时间列表(#隔开) //use_namelist 使用化肥或农药名称列表(#隔开) //use_levellist 用量(#隔开) //use_brandlist 品牌列表(#隔开)use_typelist //use_supplierslist 供应商列表(#隔开) //use_typelist 类型列表(|隔开) $use_timelist = split("#", $fertilizer['use_timelist']); $use_namelist = split("#", $fertilizer['use_namelist']); $use_levellist = split("#", $fertilizer['use_levellist']); $use_brandlist = split("#", $fertilizer['use_brandlist']); $use_supplierslist = split("#", $fertilizer['use_supplierslist']); $use_typelist = split("#", $fertilizer['use_typelist']); $ferIdList = ""; $dao = new DaoProductFerPes(); //TODO 测试是否能够判断四个长度相等 if (count($use_timelist) & count($use_namelist) & count($use_levellist) & count($use_brandlist) & count($use_supplierslist) & count($use_typelist)) { for ($i = 0, $len = count($use_timelist); $i < $len; $i++) { $data = array("use_time" => $use_timelist[$i], "use_name" => $use_namelist[$i], "use_level" => $use_levellist[$i], "use_brand" => $use_brandlist[$i], "use_suppliers" => $use_supplierslist[$i], "use_type" => $use_typelist[$i]); $result = $dao->insertTransaction($data, $conn); if ($result) { $ferIdList .= $dao->_getLastId($conn) . ","; } else { $res['result'] = false; return $res; } } } else { $res['result'] = false; return $res; } if (count($ferIdList) > 0) { $res['ferIdList'] = substr($ferIdList, 0, -1); } } if (empty($pesticides)) { $res['pesIdList'] = ""; } else { //农药 //use_timelist 使用时间列表(#隔开) //use_namelist 使用化肥或农药名称列表(#隔开) //use_levellist 用量(#隔开) //use_brandlist 品牌列表(#隔开) //use_supplierslist 供应商列表(#隔开) $use_timelist = split("#", $pesticides['use_timelist']); $use_namelist = split("#", $pesticides['use_namelist']); $use_levellist = split("#", $pesticides['use_levellist']); $use_brandlist = split("#", $pesticides['use_brandlist']); $use_supplierslist = split("#", $pesticides['use_supplierslist']); $pesIdList = ""; $dao = new DaoProductFerPes(); // 测试是否能够判断四个长度相等 if (count($use_timelist) & count($use_namelist) & count($use_levellist) & count($use_brandlist) & count($use_supplierslist) & count($use_typelist)) { for ($i = 0, $len = count($use_timelist); $i < $len; $i++) { $data = array("use_time" => $use_timelist[$i], "use_name" => $use_namelist[$i], "use_level" => $use_levellist[$i], "use_brand" => $use_brandlist[$i], "use_suppliers" => $use_supplierslist[$i], "use_type" => ""); $result = $dao->insertTransaction($data, $conn); if ($result) { $pesIdList .= $dao->_getLastId($conn) . ","; } else { $res['result'] = false; return $res; } } } else { $res['result'] = false; return $res; } if (count($pesIdList) > 0) { $res['pesIdList'] = substr($pesIdList, 0, -1); } } return $res; }