/** * 根据商家id分页获取该商家的产品的列表 * @param unknown $vendorId */ public function getProBasicinfoByVendorIdPage($vendorId, $pageNum, $pageSize) { $res = array(); if (!empty($vendorId)) { //获取产品id地址 $dao = new DaoProduct(); $productIdList = $dao->getProductIdListByVendorId($vendorId); if (!empty($productIdList) && count($productIdList) > 0) { //根据产品id获取详细的产品基本信息 $IdString = "("; foreach ($productIdList as $value) { $IdString .= $value['product_id'] . ","; } $IdString = substr($IdString, 0, -1) . ")"; $daoProductBasicinfo = new DaoProductBasicinfo(); $res = $daoProductBasicinfo->getProductBasicinfoByproductIdStringPage($IdString, $pageNum, $pageSize); } } return $res; }
/** * */ public function getAllVendorInfo($vendorId) { $res = array(); // 根据id获取商家信息 $dao = new DaoVendor(); $vendors = $dao->getVendorById($vendorId); if (count($vendors) == 1) { $vendor = $vendors[0]; //获取法人验证信息id $idenId = $vendor['vendor_iden_id']; if ($idenId != null) { $daoVendorAuth = new DaoVendorAuth(); $res['iden'] = $daoVendorAuth->getVendorAuthById($idenId); } //获取公司验证信息id $certiId = $vendor['vendor_certi_id']; if ($certiId != null) { $daoVendorAuth = new DaoVendorAuth(); $res['certi'] = $daoVendorAuth->getVendorAuthById($certiId); } //获取公司信息id $info_id = $vendor['vendor_info_id']; if ($info_id) { $dao = new DaoVendorInfo(); $res['info'] = $dao->getVendorInfoById($info_id); } //获取产品总数 $dao = new DaoProduct(); $res['productSum'] = $dao->getCountProductByVendorId($vendorId); } return $res; }
/** * 新增产品信息 * 1、保存产品基本信息basicinfo * 2、保存生长周期图片product_growimages * 3、保存肥料,农药使用表fertilizer_pesticides_use * 4、产品认证 product_certi * 5、购买信息 product_buyinfo * 6、保存product表 * @param 产品的记录 $record * 这个函数负责产品认证信息 */ public function addProductRecord($record) { $result = false; //新建一个连接 $conn = DaoBase::_getConn(); mysql_query("BEGIN"); //或者mysql_query("START TRANSACTION"); //新建一个产品 $productDAO = new DaoProduct(); $product = array("product_intro" => $record['product_intro']); $isRight = false; $isUpdate = false; $productID = null; if (empty($record['product_id'])) { $productResult = $productDAO->insertTransaction($product, $conn); if ($productResult) { $productID = $productDAO->_getLastId($conn); $isRight = true; } } else { $productID = $record['product_id']; $isRight = true; $isUpdate = true; } if ($isRight) { //更新product_basicinfo表 $record['basicinfo']['product_id'] = $productID; $resBasicinfo = $this->saveBasicinfo($record['basicinfo'], $conn); //更新product_growimages表 $resGrowimages = $this->saveGrowimages($record['growimages'], $conn); if ($resGrowimages['result']) { $product['growthing_img_list'] = $resGrowimages['idList']; } //更新fertilizer_pesticides_use表 fertilizer 肥料,pesticides 农药 $resFerPesUse = $this->saveFerPesUse($record['fertilizer'], $record['pesticides'], $conn); if ($resFerPesUse['result']) { $product['fertilizer_list'] = $resFerPesUse['ferIdList']; $product['pesticides_list'] = $resFerPesUse['pesIdList']; } //更新产品认证表 product_certi $resCerti = $this->saveProCerti($record['certi'], $conn); if ($resCerti['result']) { $product['product_certi_list'] = $resCerti['certiIdList']; } //更新产品购买信息表 product_buyinfo $resBuyInfo = $this->saveProBuyinfo($record['buyinfo'], $conn); if ($resBuyInfo['result']) { $product['buy_info_list'] = $resBuyInfo['buyinfoIdList']; } $resultAll = $resBasicinfo['result'] && $resGrowimages['result'] && $resFerPesUse['result'] && $resCerti['result'] && $resBuyInfo['result']; if ($resultAll) { if ($isUpdate) { $data = array("growthing_img_list" => $product['growthing_img_list'], "fertilizer_list" => $product['fertilizer_list'], "pesticides_list" => $product['pesticides_list'], "product_certi_list" => $product['product_certi_list'], "product_intro" => $product['product_intro'], "buy_info_list" => $product['buy_info_list']); $daoProduct = new DaoProduct(); $result = $daoProduct->updateTransaction($conn, $data, array("product_id =" => $productID)); } else { //获取商家id $vendor = User::_getVendor(); //生成二维码 $url = "http://www.baidu.com"; $product['qrcodeloc'] = ""; $product['qrcodeloc'] = Tools::createQRcode($url); if (!empty($vendor)) { $product['vendor_id'] = $vendor['vendor_id']; //更新产品信息 $data = array("vendor_id" => $product['vendor_id'], "growthing_img_list" => $product['growthing_img_list'], "fertilizer_list" => $product['fertilizer_list'], "pesticides_list" => $product['pesticides_list'], "video_loc" => "", "environment_data_exist" => 0, "product_certi_list" => $product['product_certi_list'], "product_intro" => $product['product_intro'], "buy_info_list" => $product['buy_info_list'], "batchlist" => "", "qrcodeloc" => $product['qrcodeloc'], "product_isdelete" => 0); $daoProduct = new DaoProduct(); $result = $daoProduct->updateTransaction($conn, $data, array("product_id =" => $productID)); } } } } if ($result) { mysql_query("COMMIT"); } else { mysql_query("ROLLBACK"); } DaoBase::_closeConn($conn); return $result; }
/** * 根据产品id获取产品的批次信息列表 * @param 产品id $productID * 1. 根据产品id获取product信息,取出batchlist * 2. 根据Batchlist获取批次信息列表 */ public function getProductBatchList($productID) { $res = array(); $dao = new DaoProduct(); $product = $dao->getProductByproductId($productID); if ($product && count($product) == 1) { $batchlist = $product[0]['batchlist']; if (!empty($batchlist)) { $daoProductBatch = new DaoProductBatch(); $res = $daoProductBatch->getBatchListByIdList($batchlist); } } return $res; }