<?php
namespace app\abutment\controller;
use app\admin\model\ActionLog;
use app\admin\model\ChangeLog;
use app\admin\model\ProcessOrder;
use app\youzan\model\PlatformYouzan;
use think\facade\Db;
//商品模块
class Good extends HomeBaseController
{
private $gold = [1 => '18K', 2 => '24K', 3 => '白银'];
//获取商品列表
public function list()
{
$this->post = $this->request->filter('trim')->post();
$page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
$size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
$where = [["gb.is_del", "=", 0], ['gb.is_stock', '=', 0]];
$condit = [["a.is_del", "=", 0]];
$cat_id = isset($this->post['cat_id']) && $this->post['cat_id'] !== "" ? intval($this->post['cat_id']) : "";
if ($cat_id !== "") {
$cat_ids = catChild($cat_id);
$where[] = ['gb.cat_id', "in", $cat_ids];
$condit[] = ['a.cat_id', "in", $cat_ids];
}
$good_name = isset($this->post['good_name']) && $this->post['good_name'] !== "" ? trim($this->post['good_name']) : "";
if ($good_name !== "") {
$where[] = ['gb.good_name', "like", "%$good_name%"];
$condit[] = ['a.good_name', "like", "%$good_name%"];
}
$spucode = isset($this->post['spucode']) && $this->post['spucode'] !== "" ? trim($this->post['spucode']) : "";
if ($spucode !== "") {
$where[] = ['gb.spuCode', "like", "%$spucode%"];
$condit[] = ['a.spuCode', "like", "%$spucode%"];
}
$good_type = isset($this->post['good_type']) && $this->post['good_type'] !== "" ? trim($this->post['good_type']) : "";
if ($good_type !== "") {
$where[] = ['gb.good_type', "=", $good_type];
$condit[] = ['a.good_type', "=", $good_type];
}
$companyNo = isset($this->post['companyNo']) && $this->post['companyNo'] !== "" ? trim($this->post['companyNo']) : "";
if ($companyNo !== "") {
$where[] = ['gb.companyNo', "like", "%$companyNo%"];
$condit[] = ['a.companyNo', "like", "%$companyNo%"];
}
$supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] !== "" ? trim($this->post['supplierNo']) : "";
if ($supplierNo !== "") {
$where[] = ['gb.supplierNo', "like", "%$supplierNo%"];
$condit[] = ['a.supplierNo', "like", "%$supplierNo%"];
}
$supplier = isset($this->post['supplier']) && $this->post['supplier'] !== "" ? trim($this->post['supplier']) : "";
if ($supplier !== "") {
$suppliernos = Db::name("supplier")->where([["name", "like", "%$supplier%"]])->column("code");
$where[] = ['gb.supplierNo', "in", $suppliernos];
$condit[] = ['a.supplierNo', "in", $suppliernos];
}
$company = isset($this->post['company']) && $this->post['company'] !== "" ? trim($this->post['company']) : "";
if ($company !== "") {
$companyNos = Db::name("business")->where([["company", "like", "%$company%"]])->column("companyNo");
$where[] = ['gb.companyNo', "in", $companyNos];
$condit[] = ['a.companyNo', "in", $companyNos];
}
$brandid = isset($this->post['brandid']) && $this->post['brandid'] !== "" ? intval($this->post['brandid']) : "";
if ($brandid !== "") {
$where[] = ['gb.brand_id', "=", $brandid];
$condit[] = ['a.brand_id', "=", $brandid];
}
$status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
if ($status !== "") {
$where[] = ['gb.status', "=", $status];
$condit[] = ['a.status', "=", $status];
}
// $is_stock = isset($this->post['is_stock']) && $this->post['is_stock'] !== "" ? intval($this->post['is_stock']) : '';
// if ($is_stock !== '') {
// $where[] = ['gb.is_stock', "=", $is_stock];
// }
$start = isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start'] : "";
if ($start !== "") {
$where[] = ['gb.addtime', ">=", date('Y-m-d H:i:s', strtotime($start))];
$condit[] = ['a.addtime', ">=", date('Y-m-d H:i:s', strtotime($start))];
}
$end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] : "";
if ($end !== "") {
$where[] = ['gb.addtime', "<", date('Y-m-d H:i:s', strtotime($end) + 24 * 3600)];
$condit[] = ['a.addtime', "<", date('Y-m-d H:i:s', strtotime($end) + 24 * 3600)];
}
$isonline = isset($this->post['isonline']) && $this->post['isonline'] !== "" ? $this->post['isonline'] : "";
if ($isonline !== "") {
$condit[] = ['b.exam_status', "=", 6];
// if($isonline==1){
// $condit[] =['b.exam_status',"=",6];
// }else{
// $condit[] =['b.exam_status',"<>",6];
// }
$sta = Db::name("good_basic")
->alias("a")
->leftJoin("good_platform b", "a.spuCode=b.spuCode")
->where($condit)
->group("a.spuCode")
->column('a.spuCode');
if ($isonline == 1) $where[] = ["gb.spuCode", "in", $sta];
else $where[] = ["gb.spuCode", "not in", $sta];
}
// $token = isset($this->post['token']) ? trim($this->post['token']) : "";
// if($token==""){
// return json_show(101,'token不能为空');
// }
// $apply_id =GetUserInfo($token);
// if(empty($apply_id)||$apply_id['code']!=0){
// return json_show(102,"申请人数据不存在");
// }
// $rm = $this->request->user['uid'];//isset($apply_id["data"]['id']) ? $apply_id["data"]['id'] : "";
// $where[] = ['gb.createrid', "=", $rm];
$where[] = ['gb.supplierNo', "=", $this->request->user['supplierNo']];
// if($rm!=''){
// $useinfo = Db::name("user_role")->where(['uid'=>$rm,"status"=>1,"is_del"=>0])->find();
// if($useinfo==false){
// return json_show(1002,"未找到用户角色权限");
// }
// $check = checkRole($useinfo['roleid'],115);
// if($check){
// $where[]=['gb.createrid', "=" ,$rm];
// }
// }
// $role=$this->checkRole();
// if(!empty($role['write'])){
// $where[]=["gb.createrid","in",$role['write']];
// }
$company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
if ($company_name !== "") $where[] = ["gb.createrid", 'in', get_company_item_user_by_name($company_name)];
$count = Db::name('good_basic')->alias('gb')->where($where)->count();
$total = ceil($count / $size);
$page = $page >= $total ? $total : $page;
$list = Db::name('good_basic')
->alias('gb')
->where($where)
->page($page, $size)
->order("addtime desc")
->select()
->toArray();
$all_createrid = array_column($list,'chargerid');
$item = get_company_name_by_uid($all_createrid);
$data = [];
//查询一下这些spucode是否在平台上成功上线
$exam_statuss = Db::name('good_platform')
->whereIn('spuCode', array_column($list, 'spuCode'))
->where(['is_del' => 0, 'exam_status' => 3])//exam_status==3表示上线审核成功
->column('id', 'spuCode');
$exam_status_yz = Db::name('platform_youzan')
->whereIn('spuCode', array_column($list, 'spuCode'))
->where(['is_del' => 0, 'exam_status' =>6])//exam_status==6表示上线审核成功
->column('id', 'spuCode');
foreach ($list as $value) {
$value["cat_info"] = made($value['cat_id'], []);
$brand = Db::name("brand")->where(["id" => $value['brand_id']])->find();
$value["brand_name"] = isset($brand['brand_name']) ? $brand['brand_name'] : "";
$unit = Db::name("unit")->where(["id" => $value['good_unit']])->find();
$value['unit'] = isset($unit['unit']) ? $unit['unit'] : "";
$company = Db::name("business")->where(["companyNo" => $value['companyNo']])->find();
$value['company'] = isset($company['company']) ? $company['company'] : "";
$supplier = Db::name("supplier")->where(['code' => $value['supplierNo']])->find();
$value['supplier_name'] = isset($supplier['name']) ? $supplier['name'] : "";
$value['exclusive'] = makeExcluse($value['is_exclusive']);
$value['noble_name'] = isset($value['noble_metal']) && $value['noble_metal'] != 0 ? $this->noble[$value['noble_metal']] : "";
//如果一个spucode在任意平台上线，那么就视为它上线，即手动把它的is_online值改为1
if (isset($exam_statuss[$value['spuCode']]) || isset($exam_status_yz[$value['spuCode']])) $value['is_online'] = 1;
$value['charger_company_name'] = $item[$value['chargerid']]??'';
$data[] = $value;
}
return json_show(0, "获取成功", ['list' => $data, 'count' => $count]);
}
//创建商品
public function createGood()
{
$this->post = $this->request->filter('trim')->post();
$good_name = isset($this->post['good_name']) && $this->post['good_name'] != "" ? trim($this->post['good_name']) : "";
if ($good_name == "") {
return json_show(1004, "商品名称不能为空");
}
$cat_id = isset($this->post['cat_id']) && $this->post['cat_id'] != "" ? intval($this->post['cat_id']) : "";
if ($cat_id == '') {
return json_show(1004, "商品分类不能为空");
}
//不允许创建贵金属商品
$top_cat_id = made($cat_id);//获取所有分类
$top_cat_id = isset($top_cat_id[0]['id']) ? $top_cat_id[0]['id'] : 0;//获取顶级分类id
if($top_cat_id && $top_cat_id==6) return json_show(1004,'不允许创建贵金属商品');
$brandid = isset($this->post['brandid']) && $this->post['brandid'] != "" ? intval($this->post['brandid']) : "";
if ($brandid == '') {
return json_show(1004, "商品品牌不能为空");
}
$unit = isset($this->post['unit']) && $this->post['unit'] != "" ? trim($this->post['unit']) : "";
if ($unit == '') {
return json_show(1004, "商品单位不能为空");
}
$good_type = isset($this->post['good_type']) && $this->post['good_type'] !== "" ? intval($this->post['good_type']) : "";
if ($good_type === '') {
return json_show(1004, "参数good_type不能为空");
}
$moq = 0;
$customized = 0;
if ($good_type == 1) {
$moq = isset($this->post['moq']) && $this->post['moq'] !== "" ? intval($this->post['moq']) : "";
if ($moq === '') {
return json_show(1004, "定制商品起订量不能为空");
}
$customized = isset($this->post['customized']) && $this->post['customized'] !== "" ? intval($this->post['customized']) : "";
if ($customized === '') {
return json_show(1004, "参数customized不能为空");
}
}
$is_exclusive = isset($this->post['is_exclusive']) && $this->post['is_exclusive'] !== "" ? intval($this->post['is_exclusive']) : "";
if ($is_exclusive === '') {
return json_show(1004, "参数is_exclusive不能为空");
}
$tax = isset($this->post['tax']) && $this->post['tax'] !== "" ? intval($this->post['tax']) : "";
if ($tax === '') {
return json_show(1004, "参数tax不能为空");
}
$supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] != "" ? trim($this->post['supplierNo']) : "";
if ($supplierNo == '') {
return json_show(1004, "参数supplierNo不能为空");
}
$good_size = isset($this->post['good_size']) && $this->post['good_size'] != "" ? trim($this->post['good_size']) : "";
if ($good_size == '') {
return json_show(1004, "参数good_size不能为空");
}
$company_id = isset($this->post['company_id']) && $this->post['company_id'] != "" ? trim($this->post['company_id']) : "";
if ($company_id == '') {
return json_show(1004, "参数company_id不能为空");
}
$is_auth = isset($this->post['is_auth']) && $this->post['is_auth'] !== "" ? intval($this->post['is_auth']) : "";
if ($is_auth === '') {
return json_show(1004, "参数is_auth不能为空");
}
$auth_img = isset($this->post['auth_img']) && $this->post['auth_img'] != "" ? trim($this->post['auth_img']) : "";
// if($auth_img==''){
// return json_show(1004,"商品不能为空");
// }
$after_sales = isset($this->post['after_sales']) && $this->post['after_sales'] != "" ? trim($this->post['after_sales']) : "";
if ($after_sales == "") {
return json_show(1004, "参数after_sales不能为空");
}
$craft_desc = isset($this->post['craft_desc']) && $this->post['craft_desc'] != "" ? trim($this->post['craft_desc']) : "";
$good_remark = isset($this->post['good_remark']) && $this->post['good_remark'] != "" ? trim($this->post['good_remark']) : "";
if ($good_remark === "") {
return json_show(1004, "参数good_remark不能为空");
}
$weight = isset($this->post['weight']) && $this->post['weight'] !== "" ? floatval($this->post['weight']) : "";
if ($weight === "") {
return json_show(1004, "参数weight不能为空");
}
$packing_way = isset($this->post['packing_way']) && $this->post['packing_way'] !== "" ? trim($this->post['packing_way']) : "";
if ($packing_way === "") {
return json_show(1004, "参数packing_way不能为空");
}
$packing_size = isset($this->post['packing_size']) && $this->post['packing_size'] !== "" ? trim($this->post['packing_size']) : "";
if ($packing_size === "") {
return json_show(1004, "参数packing_size不能为空");
}
$packing_spec = isset($this->post['packing_spec']) && $this->post['packing_spec'] !== "" ? trim($this->post['packing_spec']) : "";
if ($packing_spec === "") {
return json_show(1004, "参数packing_spec不能为空");
}
$packing_weight = isset($this->post['packing_weight']) && $this->post['packing_weight'] !== "" ? floatval($this->post['packing_weight']) : "";
if ($packing_weight === "") {
return json_show(1004, "参数packing_weight不能为空");
}
$packing_list = isset($this->post['packing_list']) && $this->post['packing_list'] !== "" ? trim($this->post['packing_list']) : "";
if ($packing_list === "") {
return json_show(1004, "参数packing_list不能为空");
}
$good_bar = isset($this->post['good_bar']) && $this->post['good_bar'] !== "" ? trim($this->post['good_bar']) : "";
$supply_area = isset($this->post['supply_area']) && $this->post['supply_area'] !== "" ? intval($this->post['supply_area']) : "";
if ($supply_area === "") {
return json_show(1004, "参数supply_area不能为空");
}
$delivery_place = isset($this->post['delivery_place']) && $this->post['delivery_place'] !== "" ? trim($this->post['delivery_place']) : "";
if ($delivery_place === "") {
return json_show(1004, "参数delivery_place不能为空");
}
$origin_place = isset($this->post['origin_place']) && $this->post['origin_place'] !== "" ? trim($this->post['origin_place']) : "";
if ($origin_place === "") {
return json_show(1004, "参数origin_place不能为空");
}
$delivery_day = isset($this->post['delivery_day']) && $this->post['delivery_day'] !== "" ? intval($this->post['delivery_day']) : "";
if ($delivery_day === "") {
return json_show(1004, "参数delivery_day不能为空");
}
$lead_time = isset($this->post['lead_time']) && $this->post['lead_time'] !== "" ? intval($this->post['lead_time']) : "0";
$cgd_gold_price = isset($this->post['cgd_gold_price']) && $this->post['cgd_gold_price'] !== "" ? floatval($this->post['cgd_gold_price']) : "0";
// if($lead_time===""){
// return json_show(1004,"参数lead_time不能为空");
// }
$sample_day = isset($this->post['sample_day']) && $this->post['sample_day'] !== "" ? intval($this->post['sample_day']) : "0";
// if($sample_day===""){
// return json_show(1004,"参数sample_day不能为空");
// }
$sample_fee = isset($this->post['sample_fee']) && $this->post['sample_fee'] !== "" ? floatval($this->post['sample_fee']) : "0";
$is_stock = isset($this->post['is_stock']) && $this->post['is_stock'] !== "" ? intval($this->post['is_stock']) : "";
if ($is_stock === "") {
return json_show(1004, "参数is_stock不能为空");
}
// $stock_moq=0 ;//库存品备库起订量; 如果是0 表示无限制；
$stock_moq = isset($this->post['stock_moq']) && $this->post['stock_moq'] !== "" ? intval($this->post['stock_moq']) : "0";
if ($is_stock == 1 && $stock_moq == 0) {
return json_show(1004, "库存品备库起订量不能为零");
}
$is_diff = isset($this->post['is_diff']) && $this->post['is_diff'] !== "" ? intval($this->post['is_diff']) : "0";
$good_img = isset($this->post['good_img']) && $this->post['good_img'] != "" ? trim($this->post['good_img']) : "";
$config = isset($this->post['config']) && $this->post['config'] !== "" ? trim($this->post['config']) : "";
$other_config = isset($this->post['other_config']) && $this->post['other_config'] !== "" ? trim($this->post['other_config']) : "";
if ($good_img === "") {
return json_show(1004, "参数good_img不能为空");
}
$good_thumb_img = isset($this->post['good_thumb_img']) && $this->post['good_thumb_img'] !== "" ? trim($this->post['good_thumb_img']) : "";
if ($good_thumb_img === "") {
return json_show(1004, "参数good_thumb_img不能为空");
}
$good_info_img = isset($this->post['good_info_img']) && $this->post['good_info_img'] != "" ? trim($this->post['good_info_img']) : "";
if ($good_info_img === "") {
return json_show(1004, "参数good_info_img不能为空");
}
$cert_fee = isset($this->post['cert_fee']) && $this->post['cert_fee'] !== "" ? floatval($this->post['cert_fee']) : "0";
$packing_fee = isset($this->post['packing_fee']) && $this->post['packing_fee'] !== "" ? floatval($this->post['packing_fee']) : "0";
$cost_fee = isset($this->post['cost_fee']) && $this->post['cost_fee'] !== "" ? floatval($this->post['cost_fee']) : "0";
$mark_fee = isset($this->post['mark_fee']) && $this->post['mark_fee'] !== "" ? floatval($this->post['mark_fee']) : "0";
$demo_fee = isset($this->post['demo_fee']) && $this->post['demo_fee'] !== "" ? floatval($this->post['demo_fee']) : "0";
$open_fee = isset($this->post['open_fee']) && $this->post['open_fee'] !== "" ? floatval($this->post['open_fee']) : "0";
$noble_metal = isset($this->post['noble_metal']) && $this->post['noble_metal'] !== "" ? intval($this->post['noble_metal']) : "0";
$noble_weight = isset($this->post['noble_weight']) && $this->post['noble_weight'] !== "" ? floatval($this->post['noble_weight']) : "0";
$is_gold_price = isset($this->post['is_gold_price']) && $this->post['is_gold_price'] !== "" ? intval($this->post['is_gold_price']) : "0";
$market_price = isset($this->post['market_price']) && $this->post['market_price'] !== "" ? floatval($this->post['market_price']) : "";
if ($market_price === "") {
return json_show(1004, "参数market_price不能为空");
}
$nake_price = isset($this->post['nake_price']) && $this->post['nake_price'] !== "" ? floatval($this->post['nake_price']) : "0";
// $is_step = isset($this->post['is_step'])&&$this->post['is_step']!==""? intval($this->post['is_step']):"";
// if($is_step===""){
// return json_show(1004,"参数is_step不能为空");
// }
$speclist = isset($this->post['speclist']) && !empty($this->post['speclist']) ? $this->post['speclist'] : "";
$good_ladder = isset($this->post['good_ladder']) && !empty($this->post['good_ladder']) ? $this->post['good_ladder'] : "";
// if($is_step==1 && $good_ladder==""){
// return json_show(1004,"启用阶梯，阶梯价不能为空");
// }
$is_support_barter = isset($this->post['is_support_barter']) && $this->post['is_support_barter'] !== "" ? intval($this->post['is_support_barter']) : 1;
// $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
// if($token==''){
// return json_show(105,"参数token不能为空");
// }
// $user =GetUserInfo($token);
// if(empty($user)||$user['code']!=0){
// return json_show(1002,"创建人数据不存在");
// }
$createrid = $this->request->user['uid']; //isset($user["data"]['id']) ? $user["data"]['id'] : "";
$creater = $this->request->user['nickname'];//isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
$spucode = makeNo("SKU");
Db::startTrans();
try {
$charger = Db::name('supplier')
->where(['code' => $this->request->user['supplierNo'], 'is_del' => 0])
->field('id,person,personid')
->findOrEmpty();
$data = [
"spuCode" => $spucode,
"good_code" => '',
"good_name" => $good_name,
"cat_id" => $cat_id,
'brand_id' => $brandid,
"good_unit" => $unit,
"good_type" => $good_type,
"moq" => $moq,
"is_exclusive" => $is_exclusive,
"customized" => $customized,
"companyNo" => $company_id,
"tax" => $tax,
"supplierNo" => $supplierNo,
"good_size" => $good_size,
"is_auth" => $is_auth,
"is_stock" => $is_stock,
"auth_img" => $auth_img,
"after_sales" => $after_sales,
"craft_desc" => $craft_desc,
"good_remark" => $good_remark,
"weight" => $weight,
"packing_way" => $packing_way,
"packing_size" => $packing_size,
"packing_spec" => $packing_spec,
"packing_list" => $packing_list,
"packing_weight" => $packing_weight,
"good_bar" => $good_bar,
"supply_area" => $supply_area,
"delivery_place" => $delivery_place,
"origin_place" => $origin_place,
"delivery_day" => $delivery_day,
"lead_time" => $lead_time,
"sample_day" => $sample_day,
"sample_fee" => $sample_fee,
"good_img" => $good_img,
"good_thumb_img" => $good_thumb_img,
"good_info_img" => $good_info_img,
"cert_fee" => $cert_fee,
"packing_fee" => $packing_fee,
"cost_fee" => $cost_fee,
"mark_fee" => $mark_fee,
"demo_fee" => $demo_fee,
"open_fee" => $open_fee,
"noble_metal" => $noble_metal,
"cgd_gold_price" => $cgd_gold_price,
"noble_weight" => $noble_weight,
"is_gold_price" => $is_gold_price,
"market_price" => $market_price,
"nake_price" => $nake_price,
"is_diff" => $is_diff,
"config" => $config,
"other_config" => $other_config,
"field_change" => '',
"is_step" => count($good_ladder) > 1 ? 1 : 0,//如果阶梯价个数大于1，说明启用阶梯价
"is_online" => 0,
"stock_moq" => $stock_moq,
"status" => 0,
"createrid" => $createrid,
"creater" => $creater,
"addtime" => date("Y-m-d H:i:s"),
"updatetime" => date("Y-m-d H:i:s"),
'is_support_barter' => $is_support_barter,
'chargerid' => $charger['personid'] ?? 0,
'charger' => $charger['person'] ?? '',//负责人，取所属供应商的创建人
];
$in = Db::name("good_basic")->insertGetId($data);
if ($in) {
if ($speclist !== "" && !empty($speclist)) {
$temp = [];
foreach ($speclist as $value) {
$lemp = [];
$lemp['spuCode'] = $spucode;
$lemp['spec_id'] = $value['spec_id'];
$lemp['spec_value_id'] = $value['spec_value_id'];
$lemp['addtime'] = date("Y-m-d H:i:s");
$lemp['updatetime'] = date("Y-m-d H:i:s");
$temp[] = $lemp;
}
$count = Db::name("good_spec")->insertAll($temp);
if ($count == 0) {
Db::rollback();
return json_show(1004, "商品规格值创建失败");
}
}
// $catinfo = Db::name("cat")->where(["id" => $cat_id])->find();
// $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate'] / 100 : 0;
if ($good_ladder !== "" && !empty($good_ladder)) {
$temp = [];
foreach ($good_ladder as $value) {
$lemp = [];
$lemp['spuCode'] = $spucode;
$lemp['min_num'] = $value['min_num'];
$lemp['nake_fee'] = $value['nake_fee'];
$lemp['cost_fee'] = $value['cost_fee'];
$lemp['delivery_fee'] = $value['delivery_fee'];
$lemp['cert_fee'] = $value['cert_fee'];
$lemp['mark_fee'] = $value['mark_fee'];
$lemp['package_fee'] = $value['package_fee'];
$lemp['other_fee'] = $value['other_fee'];
if ($is_gold_price == 1 && $top_cat_id == 6) {
//$is_gold_price==1 表示启用实时金价，cat_id==6表示贵金属
$gold = Db::name("gold_price1")->where(["type" => $noble_metal, "status" => 1, "is_del" => 0])->order("addtime desc")->find();
//$lemp['nake_total'] = $noble_weight * $gold['price'] + $value['cost_fee'] * $noble_weight + $value['mark_fee'] + $value['package_fee'] + $value['cert_fee'] + $value['nake_fee'] + $value['delivery_fee'] + $value['other_fee'];
//成本合计=贵金属重量*供应商采购金价 + 工艺费*贵金属重量+加标费+包装费+证书费+成本裸价+运费+其他费用
//成本总计启用实时金价时，采用供应商实时金价
$lemp['nake_total'] = $noble_weight * $gold['price'] + $value['cost_fee'] * $noble_weight +
$value['mark_fee'] + $value['package_fee'] + $value['cert_fee'] + $value['nake_fee'] + $value['delivery_fee'] + $value['other_fee'];
} else {
$lemp['nake_total'] = $value['nake_fee'] + $value['delivery_fee'] + $value['cert_fee'] + $value['mark_fee'] + $value['package_fee'] + $value['other_fee'];
}
$lemp['creater_id'] = $createrid;
$lemp['creater'] = $creater;
$lemp['is_del'] = 0;
$lemp['addtime'] = date("Y-m-d H:i:s");
$lemp['updatetime'] = date("Y-m-d H:i:s");
$temp[] = $lemp;
}
$count = Db::name("good_nake")->insertAll($temp);
if ($count == 0) {
Db::rollback();
return json_show(1004, "商品规格值创建失败");
}
}
//修改状态，添加待办
ActionLog::logAdd(['id' => $createrid, 'nickname' => $creater], [
"order_code" => $spucode,//咨询单详情编号
"status" => 0,//这里的status是之前的值
"action_remark" => '',//备注
"action_type" => "create"//新建create，编辑edit，更改状态status
], "SPCB", 0, $data);
ProcessOrder::AddProcess(['id' => $createrid, 'nickname' => $creater], [
"order_type" => 'SPCB',
"order_code" => $spucode,//咨询单详情编号
"order_id" => $in,
"order_status" => 0,
"before_status" => 0,
'holder_id' => $data['createrid'],
'person_id' => Db::name('supplier')->where(['code' => $this->request->user['supplierNo'], 'is_del' => 0])->value('personid'),
]);
Db::commit();
return json_show(0, "创建成功", ["spuCode" => $spucode]);
} else {
Db::rollback();
return json_show(1004, "商品创建失败");
}
} catch (\Exception $e) {
Db::rollback();
return json_show(1004, $e->getMessage());
}
}
//修改商品基础信息
public function updateGoodBasicsInfo()
{
$this->post = $this->request->filter('trim')->post();
$supcode = isset($this->post['spuCode']) && $this->post['spuCode'] != "" ? trim($this->post['spuCode']) : "";
if ($supcode == "") {
return json_show(1004, "参数spuCode不能为空");
}
$data = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->find();
if ($data == false) {
return json_show(1004, "未找到商品数据");
}
$is_down = Db::name("good_platform")->where(["spuCode" => $supcode, "is_del" => 0])->where("exam_status", "<>", 5)->find();
if ($is_down != false) {
return json_show(1004, "存在未下线商品数据");
}
if ($data['status'] != 1) return json_show(1005, '该状态下不允许修改基础信息');
$good_name = isset($this->post['good_name']) && $this->post['good_name'] != "" ? trim($this->post['good_name']) : "";
if ($good_name == "") {
return json_show(1004, "商品名称不能为空");
}
$cat_id = isset($this->post['cat_id']) && $this->post['cat_id'] != "" ? intval($this->post['cat_id']) : "";
if ($cat_id == '') {
return json_show(1004, "商品分类不能为空");
}
$brandid = isset($this->post['brandid']) && $this->post['brandid'] != "" ? intval($this->post['brandid']) : "0";
// if($brandid==''){
// return json_show(1004,"商品品牌不能为空");
// }
$unit = isset($this->post['unit']) && $this->post['unit'] != "" ? trim($this->post['unit']) : "";
if ($unit == '') {
return json_show(1004, "商品单位不能为空");
}
$good_type = isset($this->post['good_type']) && $this->post['good_type'] !== "" ? intval($this->post['good_type']) : "";
if ($good_type === '') {
return json_show(1004, "参数good_type不能为空");
}
$moq = 0;
$customized = 0;
if ($good_type == 1) {
$moq = isset($this->post['moq']) && $this->post['moq'] !== "" ? intval($this->post['moq']) : "";
if ($moq === '') {
return json_show(1004, "定制商品起订量不能为空");
}
$customized = isset($this->post['customized']) && $this->post['customized'] !== "" ? intval($this->post['customized']) : "";
if ($customized === '') {
return json_show(1004, "参数customized不能为空");
}
}
$is_exclusive = isset($this->post['is_exclusive']) && $this->post['is_exclusive'] !== "" ? intval($this->post['is_exclusive']) : "";
if ($is_exclusive === '') {
return json_show(1004, "参数is_exclusive不能为空");
}
// $customized = isset($this->post['customized'])&&$this->post['customized']!==""? intval($this->post['customized']):"";
// if($customized===''){
// return json_show(1004,"参数customized不能为空");
// }
$tax = isset($this->post['tax']) && $this->post['tax'] !== "" ? intval($this->post['tax']) : "";
if ($tax === '') {
return json_show(1004, "参数tax不能为空");
}
$supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] != "" ? trim($this->post['supplierNo']) : "";
if ($supplierNo == '') {
return json_show(1004, "参数supplierNo不能为空");
}
$good_size = isset($this->post['good_size']) && $this->post['good_size'] != "" ? trim($this->post['good_size']) : "";
if ($good_size == '') {
return json_show(1004, "参数good_size不能为空");
}
$company_id = isset($this->post['company_id']) && $this->post['company_id'] != "" ? trim($this->post['company_id']) : "";
if ($company_id == '') {
return json_show(1004, "参数company_id不能为空");
}
$is_auth = isset($this->post['is_auth']) && $this->post['is_auth'] !== "" ? intval($this->post['is_auth']) : "";
if ($is_auth === '') {
return json_show(1004, "参数is_auth不能为空");
}
$auth_img = isset($this->post['auth_img']) && $this->post['auth_img'] != "" ? trim($this->post['auth_img']) : "";
// if($auth_img==''){
// return json_show(1004,"商品不能为空");
// }
$after_sales = isset($this->post['after_sales']) && $this->post['after_sales'] != "" ? trim($this->post['after_sales']) : "";
if ($after_sales == "") {
return json_show(1004, "参数after_sales不能为空");
}
$craft_desc = isset($this->post['craft_desc']) && $this->post['craft_desc'] != "" ? trim($this->post['craft_desc']) : "";
$good_remark = isset($this->post['good_remark']) && $this->post['good_remark'] != "" ? trim($this->post['good_remark']) : "";
if ($good_remark === "") {
return json_show(1004, "参数good_remark不能为空");
}
$weight = isset($this->post['weight']) && $this->post['weight'] !== "" ? floatval($this->post['weight']) : "";
if ($weight === "") {
return json_show(1004, "参数weight不能为空");
}
$packing_way = isset($this->post['packing_way']) && $this->post['packing_way'] !== "" ? trim($this->post['packing_way']) : "";
if ($packing_way === "") {
return json_show(1004, "参数packing_way不能为空");
}
$packing_size = isset($this->post['packing_size']) && $this->post['packing_size'] !== "" ? trim($this->post['packing_size']) : "";
if ($packing_size === "") {
return json_show(1004, "参数packing_size不能为空");
}
$packing_spec = isset($this->post['packing_spec']) && $this->post['packing_spec'] !== "" ? trim($this->post['packing_spec']) : "";
if ($packing_spec === "") {
return json_show(1004, "参数packing_spec不能为空");
}
$packing_weight = isset($this->post['packing_weight']) && $this->post['packing_weight'] !== "" ? floatval($this->post['packing_weight']) : "";
if ($packing_weight === "") {
return json_show(1004, "参数packing_weight不能为空");
}
$packing_list = isset($this->post['packing_list']) && $this->post['packing_list'] !== "" ? trim($this->post['packing_list']) : "";
if ($packing_list === "") {
return json_show(1004, "参数packing_list不能为空");
}
$good_bar = isset($this->post['good_bar']) && $this->post['good_bar'] !== "" ? trim($this->post['good_bar']) : "";
$supply_area = isset($this->post['supply_area']) && $this->post['supply_area'] !== "" ? intval($this->post['supply_area']) : "";
if ($supply_area === "") {
return json_show(1004, "参数supply_area不能为空");
}
$delivery_place = isset($this->post['delivery_place']) && $this->post['delivery_place'] !== "" ? $this->post['delivery_place'] : "";
if ($delivery_place === "") {
return json_show(1004, "参数delivery_place不能为空");
}
$origin_place = isset($this->post['origin_place']) && $this->post['origin_place'] !== "" ? $this->post['origin_place'] : "";
if ($origin_place === "") {
return json_show(1004, "参数origin_place不能为空");
}
$delivery_day = isset($this->post['delivery_day']) && $this->post['delivery_day'] !== "" ? intval($this->post['delivery_day']) : "";
if ($delivery_day === "") {
return json_show(1004, "参数delivery_day不能为空");
}
$lead_time = isset($this->post['lead_time']) && $this->post['lead_time'] !== "" ? intval($this->post['lead_time']) : "0";
// if($lead_time===""){
// return json_show(1004,"参数lead_time不能为空");
// }
$sample_day = isset($this->post['sample_day']) && $this->post['sample_day'] !== "" ? intval($this->post['sample_day']) : "0";
// if($sample_day===""){
// return json_show(1004,"参数sample_day不能为空");
// }
// $sample_fee = isset($this->post['sample_fee'])&&$this->post['sample_fee']!==""? floatval
//($this->post['sample_fee']):"0";
$config = isset($this->post['config']) && $this->post['config'] !== "" ? trim($this->post['config']) : "";
$other_config = isset($this->post['other_config']) && $this->post['other_config'] !== "" ? trim($this->post['other_config']) : "";
$is_diff = isset($this->post['is_diff']) && $this->post['is_diff'] !== "" ? intval($this->post['is_diff']) : "0";
$is_stock = isset($this->post['is_stock']) && $this->post['is_stock'] !== "" ? intval($this->post['is_stock']) : "0";
$stock_moq = isset($this->post['stock_moq']) && $this->post['stock_moq'] !== "" ? intval($this->post['stock_moq']) : "0";
if ($is_stock == 1 && $stock_moq == 0) {
return json_show(1004, "库存品备库起订量不能为零");
}
$good_img = isset($this->post['good_img']) && $this->post['good_img'] != "" ? trim($this->post['good_img']) : "";
if ($good_img === "") {
return json_show(1004, "参数good_img不能为空");
}
$good_thumb_img = isset($this->post['good_thumb_img']) && $this->post['good_thumb_img'] !== "" ? trim($this->post['good_thumb_img']) : "";
if ($good_thumb_img === "") {
return json_show(1004, "参数good_thumb_img不能为空");
}
$good_info_img = isset($this->post['good_info_img']) && !empty($this->post['good_info_img']) ? trim($this->post['good_info_img']) : "";
if ($good_info_img === "") {
return json_show(1004, "参数good_info_img不能为空");
}
$count = Db::name("good_nake")->where(["spuCode" => $supcode, "is_del" => 0])->count();
$speclist = isset($this->post['speclist']) && !empty($this->post['speclist']) ? $this->post['speclist'] : "";
$uid = $this->request->user['uid'];
$nickname = $this->request->user['nickname'];
Db::startTrans();
try {
$temp = [
"good_name" => $good_name,
"cat_id" => $cat_id,
'brand_id' => $brandid,
"good_unit" => $unit,
"good_type" => $good_type,
"companyNo" => $company_id,
"moq" => $moq,
"is_exclusive" => $is_exclusive,
"customized" => $customized,
"tax" => $tax,
"supplierNo" => $supplierNo,
"is_auth" => $is_auth,
"good_size" => $good_size,
"auth_img" => $auth_img,
"after_sales" => $after_sales,
"craft_desc" => $craft_desc,
"good_remark" => $good_remark,
"weight" => $weight,
"packing_way" => $packing_way,
"packing_size" => $packing_size,
"packing_spec" => $packing_spec,
"packing_list" => $packing_list,
"packing_weight" => $packing_weight,
"good_bar" => $good_bar,
"supply_area" => $supply_area,
"delivery_place" => $delivery_place,
"origin_place" => $origin_place,
"delivery_day" => $delivery_day,
"lead_time" => $lead_time,
"sample_day" => $sample_day,
"is_diff" => $is_diff,
'is_stock' => $is_stock,
"config" => $config,
"other_config" => $other_config,
"good_img" => $good_img,
"stock_moq" => $stock_moq,
"good_thumb_img" => $good_thumb_img,
"good_info_img" => $good_info_img,
"status" => $count > 0 ? 2 : 1,
"updatetime" => date("Y-m-d H:i:s")
];
$field = array_diff_assoc($temp, $data);
$temp['field_change'] = empty($field) ? "" : json_encode(array_keys($field));
$up = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->save($temp);
$timp = array_diff($temp, $data);
$json = json_encode($timp, JSON_UNESCAPED_UNICODE);
$jsp = json_encode($data, JSON_UNESCAPED_UNICODE);
if ($up) {
ChangeLog::logAdd(3, $data['spuCode'], $jsp, $json, ['id' => $uid, 'nickname' => $nickname], $this->post);
if ($speclist !== "" && !empty($speclist)) {
foreach ($speclist as $value) {
$lemp = [];
isset($value["id"]) && $value["id"] != '' ? $lemp['id'] = $value['id'] : "";
$lemp['spuCode'] = $supcode;
$lemp['spec_id'] = $value['spec_id'];
$lemp['spec_value_id'] = $value['spec_value_id'];
$lemp['is_del'] = isset($value['is_del']) ? $value['is_del'] : 0;
isset($value["id"]) && $value["id"] != '' ? "" : $lemp['addtime'] = date("Y-m-d H:i:s");
$lemp['updatetime'] = date("Y-m-d H:i:s");
$count = Db::name("good_spec")->save($lemp);
if ($count == false) {
Db::rollback();
return json_show(1004, "商品规格值修改失败");
}
}
}
//修改状态，添加待办
ActionLog::logAdd(['id' => $uid, 'nickname' => $nickname], [
"order_code" => $supcode,//咨询单详情编号
"status" => $data['status'],//这里的status是之前的值
"action_remark" => '',//备注
"action_type" => "edit"//新建create，编辑edit，更改状态status
], "SPCB", $temp['status'], $data);
ProcessOrder::AddProcess(['id' => $uid, 'nickname' => $nickname], [
"order_type" => 'SPCB',
"order_code" => $supcode,//咨询单详情编号
"order_id" => $data['id'],
"order_status" => $temp['status'],
"before_status" => $data['status'],
'holder_id' => $data['createrid'],
'person_id' => Db::name('supplier')->where(['code' => $this->request->user['supplierNo'], 'is_del' => 0])->value('personid'),
]);
Db::commit();
return json_show(0, "更新成功");
} else {
Db::rollback();
return json_show(1005, "更新失败");
}
} catch (\Exception $e) {
Db::rollback();
return json_show(1004, $e->getMessage());
}
}
//修改商品价格信息
public function updateGoodPriceInfo()
{
$this->post = $this->request->filter('trim')->post();
$supcode = isset($this->post['spuCode']) && $this->post['spuCode'] != "" ? trim($this->post['spuCode']) : "";
if ($supcode == "") {
return json_show(1004, "参数spuCode不能为空");
}
$datas = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->find();
if ($datas == false) {
return json_show(1004, "未找到商品数据");
}
if ($datas['status'] != 1) return json_show(1005, '该状态下不允许修改价格信息');
$is_down = Db::name("good_platform")
->where(["spuCode" => $supcode, "is_del" => 0])
->where("exam_status", "<>", 5)
->find();
if ($is_down != false) {
return json_show(1004, "存在未下线商品数据");
}
$cert_fee = isset($this->post['cert_fee']) && $this->post['cert_fee'] !== "" ? floatval($this->post['cert_fee']) : "0";
$packing_fee = isset($this->post['packing_fee']) && $this->post['packing_fee'] !== "" ? floatval($this->post['packing_fee']) : "0";
$cost_fee = isset($this->post['cost_fee']) && $this->post['cost_fee'] !== "" ? floatval($this->post['cost_fee']) : "0";
$mark_fee = isset($this->post['mark_fee']) && $this->post['mark_fee'] !== "" ? floatval($this->post['mark_fee']) : "0";
$demo_fee = isset($this->post['demo_fee']) && $this->post['demo_fee'] !== "" ? floatval($this->post['demo_fee']) : "0";
$open_fee = isset($this->post['open_fee']) && $this->post['open_fee'] !== "" ? floatval($this->post['open_fee']) : "0";
$sample_fee = isset($this->post['sample_fee']) && $this->post['sample_fee'] !== "" ? floatval($this->post['sample_fee']) : "0";
$noble_metal = isset($this->post['noble_metal']) && $this->post['noble_metal'] !== "" ? intval($this->post['noble_metal']) : "0";
$noble_weight = isset($this->post['noble_weight']) && $this->post['noble_weight'] !== "" ? floatval($this->post['noble_weight']) : "0";
$is_gold_price = isset($this->post['is_gold_price']) && $this->post['is_gold_price'] !== "" ? intval($this->post['is_gold_price']) : "0";
$market_price = isset($this->post['market_price']) && $this->post['market_price'] !== "" ? floatval($this->post['market_price']) : "";
$cgd_gold_price = isset($this->post['cgd_gold_price']) && $this->post['cgd_gold_price'] !== "" ? floatval($this->post['cgd_gold_price']) : "0";
if ($market_price === "") {
return json_show(1004, "参数market_price不能为空");
}
$nake_price = isset($this->post['nake_price']) && $this->post['nake_price'] !== "" ? floatval($this->post['nake_price']) : "";
// $is_step = isset($this->post['is_step'])&&$this->post['is_step']!==""? intval($this->post['is_step']):"";
// if($is_step===""){
// return json_show(1004,"参数is_step不能为空");
// }
$good_ladder = isset($this->post['good_ladder']) && !empty($this->post['good_ladder']) ? $this->post['good_ladder'] : "";
// if($is_step==1 && $good_ladder==""){
// return json_show(1004,"启用阶梯，阶梯价不能为空");
// }
$data = [
"cert_fee" => $cert_fee,
"packing_fee" => $packing_fee,
"cost_fee" => $cost_fee,
"mark_fee" => $mark_fee,
"demo_fee" => $demo_fee,
"open_fee" => $open_fee,
"sample_fee" => $sample_fee,
"noble_metal" => $noble_metal,
"noble_weight" => $noble_weight,
"is_gold_price" => $is_gold_price,
"market_price" => $market_price,
"nake_price" => $nake_price,
"cgd_gold_price" => $cgd_gold_price,
"is_step" => count($good_ladder) > 1 ? 1 : 0,
"status" => "3",
"updatetime" => date("Y-m-d H:i:s")
];
$field = array_diff_assoc($data, $datas);
$data['field_change'] = empty($field) ? "" : json_encode(array_keys($field));
$uid = $this->request->user['uid'];
$nickname = $this->request->user['nickname'];
Db::startTrans();
try {
$up = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->save($data);
$temp = array_diff($data, $datas);
$json = json_encode($temp, JSON_UNESCAPED_UNICODE);
$jsp = json_encode($datas, JSON_UNESCAPED_UNICODE);
if ($up) {
ChangeLog::logAdd(3, $datas['spuCode'], $jsp, $json, ['id' => $uid, 'nickname' => $nickname], $this->post);
//修改状态，添加待办
ActionLog::logAdd(['id' => $uid, 'nickname' => $nickname], [
"order_code" => $supcode,//咨询单详情编号
"status" => $datas['status'],//这里的status是之前的值
"action_remark" => '',//备注
"action_type" => "edit"//新建create，编辑edit，更改状态status
], "SPCB", $data['status'], $data);
ProcessOrder::AddProcess(['id' => $uid, 'nickname' => $nickname], [
"order_type" => 'SPCB',
"order_code" => $supcode,//咨询单详情编号
"order_id" => $datas['id'],
"order_status" => $data['status'],
"before_status" => $datas['status'],
'holder_id' => $datas['createrid'],
'person_id' => Db::name('supplier')->where(['code' => $this->request->user['supplierNo'], 'is_del' => 0])->value('personid'),
]);
// $online = Db::name("good_platform")->where(["spuCode"=>$supcode,"is_del"=>0])->find();
// if($online){
// $onup = Db::name("good_platform")->where(["spuCode"=>$supcode,"is_del"=>0])->save
// (["exam_status"=>2,"updatetime"=>date("Y-m-d H:i:s")]);
// if($onup==false){
// Db::rollback();
// return json_show(1004,"商品规成本修改失败");
// }
// //修改状态，添加待办
// ActionLog::logAdd(['id'=>$uid,'nickname'=>$nickname], [
// "order_code" =>$online['skuCode'],//咨询单详情编号
// "status" => $online['exam_status'],//这里的status是之前的值
// "action_remark" => '',//备注
// "action_type" => "edit"//新建create，编辑edit，更改状态status
// ], "SPSX",2,["exam_status"=>2,"updatetime"=>date("Y-m-d H:i:s")]);
//
// ProcessOrder::AddProcess(['id'=>$uid,'nickname'=>$nickname], [
// "order_type" => 'SPSX',
// "order_code" => $online['skuCode'],//咨询单详情编号
// "order_id" => $online['id'],
// "order_status" =>2,"before_status"=>$online['exam_status']
// ]);
// }
if ($good_ladder !== "" && !empty($good_ladder)) {
// $user =GetUserInfo($this->post['token']);
foreach ($good_ladder as $value) {
$lemp = [];
isset($value["id"]) && $value["id"] != '' ? $lemp['id'] = $value['id'] : "";
$lemp['spuCode'] = $supcode;
$lemp['min_num'] = $value['min_num'];
$lemp['nake_fee'] = $value['nake_fee'];
$lemp['cost_fee'] = $value['cost_fee'];
$lemp['delivery_fee'] = $value['delivery_fee'];
$lemp['cert_fee'] = $value['cert_fee'];
$lemp['mark_fee'] = $value['mark_fee'];
$lemp['package_fee'] = $value['package_fee'];
$lemp['other_fee'] = $value['other_fee'];
$top_cat_id = made($datas['cat_id']);//获取所有分类
$top_cat_id = isset($top_cat_id[0]['id']) ? $top_cat_id[0]['id'] : 0;//获取顶级分类id
if ($is_gold_price == 1 && $top_cat_id == 6) {
//$gold =Db::name("gold_price1")->where(["type"=>$noble_metal,"status"=>1,"is_del"=>0])
// ->order("addtime desc")->find();
//$lemp['nake_total'] =$noble_weight*$gold['price'] + $value['cost_fee']*$noble_weight+$value['mark_fee']+$value['package_fee']+$value['cert_fee']+$value['nake_fee']+$value['delivery_fee']+$value['other_fee'];
//成本合计=贵金属重量*供应商采购金价 + 工艺费*贵金属重量+加标费+包装费+证书费+成本裸价+运费+其他费用
//成本总计启用实时金价时，采用供应商实时金价
$lemp['nake_total'] = $noble_weight * $cgd_gold_price + $value['cost_fee'] * $noble_weight +
$value['mark_fee'] + $value['package_fee'] + $value['cert_fee'] + $value['nake_fee'] + $value['delivery_fee'] + $value['other_fee'];
} else {
$lemp['nake_total'] = $value['nake_fee'] + $value['delivery_fee'] + $value['cert_fee'] + $value['mark_fee'] + $value['package_fee'] + $value['other_fee'];
}
$lemp['is_del'] = isset($value['is_del']) ? $value['is_del'] : 0;
$lemp['creater_id'] = $uid;
$lemp['creater'] = $nickname;
isset($value["id"]) && $value["id"] != '' ? "" : $lemp['addtime'] = date("Y-m-d H:i:s");
$lemp['updatetime'] = date("Y-m-d H:i:s");
$count = Db::name("good_nake")->save($lemp);
if ($count == false) {
Db::rollback();
return json_show(1004, "商品规成本修改失败");
}
}
}
Db::commit();
return json_show(0, "更新成功");
} else {
Db::rollback();
return json_show(1005, "更新失败");
}
} catch (\Exception $e) {
Db::rollback();
return json_show(1005, $e->getMessage());
}
}
//修改商品成本全部信息
public function editGoodUp()
{
$this->post = $this->request->filter('trim')->post();
$supcode = isset($this->post['spuCode']) && $this->post['spuCode'] != "" ? trim($this->post['spuCode']) : "";
if ($supcode == "") {
return json_show(1004, "参数spuCode不能为空");
}
$data = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->find();
if ($data == false) {
return json_show(1004, "未找到商品数据");
}
$is_down = Db::name("good_platform")
->where(["spuCode" => $supcode, "is_del" => 0])
->where("exam_status", "not in", [1, 5])//exam_status=1待完善成本，8已下线，除了这两个状态外其他状态都不允许编辑
->find();
if ($is_down != false) {
return json_show(1004, "存在未下线商品数据");
}
if ($data['status'] != 6 && $data['status'] != 7 && $data['status'] != 8) {
return json_show(1004, "商品状态有误");
}
$good_name = isset($this->post['good_name']) && $this->post['good_name'] != "" ? trim($this->post['good_name']) : "";
if ($good_name == "") {
return json_show(1004, "商品名称不能为空");
}
$cat_id = isset($this->post['cat_id']) && $this->post['cat_id'] != "" ? intval($this->post['cat_id']) : "";
if ($cat_id == '') {
return json_show(1004, "商品分类不能为空");
}
$brandid = isset($this->post['brandid']) && $this->post['brandid'] != "" ? intval($this->post['brandid']) : "0";
// if($brandid==''){
// return json_show(1004,"商品品牌不能为空");
// }
$unit = isset($this->post['unit']) && $this->post['unit'] != "" ? trim($this->post['unit']) : "";
if ($unit == '') {
return json_show(1004, "商品单位不能为空");
}
$good_type = isset($this->post['good_type']) && $this->post['good_type'] !== "" ? intval($this->post['good_type']) : "";
if ($good_type === '') {
return json_show(1004, "参数good_type不能为空");
}
$moq = 0;
$customized = 0;
if ($good_type == 1) {
$moq = isset($this->post['moq']) && $this->post['moq'] !== "" ? intval($this->post['moq']) : "";
if ($moq === '') {
return json_show(1004, "定制商品起订量不能为空");
}
$customized = isset($this->post['customized']) && $this->post['customized'] !== "" ? intval($this->post['customized']) : "";
if ($customized === '') {
return json_show(1004, "参数customized不能为空");
}
}
$is_exclusive = isset($this->post['is_exclusive']) && $this->post['is_exclusive'] !== "" ? intval($this->post['is_exclusive']) : "";
if ($is_exclusive === '') {
return json_show(1004, "参数is_exclusive不能为空");
}
// $customized = isset($this->post['customized'])&&$this->post['customized']!==""? intval($this->post['customized']):"";
// if($customized===''){
// return json_show(1004,"参数customized不能为空");
// }
$tax = isset($this->post['tax']) && $this->post['tax'] !== "" ? intval($this->post['tax']) : "";
if ($tax === '') {
return json_show(1004, "参数tax不能为空");
}
$supplierNo = isset($this->post['supplierNo']) && $this->post['supplierNo'] != "" ? trim($this->post['supplierNo']) : "";
if ($supplierNo == '') {
return json_show(1004, "参数supplierNo不能为空");
}
$good_size = isset($this->post['good_size']) && $this->post['good_size'] != "" ? trim($this->post['good_size']) : "";
if ($good_size == '') {
return json_show(1004, "参数good_size不能为空");
}
$company_id = isset($this->post['companyNo']) && $this->post['companyNo'] != "" ? trim($this->post['companyNo']) : "";
if ($company_id == '') {
return json_show(1004, "参数companyNo不能为空");
}
$is_auth = isset($this->post['is_auth']) && $this->post['is_auth'] !== "" ? intval($this->post['is_auth']) : "";
if ($is_auth === '') {
return json_show(1004, "参数is_auth不能为空");
}
$auth_img = isset($this->post['auth_img']) && $this->post['auth_img'] != "" ? trim($this->post['auth_img']) : "";
// if($auth_img==''){
// return json_show(1004,"商品不能为空");
// }
$after_sales = isset($this->post['after_sales']) && $this->post['after_sales'] != "" ? trim($this->post['after_sales']) : "";
if ($after_sales == "") {
return json_show(1004, "参数after_sales不能为空");
}
$craft_desc = isset($this->post['craft_desc']) && $this->post['craft_desc'] != "" ? trim($this->post['craft_desc']) : "";
$good_remark = isset($this->post['good_remark']) && $this->post['good_remark'] != "" ? trim($this->post['good_remark']) : "";
if ($good_remark === "") {
return json_show(1004, "参数good_remark不能为空");
}
$weight = isset($this->post['weight']) && $this->post['weight'] !== "" ? floatval($this->post['weight']) : "";
if ($weight === "") {
return json_show(1004, "参数weight不能为空");
}
$packing_way = isset($this->post['packing_way']) && $this->post['packing_way'] !== "" ? trim($this->post['packing_way']) : "";
if ($packing_way === "") {
return json_show(1004, "参数packing_way不能为空");
}
$packing_size = isset($this->post['packing_size']) && $this->post['packing_size'] !== "" ? trim($this->post['packing_size']) : "";
if ($packing_size === "") {
return json_show(1004, "参数packing_size不能为空");
}
$packing_spec = isset($this->post['packing_spec']) && $this->post['packing_spec'] !== "" ? trim($this->post['packing_spec']) : "";
if ($packing_spec === "") {
return json_show(1004, "参数packing_spec不能为空");
}
$packing_weight = isset($this->post['packing_weight']) && $this->post['packing_weight'] !== "" ? floatval($this->post['packing_weight']) : "";
if ($packing_weight === "") {
return json_show(1004, "参数packing_weight不能为空");
}
$packing_list = isset($this->post['packing_list']) && $this->post['packing_list'] !== "" ? trim($this->post['packing_list']) : "";
if ($packing_list === "") {
return json_show(1004, "参数packing_list不能为空");
}
$good_bar = isset($this->post['good_bar']) && $this->post['good_bar'] !== "" ? trim($this->post['good_bar']) : "";
$supply_area = isset($this->post['supply_area']) && $this->post['supply_area'] !== "" ? intval($this->post['supply_area']) : "";
if ($supply_area === "") {
return json_show(1004, "参数supply_area不能为空");
}
$delivery_place = isset($this->post['delivery_place']) && $this->post['delivery_place'] !== "" ? $this->post['delivery_place'] : "";
if ($delivery_place === "") {
return json_show(1004, "参数delivery_place不能为空");
}
$origin_place = isset($this->post['origin_place']) && $this->post['origin_place'] !== "" ? $this->post['origin_place'] : "";
if ($origin_place === "") {
return json_show(1004, "参数origin_place不能为空");
}
$delivery_day = isset($this->post['delivery_day']) && $this->post['delivery_day'] !== "" ? intval($this->post['delivery_day']) : "";
if ($delivery_day === "") {
return json_show(1004, "参数delivery_day不能为空");
}
$lead_time = isset($this->post['lead_time']) && $this->post['lead_time'] !== "" ? intval($this->post['lead_time']) : "0";
// if($lead_time===""){
// return json_show(1004,"参数lead_time不能为空");
// }
$sample_day = isset($this->post['sample_day']) && $this->post['sample_day'] !== "" ? intval($this->post['sample_day']) : "0";
// if($sample_day===""){
// return json_show(1004,"参数sample_day不能为空");
// }
$sample_fee = isset($this->post['sample_fee']) && $this->post['sample_fee'] !== "" ? floatval($this->post['sample_fee']) : "0";
$good_img = isset($this->post['good_img']) && $this->post['good_img'] != "" ? trim($this->post['good_img']) : "";
if ($good_img === "") {
return json_show(1004, "参数good_img不能为空");
}
$good_thumb_img = isset($this->post['good_thumb_img']) && $this->post['good_thumb_img'] !== "" ? trim($this->post['good_thumb_img']) : "";
if ($good_thumb_img === "") {
return json_show(1004, "参数good_thumb_img不能为空");
}
$good_info_img = isset($this->post['good_info_img']) && !empty($this->post['good_info_img']) ? trim($this->post['good_info_img']) : "";
if ($good_info_img === "") {
return json_show(1004, "参数good_info_img不能为空");
}
$cert_fee = isset($this->post['cert_fee']) && $this->post['cert_fee'] !== "" ? floatval($this->post['cert_fee']) : "0";
$packing_fee = isset($this->post['packing_fee']) && $this->post['packing_fee'] !== "" ? floatval($this->post['packing_fee']) : "0";
$cost_fee = isset($this->post['cost_fee']) && $this->post['cost_fee'] !== "" ? floatval($this->post['cost_fee']) : "0";
$mark_fee = isset($this->post['mark_fee']) && $this->post['mark_fee'] !== "" ? floatval($this->post['mark_fee']) : "0";
$demo_fee = isset($this->post['demo_fee']) && $this->post['demo_fee'] !== "" ? floatval($this->post['demo_fee']) : "0";
$open_fee = isset($this->post['open_fee']) && $this->post['open_fee'] !== "" ? floatval($this->post['open_fee']) : "0";
$noble_metal = isset($this->post['noble_metal']) && $this->post['noble_metal'] !== "" ? intval($this->post['noble_metal']) : "0";
$noble_weight = isset($this->post['noble_weight']) && $this->post['noble_weight'] !== "" ? floatval($this->post['noble_weight']) : "0";
$is_gold_price = isset($this->post['is_gold_price']) && $this->post['is_gold_price'] !== "" ? intval($this->post['is_gold_price']) : "0";
$market_price = isset($this->post['market_price']) && $this->post['market_price'] !== "" ? floatval($this->post['market_price']) : "";
$cgd_gold_price = isset($this->post['cgd_gold_price']) && $this->post['cgd_gold_price'] !== "" ? floatval($this->post['cgd_gold_price']) : "0";
if ($market_price === "") {
return json_show(1004, "参数market_price不能为空");
}
$nake_price = isset($this->post['nake_price']) && $this->post['nake_price'] !== "" ? floatval($this->post['nake_price']) : "0";
$config = isset($this->post['config']) && $this->post['config'] !== "" ? trim($this->post['config']) : "";
$other_config = isset($this->post['other_config']) && $this->post['other_config'] !== "" ? trim($this->post['other_config']) : "";
$is_diff = isset($this->post['is_diff']) && $this->post['is_diff'] !== "" ? intval($this->post['is_diff']) : "0";
$is_stock = isset($this->post['is_stock']) && $this->post['is_stock'] !== "" ? intval($this->post['is_stock']) : "0";
$stock_moq = isset($this->post['stock_moq']) && $this->post['stock_moq'] !== "" ? intval($this->post['stock_moq']) : "0";
if ($is_stock == 1 && $stock_moq == 0) {
return json_show(1004, "库存品备库起订量不能为零");
}
// $is_step = isset($this->post['is_step'])&&$this->post['is_step']!==""? intval($this->post['is_step']):"";
// if($is_step===""){
// return json_show(1004,"参数is_step不能为空");
// }
$good_ladder = isset($this->post['good_ladder']) && !empty($this->post['good_ladder']) ? $this->post['good_ladder'] : "";
// if($is_step==1 && $good_ladder==""){
// return json_show(1004,"启用阶梯，阶梯价不能为空");
// }
$speclist = isset($this->post['speclist']) && !empty($this->post['speclist']) ? $this->post['speclist'] : "";
$is_support_barter = isset($this->post['is_support_barter']) && $this->post['is_support_barter'] !== "" ? intval($this->post['is_support_barter']) : 1;
$uid = $this->request->user['uid'];
$nickname = $this->request->user['nickname'];
Db::startTrans();
try {
$temp = [
"good_name" => $good_name,
"cat_id" => $cat_id,
'brand_id' => $brandid,
"good_unit" => $unit,
"good_type" => $good_type,
"companyNo" => $company_id,
"moq" => $moq,
"is_exclusive" => $is_exclusive,
"customized" => $customized,
"tax" => $tax,
"supplierNo" => $supplierNo,
"is_auth" => $is_auth,
"good_size" => $good_size,
"auth_img" => $auth_img,
"after_sales" => $after_sales,
"craft_desc" => $craft_desc,
"good_remark" => $good_remark,
"weight" => $weight,
"packing_way" => $packing_way,
"packing_size" => $packing_size,
"packing_spec" => $packing_spec,
"packing_list" => $packing_list,
"packing_weight" => $packing_weight,
"good_bar" => $good_bar,
"supply_area" => $supply_area,
"delivery_place" => $delivery_place,
"origin_place" => $origin_place,
"delivery_day" => $delivery_day,
"lead_time" => $lead_time,
"sample_day" => $sample_day,
"sample_fee" => $sample_fee,
"good_img" => $good_img,
"good_thumb_img" => $good_thumb_img,
"good_info_img" => $good_info_img,
"cert_fee" => $cert_fee,
"packing_fee" => $packing_fee,
"is_diff" => $is_diff,
"config" => $config,
"other_config" => $other_config,
"is_stock" => $is_stock,
"cost_fee" => $cost_fee,
"mark_fee" => $mark_fee,
"demo_fee" => $demo_fee,
"open_fee" => $open_fee,
"noble_metal" => $noble_metal,
"noble_weight" => $noble_weight,
"is_gold_price" => $is_gold_price,
"market_price" => $market_price,
"nake_price" => $nake_price,
"cgd_gold_price" => $cgd_gold_price,
"is_step" => count($good_ladder) > 1 ? 1 : 0,
"stock_moq" => $stock_moq,
"status" => "0",
"updatetime" => date("Y-m-d H:i:s"),
'is_support_barter' => $is_support_barter
];
$field = array_diff_assoc($temp, $data);
$temp['field_change'] = empty($field) ? "" : json_encode(array_keys($field));
$up = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->save($temp);
$var = array_diff($temp, $data);
$json = json_encode($var, JSON_UNESCAPED_UNICODE);
$dat = json_encode($data, JSON_UNESCAPED_UNICODE);
if ($up) {
ChangeLog::logAdd(3, $data['spuCode'], $dat, $json, ['id' => $uid, 'nickname' => $nickname], $this->post);
//修改状态，添加待办
ActionLog::logAdd(['id' => $uid, 'nickname' => $nickname], [
"order_code" => $supcode,//咨询单详情编号
"status" => $data['status'],//这里的status是之前的值
"action_remark" => '',//备注
"action_type" => "create"//新建create，编辑edit，更改状态status
], "SPCB", 0, $temp);
ProcessOrder::AddProcess(['id' => $uid, 'nickname' => $nickname], [
"order_type" => 'SPCB',
"order_code" => $supcode,//咨询单详情编号
"order_id" => $data['id'],
"order_status" => 0,
"before_status" => 0,
'holder_id' => $data['createrid'],
'person_id' => Db::name('supplier')->where(['code' => $this->request->user['supplierNo'], 'is_del' => 0])->value('personid'),
]);
if ($speclist !== "" && !empty($speclist)) {
foreach ($speclist as $value) {
$lemp = [];
isset($value["id"]) && $value["id"] != '' ? $lemp['id'] = $value['id'] : "";
$lemp['spuCode'] = $supcode;
$lemp['spec_id'] = $value['spec_id'];
$lemp['spec_value_id'] = $value['spec_value_id'];
$lemp['is_del'] = isset($value['is_del']) ? $value['is_del'] : 0;
isset($value["id"]) && $value["id"] != '' ? "" : $lemp['addtime'] = date("Y-m-d H:i:s");
$lemp['updatetime'] = date("Y-m-d H:i:s");
$count = Db::name("good_spec")->save($lemp);
if ($count == false) {
Db::rollback();
return json_show(1004, "商品规格值修改失败");
}
}
}
if ($good_ladder !== "" && !empty($good_ladder)) {
// $user =GetUserInfo($this->post['token']);//获取用户信息，下面更新成本表的创建人
$top_cat_id = made($cat_id);//获取所有分类
$top_cat_id = isset($top_cat_id[0]['id']) ? $top_cat_id[0]['id'] : 0;//获取顶级分类id
foreach ($good_ladder as $value) {
$lemp = [];
isset($value["id"]) && $value["id"] != '' ? $lemp['id'] = $value['id'] : "";
$lemp['spuCode'] = $supcode;
$lemp['min_num'] = $value['min_num'];
$lemp['nake_fee'] = $value['nake_fee'];
$lemp['cost_fee'] = $value['cost_fee'];
$lemp['delivery_fee'] = $value['delivery_fee'];
$lemp['cert_fee'] = $value['cert_fee'];
$lemp['mark_fee'] = $value['mark_fee'];
$lemp['package_fee'] = $value['package_fee'];
$lemp['other_fee'] = $value['other_fee'];
if ($is_gold_price == 1 && $top_cat_id == 6) {
// $gold =Db::name("gold_price1")->where(["type"=>$noble_metal,"status"=>1,"is_del"=>0])
// ->order("addtime desc")->find();
//$lemp['nake_total'] =$noble_weight*$gold['price'] + $value['cost_fee']*$noble_weight+$value['mark_fee']+$value['package_fee']+$value['cert_fee']+$value['nake_fee']+$value['delivery_fee']+$value['other_fee'];
//成本合计=贵金属重量*供应商采购金价 + 工艺费*贵金属重量+加标费+包装费+证书费+成本裸价+运费+其他费用
//成本总计启用实时金价时，采用供应商实时金价
$lemp['nake_total'] = $noble_weight * $cgd_gold_price + $value['cost_fee'] * $noble_weight +
$value['mark_fee'] + $value['package_fee'] + $value['cert_fee'] + $value['nake_fee'] + $value['delivery_fee'] + $value['other_fee'];
} else {
$lemp['nake_total'] = $value['nake_fee'] + $value['delivery_fee'] + $value['cert_fee'] + $value['mark_fee'] + $value['package_fee'] + $value['other_fee'];
}
$lemp['creater_id'] = $this->request->user['uid'];
$lemp['creater'] = $this->request->user['nickname'];
$lemp['is_del'] = isset($value['is_del']) ? $value['is_del'] : 0;
isset($value["id"]) && $value["id"] != '' ? "" : $lemp['addtime'] = date("Y-m-d H:i:s");
$lemp['updatetime'] = date("Y-m-d H:i:s");
$count = Db::name("good_nake")->save($lemp);
if ($count == false) {
Db::rollback();
return json_show(1004, "商品规成本修改失败");
}
}
}
Db::commit();
return json_show(0, "更新成功");
} else {
Db::rollback();
return json_show(1005, "更新失败");
}
} catch (\Exception $e) {
Db::rollback();
return json_show(1004, $e->getMessage());
}
}
//获取商品详情
public function read()
{
$this->post = $this->request->filter('trim')->post();
$supcode = isset($this->post['spuCode']) && $this->post['spuCode'] != "" ? trim($this->post['spuCode']) : "";
if ($supcode == "") {
return json_show(1004, "参数spuCode不能为空");
}
$data = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->find();
if ($data == false) {
return json_show(1004, "未找到商品数据");
}
$unit = Db::name("unit")->where(["id" => $data['good_unit']])->find();
$data['unit'] = isset($unit['unit']) ? $unit['unit'] : '';
$data['cat_info'] = made($data['cat_id'], []);
$spec = Db::name("good_spec")->where(["spuCode" => $supcode, "is_del" => 0])->select()->toArray();
$supplier = Db::name("supplier")->where(["code" => $data['supplierNo']])->find();
$data['supplierName'] = isset($supplier['name']) ? $supplier['name'] : "";
$supplier = Db::name("supplier")->where(["code" => $data['supplierNo']])->find();
$data['supplierName'] = isset($supplier['name']) ? $supplier['name'] : "";
$company = Db::name("business")->where(["companyNo" => $data['companyNo']])->find();
$data['company'] = isset($company['company']) ? $company['company'] : "";
$data['field_change'] = $data['field_change'] != '' ? json_decode($data['field_change']) : "";
if ($data['brand_id'] != 0) {
$brand = Db::name("brand")->where(["id" => $data['brand_id']])->find();
$data["brand_name"] = isset($brand['brand_name']) ? $brand['brand_name'] : "";
} else {
$data["brand_name"] = "";
$data["brand_id"] = "";
}
$excluse = makeExcluse($data['is_exclusive']);
$data['exclusive'] = $excluse;
$data['noble_name'] = isset($data['noble_metal']) && $data['noble_metal'] != 0 ? $this->noble[$data['noble_metal']] : "";
$data["good_info_img"] = $data['good_info_img'] != "" ? $data['good_info_img'] : '';
$data["good_img"] = $data['good_img'] != "" ? $data['good_img'] : [];
$gold = [];
if ($data['is_gold_price'] == 1) {
$gold = Db::name("gold_price1")->where(["type" => $data['noble_metal'], "status" => 1, "is_del" => 0])->order("addtime desc")->find();
}
$data['gold_price'] = isset($gold["price"]) ? $gold["price"] : 0;
$speclist = [];
if (!empty($spec)) {
foreach ($spec as $value) {
$temp = [];
$temp['id'] = $value['id'];
$temp['spuCode'] = $value['spuCode'];
$temp['spec_id'] = $value['spec_id'];
$temp['spec_value_id'] = $value['spec_value_id'];
$temp['is_del'] = $value['is_del'];
$sp = Db::name("specs")->where(["id" => $value['spec_id']])->find();
$temp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
$spv = Db::name("spec_value")->where(["id" => $value['spec_value_id']])->find();
$temp['spec_value'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
$speclist[] = $temp;
}
}
$data["speclist"] = empty($speclist) ? [] : $speclist;
// $nake=[];
$nakelist = Db::name("good_nake")->where(['spuCode' => $supcode, "is_del" => 0])->select()->toArray();
// $catinfo = Db::name("cat")->where(["id"=>$data['cat_id']])->find();
// $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
$nakearry = [];
if (!empty($nakelist)) {
foreach ($nakelist as $value) {
$nakearry[] = $value;
}
}
$data["nakelist"] = $nakearry;
return json_show(0, "获取成功", $data);
}
//创建规格值
public function createSpec()
{
$this->post = $this->request->filter('trim')->post();
$spec_id = isset($this->post['spec_id']) && $this->post['spec_id'] !== "" ? intval($this->post['spec_id']) : "";
if ($spec_id == "") {
return json_show(1002, "参数spec_id不能为空");
}
$spec_value = isset($this->post['spec_value']) && $this->post['spec_value'] !== "" ? trim($this->post['spec_value']) : "";
if ($spec_value == "") {
return json_show(1002, "参数spec_value不能为空");
}
$id_is_empty = Db::name('spec_value')
->field('id')
->where([
'spec_id' => $spec_id,
'spec_value' => $spec_value,
'is_del' => 0
])->find();
if ($id_is_empty) return json_show(1005, '数据库已存在该规格值');
else {
$data = [
"spec_id" => $spec_id,
"spec_value" => $spec_value,
"is_del" => 0,
"addtime" => date("Y-m-d H:i:s"),
"updatetime" => date("Y-m-d H:i:s")
];
$info = Db::name("spec_value")->insert($data);
if ($info) return json_show(0, "新建成功");
else return json_show(1002, "新建失败");
}
}
//所有规格值
public function allSpec()
{
$spec_id = $this->request->filter('trim')->post('spec_id/d', 0);
if ($spec_id == 0) {
return json_show(1002, "参数spec_id不能为空");
}
$info = Db::name('spec_value')
->where(['spec_id' => $spec_id, 'is_del' => 0])
->select()
->toArray();
return json_show(0, "获取成功", $info);
}
//分类信息
public function catInfo()
{
// $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) :"";
$id = $this->request->filter('trim')->post('id/d', 0);
if ($id == "") {
return json_show(1002, "参数id不能为空");
}
$idinfo = Db::name('cat')->where(['id' => $id])->find();
if ($idinfo == "") {
return json_show(1002, "未找到数据");
}
$info = Db::name('cat_specs')->where(['cat_id' => $idinfo['id'], 'is_del' => 0])->column('specs_id');
$temp = Db::name('specs')->where(['id' => $info, 'is_del' => 0])->field("id,spec_name")->select();
//$idinfo['cat_id']=$info['cat_id'];
$idinfo['spec'] = $temp;
// $idinfo['specs_id']=$info;
return json_show(0, "获取成功", $idinfo);
}
//实时金价列表
public function goldPriceLastList()
{
$this->post = $this->request->filter('trim')->post();
$where = [['g.is_del', '=', 0]];
$type = isset($this->post['type']) && $this->post['type'] != "" ? intval($this->post['type']) : "";
if ($type !== "") $where[] = ['g.type', '=', $type];
$company_name = isset($this->post['company_name']) && $this->post['company_name'] !== "" ? trim($this->post['company_name']) : "";
if ($company_name !== "") $where[] = ["g.action_id", 'in', get_company_item_user_by_name($company_name)];
$ids = Db::name("gold_price1")
->where(['is_del' => 0])
->group("type")
->column("max(id) as id");
$where[] = ['g.id', 'in', $ids];
$list = Db::name("gold_price1")
->alias('g')
->where($where)
->select()
->toArray();
$all_createrid = array_column($list,'action_id');
$item = get_company_name_by_uid($all_createrid);
$data = [];
foreach ($list as $value) {
$value['type_cn'] = $this->gold[$value['type']];
$value['company_name'] = $item[$value['action_id']]??'';
$data[] = $value;
}
return json_show(0, "获取成功", $data);
}
//贵金属种类列表
public function linst()
{
$data = [];
foreach ($this->gold as $key => $value) {
$v = [];
$v['type'] = $key;
$v['type_cn'] = $value;
$data[] = $v;
}
return json_show(0, "获取成功", $data);
}
//分类列表
public function wlist()
{
$this->post = $this->request->filter('trim')->post();
$page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) : "1";
$size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) : "10";
$where = [["is_del", "=", 0], ['level', "=", 3]];
$cat_name = isset($this->post['cat_name']) && $this->post['cat_name'] !== "" ? trim($this->post['cat_name']) : "";
if ($cat_name !== "") {
$where[] = ['cat_name', "like", "%$cat_name%"];
}
$search = isset($this->post['search']) && $this->post['search'] !== "" ? trim($this->post['search']) : "";
if ($search !== "") {
$where[] = ['search', "like", "%$search%"];
}
$pid = isset($this->post['pid']) && $this->post['pid'] !== "" ? intval($this->post['pid']) : "";
if ($pid !== "") {
$where[] = ['pid', "=", $pid];
}
$status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
if ($status !== "") {
$where[] = ['status', "=", $status];
}
$count = Db::name("cat")->where($where)->count();
$total = ceil($count / $size);
$page = $page >= $total ? $total : $page;
$list = Db::name('cat')->where($where)->page($page, $size)->select();
$data = [];
foreach ($list as $value) {
$temp = isset($value['id']) && $value['id'] != 0 ? made($value['id']) : [];
$value['item'] = array_column($temp, 'id');
$data[] = $value;
}
return json_show(0, "获取成功", ['list' => $data, 'count' => $count]);
}
//分类列表-全部
public function title()
{
$this->post = $this->request->filter('trim')->post();
$where = [["is_del", "=", 0]];
$cat_name = isset($this->post['cat_name']) && $this->post['cat_name'] !== "" ? trim($this->post['cat_name']) : "";
if ($cat_name !== "") $where[] = ['cat_name', "like", "%$cat_name%"];
$pid = isset($this->post['pid']) && $this->post['pid'] !== "" ? intval($this->post['pid']) : "";
if ($pid !== "") $where[] = ["pid", "=", $pid];
$status = isset($this->post['status']) && $this->post['status'] !== "" ? intval($this->post['status']) : "";
if ($status !== "") $where[] = ['status', "=", $status];
$list = Db::name('cat')
->where($where)
->select()
->toArray();
return json_show(0, "获取成功", $list);
}
//判断是否允许修改成本信息和基础信息
public function checkIsUpdate()
{
$spuCode = $this->request->post('spuCode', '', 'trim');
if ($spuCode == '') return json_show(1004, '成本商品编号不能为空');
$is_allow_update = 1;
//检查是否有上线记录
$rs = Db::name('good_platform')
->field('id')
->where(['spuCode' => $spuCode, 'is_del' => 0])
->whereNotIn('exam_status', [0, 5])
->find();
if (!empty($rs)) $is_allow_update = 0;
else {
$rs = PlatformYouzan::field('id')
->where(['spuCode' => $spuCode, 'is_del' => PlatformYouzan::$del_normal])
->whereNotIn('exam_status', [PlatformYouzan::$exam_status_8, PlatformYouzan::$exam_status_2])
->findOrEmpty()
->isEmpty();
if (!$rs) $is_allow_update = 0;
}
return json_show(0, '请求成功', ['is_allow_update' => $is_allow_update]);
}
//上线商品复制
public function copy()
{
$this->post = $this->request->filter('trim')->post();
$supcode = isset($this->post['spuCode']) && $this->post['spuCode'] != "" ? trim($this->post['spuCode']) : "";
if ($supcode == "") {
return json_show(1004, "参数spuCode不能为空");
}
$data = Db::name("good_basic")->where(["spuCode" => $supcode, "is_del" => 0])->find();
if ($data == false) {
return json_show(1004, "未找到商品数据");
}
// $token = isset($this->post['token']) && $this->post['token'] != '' ? trim($this->post['token']) : "";
// if ($token == '') {
// return json_show(105, "参数token不能为空");
// }
// $user =GetUserInfo($token);
// if(empty($user)||$user['code']!=0){
// return json_show(102,"用户数据不存在");
// }
$createrid = $this->request->user['uid'];
$creater = $this->request->user['nickname'];
$nake = Db::name("good_nake")->where(["spuCode" => $supcode, "is_del" => 0])->select()->toArray();
$ladd = [];
$newCode = makeNo("SKU");
if (!empty($nake)) {
foreach ($nake as $value) {
$tmp = [];
$tmp['spuCode'] = $newCode;
$tmp['min_num'] = $value['min_num'];
$tmp['nake_fee'] = $value['nake_fee'];
$tmp['cost_fee'] = $value['cost_fee'];
$tmp['delivery_fee'] = $value['delivery_fee'];
$tmp['cert_fee'] = $value['cert_fee'];
$tmp['mark_fee'] = $value['mark_fee'];
$tmp['package_fee'] = $value['package_fee'];
$tmp['other_fee'] = $value['other_fee'];
$tmp['nake_total'] = $value['nake_total'];
$tmp['creater_id'] = $createrid;
$tmp['creater'] = $creater;
$tmp['is_del'] = $value['is_del'];
$tmp['addtime'] = date("Y-m-d H:i:s");
$tmp['updatetime'] = date("Y-m-d H:i:s");
$ladd[] = $tmp;
}
}
$spec = Db::name("good_spec")
->where(["spuCode" => $supcode, "is_del" => 0])
->select()
->toArray();
$specArr = [];
if (!empty($spec)) {
foreach ($spec as $value) {
$tmp = [];
$tmp['spuCode'] = $newCode;
$tmp['spec_id'] = $value['spec_id'];
$tmp['spec_value_id'] = $value['spec_value_id'];
$tmp['is_del'] = $value['is_del'];
$tmp['addtime'] = date("Y-m-d H:i:s");
$tmp['updatetime'] = date("Y-m-d H:i:s");
$specArr[] = $tmp;
}
}
Db::startTrans();
try {
unset($data['id']);
$data['spuCode'] = $newCode;
$data['createrid'] = $createrid;
$data['creater'] = $creater;
$data['status'] = 7;
$data['addtime'] = date("Y-m-d H:i:s");
$data['updatetime'] = date("Y-m-d H:i:s");
$cre = Db::name("good_basic")->insert($data);
if ($cre) {
//修改状态，添加待办
ActionLog::logAdd(['id' => $createrid, 'nickname' => $creater], [
"order_code" => $newCode,//咨询单详情编号
"status" => 0,//这里的status是之前的值
"action_remark" => '',//备注
"action_type" => "create"//新建create，编辑edit，更改状态status
], "SPCB", 7, $data);
ProcessOrder::AddProcess(['id' => $createrid, 'nickname' => $creater], [
"order_type" => 'SPCB',
"order_code" => $newCode,//咨询单详情编号
"order_id" => Db::name("good_basic")->getLastInsID(),
"order_status" => 7,
"before_status" => 0,
'holder_id' => $data['createrid'],
'person_id' => Db::name('supplier')->where(['code' => $this->request->user['supplierNo'], 'is_del' => 0])->value('personid'),
]);
if (!empty($ladd)) {
$na = Db::name("good_nake")->insertAll($ladd);
if ($na == 0) {
Db::rollback();
return json_show(1005, "成本数据复制失败");
}
}
if (!empty($specArr)) {
$sp = Db::name("good_spec")->insertAll($specArr);
if ($sp == 0) {
Db::rollback();
return json_show(1005, "规格数据复制失败");
}
}
Db::commit();
return json_show(0, "复制数据成功", ["spuCode" => $newCode]);
} else {
Db::rollback();
return json_show(1005, "数据复制失败");
}
} catch (\Exception $e) {
Db::rollback();
return json_show(1004, $e->getMessage());
}
}
//上线商品详情
public function info()
{
$this->post = $this->request->filter('trim')->post();
$skucode = isset($this->post['skuCode']) && $this->post['skuCode'] != "" ? trim($this->post['skuCode']) : "";
if ($skucode == "") {
return json_show(1005, "参数skuCode不能为空");
}
$good_platform = Db::name("good_platform")->where(['skuCode' => $skucode, "is_del" => 0])->find();
if ($good_platform == false) {
return json_show(1004, "未找到商品数据");
}
$data = Db::name("good")->where(["spuCode" => $good_platform['spuCode'], "is_del" => 0])->find();
if ($data == false) {
return json_show(1004, "未找到商品数据");
}
$plat = Db::name("platform")->where(["id" => $good_platform['platform_code']])->find();
$data['skuCode'] = $good_platform['skuCode'];
$data['platform_code'] = $good_platform['id'];
$data['platform_code_en'] = isset($plat['platform_code']) ? $plat['platform_code'] : "";
$data['platform_name'] = isset($plat['platform_name']) ? $plat['platform_name'] : "";
$data['online_reason'] = $good_platform['online_reason'];
$data['online_time'] = $good_platform['online_time'];
$data['online_remark'] = $good_platform['online_remark'];
$data['exam_status'] = $good_platform['exam_status'];
$data['is_online'] = $good_platform['is_online'];
$data['plat_code'] = $good_platform['plat_code'];
$data['exclusive'] = makeExcluse($data['is_exclusive']);
$unit = Db::name("unit")->where(["id" => $data['good_unit']])->find();
$data['unit'] = isset($unit['unit']) ? $unit['unit'] : '';
$data['cat_info'] = made($data['cat_id'], []);
$spec = Db::name("good_spec")->where(["spuCode" => $good_platform['spuCode'], "is_del" => 0])->select()->toArray();
$supplier = Db::name("supplier")->where(["code" => $data['supplierNo']])->find();
$data['supplierName'] = isset($supplier['name']) ? $supplier['name'] : "";
$data['noble_name'] = isset($data['noble_metal']) && $data['noble_metal'] != 0 ? $this->noble[$data['noble_metal']] : "";
$company = Db::name("business")->where(["companyNo" => $data['companyNo']])->find();
$data['company'] = isset($company['company']) ? $company['company'] : "";
if ($data['brand_id'] != 0) {
$brand = Db::name("brand")->where(["id" => $data['brand_id']])->find();
$data["brand_name"] = isset($brand['brand_name']) ? $brand['brand_name'] : "";
} else {
$data["brand_name"] = "";
$data["brand_id"] = "";
}
$data['origin_place_cn'] = "";
$data['delivery_place_cn'] = "";
if ($data['delivery_place'] !== "") {
$place = ["provice_code" => "", "city_code" => "", "area_code" => ""];
list($place['provice_code'], $place['city_code'], $place['area_code']) = explode(",", $data['delivery_place']);
$data['delivery_place_cn'] = GetAddr(json_encode($place));
}
if ($data['origin_place'] !== "") {
$place = ["provice_code" => "", "city_code" => "", "area_code" => ""];
list($place['provice_code'], $place['city_code'], $place['area_code']) = explode(",", $data['origin_place']);
$data['origin_place_cn'] = GetAddr(json_encode($place));
}
$excluse = makeExcluse($data['is_exclusive']);
$data['exclusive'] = $excluse;
$data["good_info_img"] = $data['good_info_img'] != "" ? $data['good_info_img'] : [];
$data["good_img"] = $data['good_img'] != "" ? $data['good_img'] : [];
$speclist = [];
if (!empty($spec)) {
foreach ($spec as $value) {
$temp = [];
$temp['id'] = $value['id'];
$temp['spuCode'] = $value['spuCode'];
$temp['spec_id'] = $value['spec_id'];
$temp['spec_value_id'] = $value['spec_value_id'];
$temp['is_del'] = $value['is_del'];
$sp = Db::name("specs")->where(["id" => $value['spec_id']])->find();
$temp['spec_name'] = isset($sp["spec_name"]) ? $sp["spec_name"] : "";
$spv = Db::name("spec_value")->where(["id" => $value['spec_value_id']])->find();
$temp['spec_value'] = isset($spv["spec_value"]) ? $spv["spec_value"] : "";
$speclist[] = $temp;
}
}
$data["speclist"] = empty($speclist) ? [] : $speclist;
$ladder = Db::name("good_ladder")->where(['skuCode' => $skucode, "is_del" => 0])->select()->toArray();
$data["ladderlist"] = !empty($ladder) ? $ladder : [];
$nakelist = Db::name("good_nake")->where(['spuCode' => $good_platform['spuCode'], "is_del" => 0])->select()->toArray();
// $catinfo = Db::name("cat")->where(["id"=>$data['cat_id']])->find();
$cat_top_list = $data['cat_info'];
$cat_top_id = isset($cat_top_list[0]['id']) ? $cat_top_list[0]['id'] : 0;
// $budget = isset($catinfo['order_rate']) ? $catinfo['order_rate']/100:0;
$gold_price = 0;
if ($data['is_gold_price'] == 1 && $cat_top_id == 6) {
$gold_price = Db::name("gold_price1")->where(["type" => $data['noble_metal'], "status" => 1, "is_del" => 0])->order("addtime desc")->value('price', 0);
}
$data['gold_price'] = $gold_price;
$nakearry = [];
if (!empty($nakelist)) {
//实时金价
foreach ($nakelist as $value) {
$value['sale_price'] = $value['nake_total'];
//计算最终售价
if ($data['is_gold_price'] == 1 && $cat_top_id == 6) {
//普通商品：直接用财务提交的售价字段；
//贵金属（ 商品重量* 最新金价 + 工艺费（财务定价提交的）* 商品重量+包装费+加标费+证书费+产品裸价+其他费用）=商品库商品直接下单的售价
$value['sale_price'] = ($data['weight'] * $gold_price + $value['cost_fee'] * $data['weight'] + $value['package_fee'] + $value['mark_fee'] + $value['cert_fee'] + $value['nake_fee'] + $value['other_fee']);
}
$nakearry[] = $value;
}
}
$proof = Db::name("good_proof")->where(["spuCode" => $good_platform['spuCode'], "is_del" => 0])->order("updatetime desc")->field("id,proof_type,proof_url")->find();
$data['proof'] = isset($proof) && $proof != false ? $proof : [];
$data["nakelist"] = $nakearry;
//补充采购员字段
//成本表里的创建人，也是线上商品的采购人，为了防止混淆，给creater取个别名
$temp_basic_info = Db::name('good_basic')
->field('id,createrid purchase_id,creater purchase')
->where(['spuCode' => $data['spuCode'], 'is_del' => 0])
->find();
$data['purchase_id'] = $temp_basic_info['purchase_id'];
$data['purchase'] = $temp_basic_info['purchase'];
return json_show(0, "获取成功", $data);
}
}