/**
* 根据商家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;
}
