/**
* 新增产品信息
* 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;
}
/**
* 发布批次
* @param 产品id $productID
* @param 批次信息 $batch
* 1. 判断产品状态是否为已通过，只有审核通过的产品才能发布批次
* 2. 创建产品批次信息
* 3. 更新product表中的Batchlist字段
*/
public function addProductBatch($productID, $batch)
{
$result = false;
$daoProduct = new DaoProduct();
$products = $daoProduct->getProductByproductId($productID);
$daoProductBasicinfo = new DaoProductBasicinfo();
$basicinfo = $daoProductBasicinfo->getProductBasicinfoByproductId($productID);
$product = array();
if (count($products) != 1 || count($basicinfo) != 1) {
return $result;
} else {
$product = $products[0];
}
//判断产品状态是否合格
if ($basicinfo[0]['basicinfo_status'] != 3) {
return $result;
}
$conn = DaoBase::_getConn();
mysql_query("BEGIN");
//或者mysql_query("START TRANSACTION");
$batchResult = false;
$productResult = false;
$data = array("batch_harvesttime" => Tools::getNowTime(), "batch_num" => Tools::getFileName(), "batch_auditstatus" => 1, "batch_isvalid" => 1, "batch_isdelete" => 0, "batch_remark_color" => $batch['color'], "batch_remark_power" => $batch['power'], "batch_remark_weight" => $batch['weight'], "batch_remark_SugarScale" => $batch['sugar'], "batch_remark_other" => $batch['other'], "batch_qrcode_loc" => $batch['batch_qrcode_loc']);
$batchDAO = new DaoProductBatch();
$batchResult = $batchDAO->insertTransaction($data, $conn);
if ($batchResult) {
$batchID = $batchDAO->_getLastId($conn);
//更新product表
$batchlist = $product['batchlist'];
if (!empty($batchlist)) {
$batchlist .= "," . $batchID;
} else {
$batchlist = $batchID;
}
$dao = new DaoProduct();
$productResult = $dao->updateTransaction($conn, array("batchlist" => $batchlist), array("product_id = " => $productID));
}
$result = $batchResult && $productResult;
if ($result) {
mysql_query("COMMIT");
} else {
mysql_query("ROLLBACK");
}
DaoBase::_closeConn($conn);
return $result;
}
