Consult.php 25 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536
  1. <?php
  2. namespace app\admin\controller;
  3. use app\BaseController;
  4. use think\App;
  5. use think\facade\Db;
  6. class Consult extends BaseController
  7. {
  8. public $post = "";
  9. public function __construct(App $app)
  10. {
  11. parent::__construct($app);
  12. $this->post=$this->request->post();
  13. $token = isset($this->post['token']) ? trim($this->post['token']) : "";
  14. if($token==""){
  15. return error_show(101,'token不能为空');
  16. }
  17. $effetc = VerifyTokens($token);
  18. if(!empty($effetc) && $effetc['code']!=0) {
  19. return error_show($effetc['code'], $effetc['message']);
  20. }
  21. }
  22. public function list(){
  23. $page = isset($this->post['page']) && $this->post['page'] !== "" ? intval($this->post['page']) :"1";
  24. $size = isset($this->post['size']) && $this->post['size'] !== "" ? intval($this->post['size']) :"10";
  25. $where=[['is_del',"=",0],["cat_id","<>",0]];
  26. $zxNo = isset($this->post['zxNo']) && $this->post['zxNo'] !== "" ? trim($this->post['zxNo']) : "";
  27. if ($zxNo !== "") {
  28. $where[] = ['zxNo','=',$zxNo];
  29. }
  30. $sequenceNo = isset($this->post['sequenceNo']) && $this->post['sequenceNo'] !== "" ? trim($this->post['sequenceNo']) : "";
  31. if ($sequenceNo !== "") {
  32. $where[] = ['sequenceNo','like',"%$sequenceNo%"];
  33. }
  34. $salesman = isset($this->post['salesman']) && $this->post['salesman'] !== "" ? trim($this->post['salesman']) : "";
  35. if ($salesman !== "") {
  36. //$where["salesman"] =Db::Raw("like '%$salesman%'");
  37. $where[]= ["salesman",'like',"%$salesman%"];
  38. }
  39. $cpName = isset($this->post['cpName']) && $this->post['cpName'] !== "" ? trim($this->post['cpName']) : "";
  40. if ($cpName !== "") {
  41. //$where["cpName"]= Db::Raw("like '%$cpName%'");
  42. $where[]= ["cpName",'like',"%$cpName%"];
  43. }
  44. $khNo = isset($this->post['khNo']) && $this->post['khNo'] !== "" ? trim($this->post['khNo']) : "";
  45. if ($khNo !== "") {
  46. // $where['khNo'] = $khNo;
  47. $where[]= ["khNo",'like',"%$khNo%"];
  48. }
  49. $start= isset($this->post['start']) && $this->post['start'] !== "" ? $this->post['start']:"";
  50. if ($start !="") {
  51. //$where = ["zxtime"=>Db::raw(">= '{$start}'")];
  52. $where[]= ["zxtime",'>=',$start];
  53. }
  54. $end = isset($this->post['end']) && $this->post['end'] !== "" ? $this->post['end'] :"";
  55. if($end !=""){
  56. $where[]= ["zxtime",'<=',$end];
  57. }
  58. $status = isset($this->post['status']) && $this->post['status'] !== "" ? trim($this->post['status']) : "";
  59. if ($status !== "") {
  60. $where[]= ["status",'=',$status];
  61. }
  62. $count = Db::name('consult')->where($where)->count();
  63. $total = ceil($count / $size);
  64. $page = $page >= $total ? $total : $page;
  65. $list = Db::name('consult')->where($where)->page($page,$size)
  66. ->select();
  67. $data=[];
  68. foreach ($list as $value){
  69. $value['can']= isset($value['cat_id']) && $value['cat_id'] !=0 ? made($value['cat_id']):[];
  70. $data[]=$value;
  71. }
  72. return app_show(0,"获取成功",['count'=>$count,'list'=>$data]);
  73. }
  74. public function info(){
  75. $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) : "";
  76. if($id==""){
  77. return error_show(1002,"咨询单编号不能为空");
  78. }
  79. $fo = Db::name('consult')->where(['id'=>$id,'is_del'=>0])->find();
  80. $in= isset($fo['cat_id']) && $fo['cat_id'] !=0 ? made($fo['cat_id']):[];
  81. $fo['can']=$in;
  82. if(empty($fo)){
  83. return error_show(1002,"未找到咨询单编号");
  84. }else{
  85. return app_show(0,"获取成功",$fo);
  86. }
  87. }
  88. public function del(){
  89. $id = isset($this->post['id']) && $this->post['id'] !=="" ? intval($this->post['id']) : "";
  90. $de = Db::name('consult')->where(['id'=>$id,'is_del'=>0])->find();
  91. if($de==false){
  92. return error_show(1002,'咨询单编号未找到');
  93. }
  94. $dell= Db::name('consult')->update(['id'=>$id,'is_del'=>1,'updatetime'=>date("Y-m-d H:i:s")]);
  95. if($dell){
  96. return error_show(0,"删除成功");
  97. }else
  98. return error_show(1002,"删除失败");
  99. }
  100. public function create(){
  101. $is_project= isset($this->post['is_project']) && $this->post['is_project'] !=="" ? intval($this->post['is_project']) : "";
  102. if($is_project===""){
  103. return error_show(1002,"参数is_project不能为空");
  104. }
  105. if($is_project==1){
  106. $projectNo= isset($this->post['projectNo']) && $this->post['projectNo'] !=="" ? trim($this->post['projectNo']) : "";
  107. if($projectNo===""){
  108. return error_show(1002,"参数projectNo不能为空");
  109. }
  110. }
  111. $khNo = isset($this->post['khNo']) && $this->post['khNo'] !=="" ? trim($this->post['khNo']) : "";
  112. if($khNo===""){
  113. return error_show(1002,"参数khNo不能为空");
  114. }
  115. $endtime = isset($this->post['endtime']) && $this->post['endtime'] !=="" ? $this->post['endtime'] : "";
  116. if($endtime===""){
  117. return error_show(1002,"参数endtime不能为空");
  118. }
  119. $saleid = isset($this->post['saleid']) && $this->post['saleid'] !=="" ? intval($this->post['saleid']) : "";
  120. if($saleid===""){
  121. return error_show(1002,"参数saleid不能为空");
  122. }
  123. $depart = isset($this->post['depart']) && $this->post['depart'] !=="" ? intval($this->post['depart']) : "";
  124. if($depart===""){
  125. return error_show(1002,"参数depart不能为空");
  126. }
  127. $platform_code = isset($this->post['platform_code']) && $this->post['platform_code'] !=="" ? trim($this->post['platform_code']) :
  128. "";
  129. if($platform_code===""){
  130. return error_show(1002,"参数platform_code不能为空");
  131. }
  132. $zxNo=makeNo("ZX");
  133. $data=[
  134. "zxNo"=>$zxNo,
  135. "createrid"=>0,
  136. "creater"=>"",
  137. "is_project"=>$is_project,
  138. "projectNo"=>isset($projectNo) ? $projectNo:"",
  139. "khNo"=>$khNo,
  140. "endtime"=>$endtime,
  141. "salesman"=>"",
  142. "platform_code"=>$platform_code,
  143. "saleid"=>$saleid,
  144. "depart"=>$depart,
  145. "status"=>0,
  146. "is_del"=>0,
  147. "addtime"=>date("Y-m-d H:i:s"),
  148. "updatetime"=>date("Y-m-d H:i:s"),
  149. ];
  150. $zx = Db::name("consult_order")->insert($data);
  151. if($zx){
  152. return app_show(0,"新建成功",["zxNo"=>$zxNo]);
  153. }else{
  154. return error_show(1004,"新建失败");
  155. }
  156. }
  157. public function zxadd(){
  158. $good_name = isset($this->post['good_name'])&&$this->post['good_name']!==""?trim($this->post['good_name']):"";
  159. if($good_name===""){
  160. return error_show(1004,"参数good_name不能为空");
  161. }
  162. $zxNo = isset($this->post['zxNo'])&&$this->post['zxNo']!==""?trim($this->post['zxNo']):"";
  163. if($zxNo===""){
  164. return error_show(1004,"参数zxNo不能为空");
  165. }
  166. $cat_id = isset($this->post['cat_id'])&&$this->post['cat_id']!==""?intval($this->post['cat_id']):"";
  167. if($cat_id===""){
  168. return error_show(1004,"参数cat_id不能为空");
  169. }
  170. $arrival_time = isset($this->post['arrival_time'])&&$this->post['arrival_time']!==""?$this->post['arrival_time']
  171. :"";
  172. if($arrival_time===""){
  173. return error_show(1004,"参数arrival_time不能为空");
  174. }
  175. $good_img = isset($this->post['good_img'])&&$this->post['good_img']!==""?trim($this->post['good_img']):"";
  176. if($good_img===""){
  177. return error_show(1004,"参数good_img不能为空");
  178. }
  179. $is_custom = isset($this->post['is_custom'])&&$this->post['is_custom']!==""?intval($this->post['is_custom']):"";
  180. if($is_custom===""){
  181. return error_show(1004,"参数is_custom不能为空");
  182. }
  183. $unit = isset($this->post['unit'])&&$this->post['unit']!==""?trim($this->post['unit']):"";
  184. if($unit===""){
  185. return error_show(1004,"参数unit不能为空");
  186. }
  187. $brand_id = isset($this->post['brand_id'])&&$this->post['brand_id']!==""?intval($this->post['brand_id']):"";
  188. if($brand_id===""){
  189. return error_show(1004,"参数brand_id不能为空");
  190. }
  191. $material = isset($this->post['material'])&&$this->post['material']!==""?trim($this->post['material']):"";
  192. if($material===""){
  193. return error_show(1004,"参数material不能为空");
  194. }
  195. $color = isset($this->post['color'])&&$this->post['color']!==""?trim($this->post['color']):"";
  196. if($color===""){
  197. return error_show(1004,"参数color不能为空");
  198. }
  199. $cost_desc = isset($this->post['cost_desc'])&&$this->post['cost_desc']!==""?trim($this->post['cost_desc']):"";
  200. if($cost_desc===""){
  201. return error_show(1004,"参数cost_desc不能为空");
  202. }
  203. $model = isset($this->post['model'])&&$this->post['model']!==""?trim($this->post['model']):"";
  204. if($model===""){
  205. return error_show(1004,"参数model不能为空");
  206. }
  207. $is_addrs = isset($this->post['is_addrs'])&&$this->post['is_addrs']!==""?intval($this->post['is_addrs']):"";
  208. if($is_addrs===""){
  209. return error_show(1004,"参数is_addrs不能为空");
  210. }
  211. $metal_id = isset($this->post['metal_id'])&&$this->post['metal_id']!==""?trim($this->post['metal_id']):"";
  212. if($metal_id===""){
  213. return error_show(1004,"参数metal_id不能为空");
  214. }
  215. if($metal_id==0){
  216. $config = isset($this->post['config'])&&!empty($this->post['config'])?$this->post['config']:"";
  217. if($config===""){
  218. return error_show(1004,"参数config不能为空");
  219. }
  220. $other_config = isset($this->post['other_config'])&&$this->post['other_config']!==""?trim($this->post['other_config'])
  221. :"";
  222. if($other_config===""){
  223. return error_show(1004,"参数other_config不能为空");
  224. }
  225. $specs_weight = isset($this->post['specs_weight'])&&$this->post['specs_weight']!==""?floatval($this->post['specs_weight']):"";
  226. if($specs_weight===""){
  227. return error_show(1004,"参数specs_weight不能为空");
  228. }
  229. $gold_price = isset($this->post['gold_price'])&&$this->post['gold_price']!==""?floatval($this->post['gold_price']):"";
  230. if($gold_price===""){
  231. return error_show(1004,"参数gold_price不能为空");
  232. }
  233. $budget_price = isset($this->post['budget_price'])&&$this->post['budget_price']!==""?floatval($this->post['budget_price']):"";
  234. if($budget_price===""){
  235. return error_show(1004,"参数budget_price不能为空");
  236. }
  237. }
  238. $num = isset($this->post['num'])&&$this->post['num']!==""?intval($this->post['num']):"";
  239. if($num===""){
  240. return error_show(1004,"参数num不能为空");
  241. }
  242. $use_desc = isset($this->post['use_desc'])&&$this->post['use_desc']!==""?trim($this->post['use_desc']):"";
  243. if($use_desc===""){
  244. return error_show(1004,"参数use_desc不能为空");
  245. }
  246. $remark = isset($this->post['remark'])&&$this->post['remark']!==""?trim($this->post['remark']):"";
  247. if($remark===""){
  248. return error_show(1004,"参数remark不能为空");
  249. }
  250. Db::startTrans();
  251. try{
  252. $infoNo=makeNo("INF");
  253. $info=[
  254. "infoNo"=>$infoNo,
  255. "zxNo"=>$zxNo,
  256. "spuCode"=>"",
  257. "good_name"=>$good_name,
  258. "good_img"=>$good_img,
  259. "cat_id"=>$cat_id,
  260. "unit"=>$unit,
  261. "brand_id"=>$brand_id,
  262. "arrival_time"=>$arrival_time,
  263. "model"=>$model,
  264. "color"=>$color,
  265. "material"=>$material,
  266. "cost_desc"=>$cost_desc,
  267. "is_addrs"=>$is_addrs,
  268. "is_custom"=>$is_custom,
  269. "metal_id"=>$metal_id,
  270. "config"=>isset($config)?$config:"",
  271. "other_config"=>isset($other_config)?$other_config:"",
  272. "specs_weight"=>isset($specs_weight)?$specs_weight:0,
  273. "gold_price"=>isset($gold_price)?$gold_price:0,
  274. "budget_price"=>$budget_price,
  275. "num"=>$num,
  276. "use_desc"=>$use_desc,
  277. "remark"=>$remark,
  278. "status"=>0,
  279. "is_del"=>0,
  280. "addtime"=>date("Y-m-d H:i:s"),
  281. "updatetime"=>date("Y-m-d H:i:s")
  282. ];
  283. $up = Db::name("consult_info")->insert($info);
  284. if($up){
  285. Db::commit();
  286. return app_show(0,"添加成功",["infoNo"=>$infoNo]);
  287. }else{
  288. Db::rollback();
  289. return error_show(1004,'添加失败');
  290. }
  291. }catch (\Exception $e){
  292. Db::rollback();
  293. return error_show(1004,$e->getMessage());
  294. }
  295. }
  296. public function zxinfo(){
  297. $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
  298. if($infoNo==""){
  299. return error_show(1004,"参数infoNo不能为空");
  300. }
  301. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
  302. if($zxinfo==false){
  303. return error_show(1004,"未找到信息数据");
  304. }
  305. $zxorder = Db::name("consilt_order")->where(["zxNo"=>$zxinfo['zxNo'],"is_del"=>0])->find();
  306. if($zxorder==false){
  307. return error_show(1004,"未找到咨询信息数据");
  308. }
  309. $zxorder['khname']="";
  310. if($zxorder['khNo']!==""){
  311. $kh=Db::name("customer_info")->where(['companyNo'=>$zxorder['khNo']])->find();
  312. $zxorder['khname']= isset($kh['companyName'])?$kh['companyName']:"";
  313. }
  314. return app_show(0,"获取成功",$zxinfo);
  315. }
  316. //** 发布竞标任务 */
  317. public function bargain(){
  318. $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
  319. if($infoNo==""){
  320. return error_show(1004,"参数infoNo不能为空");
  321. }
  322. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
  323. if($zxinfo==false){
  324. return error_show(1004,"未找到信息数据");
  325. }
  326. $status =isset($this->post['status']) && $this->post['status']!=="" ? intval($this->post['status']):"";
  327. if($status===""){
  328. return error_show(1004,"参数status不能为空");
  329. }
  330. if($status==1&&$zxinfo['status']>1){
  331. $zxinfo['bargain_num']=+1;
  332. }
  333. $zxinfo['status']=$status;
  334. $zxinfo['updatetime']=date("Y-m-d H:i:s");
  335. $up = Db::name("consult_info")->save($zxinfo);
  336. if($up){
  337. return app_show(0,"状态更新成功");
  338. }else{
  339. return error_show(1003,"状态更新失败");
  340. }
  341. }
  342. public function feadback(){
  343. $infoNo= isset($this->post['infoNo'])&&$this->post['infoNo']!=""?trim($this->post['infoNo']):"";
  344. if($infoNo==""){
  345. return error_show(1004,"参数infoNo不能为空");
  346. }
  347. $zxinfo = Db::name("consult_info")->where(["infoNo"=>$infoNo,"is_del"=>0])->find();
  348. if($zxinfo==false){
  349. return error_show(1004,"未找到信息数据");
  350. }
  351. $pname = isset($this->post['pname'])&&$this->post['pname']!=""? trim($this->post['pname']):"";
  352. if($pname==""){
  353. return error_show(1004,"参数pname不能为空");
  354. }
  355. $brandid = isset($this->post['brandid'])&&$this->post['brandid']!=""? intval($this->post['brandid']):"";
  356. if($brandid==""){
  357. return error_show(1004,"参数brandid不能为空");
  358. }
  359. $cat_id = isset($this->post['cat_id'])&&$this->post['cat_id']!=""? trim($this->post['cat_id']):"";
  360. if($cat_id==""){
  361. return error_show(1004,"参数cat_id不能为空");
  362. }
  363. $model = isset($this->post['model'])&&$this->post['model']!=""? trim($this->post['model']):"";
  364. //$unit = isset($this->post['model'])&&$this->post['model']!=""? trim($this->post['model']):"";
  365. $material = isset($this->post['material'])&&$this->post['material']!=""? trim($this->post['material']):"";
  366. $unit_id = isset($this->post['unit_id'])&&$this->post['unit_id']!=""? intval($this->post['unit_id']):"";
  367. $cost_desc = isset($this->post['cost_desc'])&&$this->post['cost_desc']!=""? trim($this->post['cost_desc']):"";
  368. $work_day = isset($this->post['work_day'])&&$this->post['work_day']!=""? intval($this->post['work_day']):"";
  369. $delivery_day = isset($this->post['delivery_day'])&&$this->post['delivery_day']!=""? intval($this->post['delivery_day']):"";
  370. $good_img = isset($this->post['good_img'])&&$this->post['good_img']!=""? trim($this->post['good_img']):"";
  371. $expire_day = isset($this->post['expire_day'])&&$this->post['expire_day']!=""? intval($this->post['expire_day'])
  372. :"";
  373. $origin_place = isset($this->post['origin_place'])&&$this->post['origin_place']!=""? trim($this->post['origin_place']):"";
  374. $supplierNo = isset($this->post['supplierNo'])&&$this->post['supplierNo']!=""? trim($this->post['supplierNo']):"";
  375. $pay_way = isset($this->post['pay_way'])&&$this->post['pay_way']!=""? intval($this->post['pay_way']):"";
  376. $tax = isset($this->post['tax'])&&$this->post['tax']!=""? trim($this->post['tax']):"";
  377. $send_way = isset($this->post['send_way'])&&$this->post['send_way']!=""? intval($this->post['send_way']):"";
  378. $metal_id = isset($this->post['metal_id'])&&$this->post['metal_id']!=""? intval($this->post['metal_id']):"";
  379. $is_gold_price = isset($this->post['is_gold_price'])&&$this->post['is_gold_price']!=""? intval($this->post['is_gold_price']):"";
  380. $config = isset($this->post['config'])&&$this->post['config']!=""? $this->post['config']:"";
  381. $weight = isset($this->post['weight'])&&$this->post['weight']!=""? floatval($this->post['weight']):"";
  382. $demo_fee = isset($this->post['demo_fee'])&&$this->post['demo_fee']!=""? floatval($this->post['demo_fee']):"";
  383. $delivery_fee = isset($this->post['delivery_fee'])&&$this->post['delivery_fee']!=""? floatval($this->post['delivery_fee']):"";
  384. $open_fee = isset($this->post['open_fee'])&&$this->post['open_fee']!=""? floatval($this->post['open_fee']):"";
  385. $pakge_fee = isset($this->post['pakge_fee'])&&$this->post['pakge_fee']!=""? floatval($this->post['pakge_fee']):"";
  386. $nake_fee = isset($this->post['nake_fee'])&&$this->post['nake_fee']!=""? floatval($this->post['nake_fee']):"";
  387. $mark_fee = isset($this->post['mark_fee'])&&$this->post['mark_fee']!=""? floatval($this->post['mark_fee']):"";
  388. $cert_fee = isset($this->post['cert_fee'])&&$this->post['cert_fee']!=""? floatval($this->post['cert_fee']):"";
  389. $cost_fee = isset($this->post['cost_fee'])&&$this->post['cost_fee']!=""? floatval($this->post['cost_fee']):"";
  390. $total_fee = isset($this->post['total_fee'])&&$this->post['total_fee']!=""? floatval($this->post['total_fee']):"";
  391. $is_diff = isset($this->post['is_diff'])&&$this->post['is_diff']!==""? intval($this->post['is_diff']):"";
  392. $supply_area = isset($this->post['supply_area'])&&$this->post['supply_area']!==""? intval($this->post['supply_area']):"";
  393. $remark = isset($this->post['remark'])&&$this->post['remark']!=""? trim($this->post['remark']):"";
  394. $token = isset($this->post['token'])&& $this->post['token']!='' ? trim($this->post['token']):"";
  395. if($token==''){
  396. return error_show(1005,"参数token不能为空");
  397. }
  398. $user =GetUserInfo($token);
  399. if(empty($user)||$user['code']!=0){
  400. return error_show(1002,"用户数据不存在");
  401. }
  402. $createrid= isset($user["data"]['id']) ? $user["data"]['id'] : "";
  403. $creater= isset($user["data"]['nickname']) ? $user["data"]['nickname'] : "";
  404. $bidNo=makeNo("BD");
  405. $spucode=makeNo("SPU");
  406. $data=[
  407. "bidNo"=>$bidNo,
  408. "infoNo"=>$infoNo,
  409. "zxNo"=>$zxinfo['zxNo'],
  410. "spuCode"=>$spucode,
  411. "good_name"=>$pname,
  412. "brand_id"=>$brandid,
  413. "cat_id"=>$cat_id,
  414. "model"=>$model,
  415. "material"=>$material,
  416. "unit_id"=>$unit_id,
  417. "cost_desc"=>$cost_desc,
  418. "work_day"=>$work_day,
  419. "delivery_day"=>$delivery_day,
  420. "good_img"=>$good_img,
  421. "expire_day"=>$expire_day,
  422. "origin_place"=>$origin_place,
  423. "supplierNo"=>$supplierNo,
  424. "pay_way"=>$pay_way,
  425. "tax"=>$tax,
  426. "send_way"=>$send_way,
  427. "metal_id"=>$metal_id,
  428. "is_gold_price"=>$is_gold_price,
  429. "config"=>$config,
  430. "weight"=>$weight,
  431. "is_diff"=>$is_diff,
  432. "demo_fee"=>$demo_fee,
  433. "delivery_fee"=>$delivery_fee,
  434. "open_fee"=>$open_fee,
  435. "pakge_fee"=>$pakge_fee,
  436. "nake_fee"=>$nake_fee,
  437. "mark_fee"=>$mark_fee,
  438. "cert_fee"=>$cert_fee,
  439. "cost_fee"=>$cost_fee,
  440. "total_fee"=>$total_fee,
  441. "supply_area"=>$supply_area,
  442. "remark"=>$remark,
  443. "sale_price"=>0,
  444. "createrid"=>$createrid,
  445. "creater"=>$creater,
  446. "status"=>0,
  447. "addtime"=>date("Y-m-d H:i:s"),
  448. "updatetime"=>date("Y-m-d H:i:s")
  449. ];
  450. Db::startTrans();
  451. try{
  452. $insert= Db::name("consult_bids")->insert($data);
  453. if($insert){
  454. $data=[
  455. "spuCode"=>$spucode,
  456. "good_name"=>$pname,
  457. "brand_id"=>$brandid,
  458. "good_unit"=>$unit_id,
  459. "good_type"=>0,
  460. "moq"=>1,
  461. "customized"=>$work_day,
  462. "tax"=>$tax,
  463. "supplierNo"=>$supplierNo,
  464. "is_auth"=>0,
  465. "craft_desc"=>$cost_desc,
  466. "good_remark"=>$remark,
  467. "good_img"=>$good_img,
  468. "good_thumb_img"=>"",
  469. "good_info_img"=>"",
  470. "status"=>0,
  471. "is_del"=>0,
  472. "createrid"=>$createrid,
  473. "creater"=>$creater,
  474. "addtime"=>date("Y-m-d H:i:s"),
  475. "updatetime"=>date("Y-m-d H:i:s")
  476. ];
  477. $good = Db::name("good_zixun")->insert($data);
  478. if($good){
  479. Db::commit();
  480. return app_show(0,"反馈成功",["bidNo"=>$bidNo]);
  481. }else{
  482. Db::rollback();
  483. return error_show(1004,"反馈失败");
  484. }
  485. }else{
  486. Db::rollback();
  487. return error_show(1004,"反馈失败");
  488. }
  489. }catch (\Exception $e){
  490. Db::rollback();
  491. return error_show(1004,$e->getMessage());
  492. }
  493. }
  494. public function feadinfo(){
  495. $bidNo =isset($this->post['bidNo'])&& $this->post['bidNo']!=""?trim($this->post['bidNo']):"";
  496. if($bidNo==""){
  497. return error_show(1004,"参数bidNo不能为空");
  498. }
  499. $info =Db::name("good_bids")->where(['bidNo'=>$bidNo,"is_del"=>0])->find();
  500. if($info==false){
  501. return error_show(1004,"未找到商品数据");
  502. }
  503. $unit =Db::name("unit")->where(["id"=>$info['good_unit']])->find();
  504. $info['unit'] = isset($unit['unit'])?$unit['unit']:'';
  505. $info['cat_info'] = made($info['cat_id'],[]);
  506. $supplier = Db::name("supplier")->where(["code"=>$info['supplierNo']])->find();
  507. $info['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
  508. $supplier = Db::name("supplier")->where(["code"=>$info['supplierNo']])->find();
  509. $info['supplierName'] = isset($supplier['name'])?$supplier['name']:"";
  510. if($info['brand_id']!=0){
  511. $brand=Db::name("brand")->where(["id"=>$info['brand_id']])->find();
  512. $info["brand_name"]=isset($brand['brand_name'])?$brand['brand_name']:"";
  513. }else{
  514. $info["brand_name"]="";
  515. $info["brand_id"]="";
  516. }
  517. }
  518. }