Queue.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426
  1. <?php
  2. namespace app\common\logic;
  3. use think\facade\Db;
  4. /**
  5. * ============================================================================
  6. * DSMall多用户商城
  7. * ============================================================================
  8. * 版权所有 2014-2028 长沙德尚网络科技有限公司,并保留所有权利。
  9. * 网站地址: http://www.csdeshang.com
  10. * ----------------------------------------------------------------------------
  11. * 这不是一个自由软件!您只能在不用于商业目的的前提下对程序代码进行修改和使用 .
  12. * 不允许对程序代码以任何形式任何目的的再发布。
  13. * ============================================================================
  14. * 逻辑层模型
  15. */
  16. class Queue
  17. {
  18. /**
  19. * 添加会员积分
  20. * @param unknown $member_info
  21. */
  22. public function addPoint($member_info)
  23. {
  24. $points_model = model('points');
  25. $points_model->savePointslog('login', array(
  26. 'pl_memberid' => $member_info['member_id'], 'pl_membername' => $member_info['member_name']
  27. ), true);
  28. return ds_callback(true);
  29. }
  30. /**
  31. * 添加会员经验值
  32. * @param unknown $member_info
  33. */
  34. public function addExppoint($member_info)
  35. {
  36. $exppoints_model = model('exppoints');
  37. $exppoints_model->saveExppointslog('login', array(
  38. 'explog_memberid' => $member_info['member_id'], 'explog_membername' => $member_info['member_name']
  39. ), true);
  40. return ds_callback(true);
  41. }
  42. /**
  43. * 更新抢购信息
  44. * @param unknown $groupbuy_info
  45. * @throws Exception
  46. */
  47. public function editGroupbuySaleCount($groupbuy_info)
  48. {
  49. $groupbuy_model = model('groupbuy');
  50. $data = array();
  51. $data['groupbuy_buyer_count'] = Db::raw('groupbuy_buyer_count+1');
  52. $data['groupbuy_buy_quantity'] = Db::raw('groupbuy_buy_quantity+'.$groupbuy_info['quantity']);
  53. $update = $groupbuy_model->editGroupbuy($data, array('groupbuy_id' => $groupbuy_info['groupbuy_id']));
  54. if (!$update) {
  55. return ds_callback(false, '更新抢购信息失败groupbuy_id:' . $groupbuy_info['groupbuy_id']);
  56. }
  57. else {
  58. return ds_callback(true);
  59. }
  60. }
  61. /**
  62. * 根据商品id更新促销价格
  63. *
  64. * @param int /array $goods_commonid
  65. * @return boolean
  66. */
  67. public function updateGoodsPromotionPriceByGoodsId($goods_id)
  68. {
  69. if(!is_array($goods_id)){
  70. $goods_id=(string)$goods_id;
  71. }
  72. $condition = array();
  73. $condition[] = array('goods_id','in', $goods_id);
  74. $update = model('goods')->editGoodsPromotionPrice($condition);
  75. if (!$update) {
  76. return ds_callback(false, '根据商品ID更新促销价格失败');
  77. }
  78. else {
  79. return ds_callback(true);
  80. }
  81. }
  82. /**
  83. * 根据商品公共id更新促销价格
  84. *
  85. * @param int /array $goods_commonid
  86. * @return boolean
  87. */
  88. public function updateGoodsPromotionPriceByGoodsCommonId($goods_commonid)
  89. {
  90. if(!is_array($goods_commonid)){
  91. $goods_commonid=(string)$goods_commonid;
  92. }
  93. $condition = array();
  94. $condition[] = array('goods_commonid','in', $goods_commonid);
  95. $update = model('goods')->editGoodsPromotionPrice($condition);
  96. if (!$update) {
  97. return ds_callback(false, '根据商品公共id更新促销价格失败');
  98. }
  99. else {
  100. return ds_callback(true);
  101. }
  102. }
  103. /**
  104. * 发送店铺消息
  105. */
  106. public function sendStoremsg($param)
  107. {
  108. $send = new \sendmsg\sendStoremsg();
  109. $send->set('code', $param['code']);
  110. $send->set('store_id', $param['store_id']);
  111. $send->send($param['param'],isset($param['weixin_param'])?$param['weixin_param']:array(),isset($param['ali_param'])?$param['ali_param']:array(),isset($param['ten_param'])?$param['ten_param']:array());
  112. return ds_callback(true);
  113. }
  114. /**
  115. * 发送会员消息
  116. */
  117. public function sendMemberMsg($param)
  118. {
  119. $send = new \sendmsg\sendMemberMsg();
  120. $send->set('code', $param['code']);
  121. $send->set('member_id', $param['member_id']);
  122. if (!empty($param['number']['mobile']))
  123. $send->set('mobile', $param['number']['mobile']);
  124. if (!empty($param['number']['email']))
  125. $send->set('email', $param['number']['email']);
  126. $send->send($param['param'],isset($param['weixin_param'])?$param['weixin_param']:array(),isset($param['ali_param'])?$param['ali_param']:array(),isset($param['ten_param'])?$param['ten_param']:array());
  127. return ds_callback(true);
  128. }
  129. /**
  130. * 清理特殊商品促销信息
  131. */
  132. public function clearSpecialGoodsPromotion($param)
  133. {
  134. // 抢购
  135. model('groupbuy')->delGroupbuy(array('goods_commonid' => $param['goods_commonid']));
  136. // 显示折扣
  137. $condition = array();
  138. $condition[] = array('goods_id','in', $param['goodsid_array']);
  139. model('pxianshigoods')->delXianshigoods($condition);
  140. // 优惠套装
  141. $condition = array();
  142. $condition[] = array('goods_id','in', $param['goodsid_array']);
  143. model('pbundling')->delBundlingGoods($condition);
  144. // 更新促销价格
  145. model('goods')->editGoods(array('goods_promotion_price' => Db::raw('goods_price'),'goods_promotion_type' => 0), array('goods_commonid' => $param['goods_commonid']));
  146. return ds_callback(true);
  147. }
  148. /**
  149. * 删除(买/卖家)订单全部数量缓存
  150. * @param array $data 订单信息
  151. * @return boolean
  152. */
  153. public function delOrderCountCache($order_info)
  154. {
  155. if (empty($order_info))
  156. return ds_callback(true);
  157. $order_model = model('order');
  158. if (isset($order_info['order_id'])) {
  159. $order_info = $order_model->getOrderInfo(array('order_id' => $order_info['order_id']), array(), 'buyer_id,store_id');
  160. }
  161. if(isset($order_info['buyer_id'])) {
  162. $order_model->delOrderCountCache('buyer', $order_info['buyer_id']);
  163. }
  164. if (isset($order_info['store_id'])) {
  165. $order_model->delOrderCountCache('store', $order_info['store_id']);
  166. }
  167. return ds_callback(true);
  168. }
  169. /**
  170. * 发送提货码短信消息
  171. */
  172. public function sendPickupcode($param)
  173. {
  174. $order_common_info = model('order')->getOrdercommonInfo(array('order_id' => $param['order_id']),'reciver_info');
  175. if($order_common_info){
  176. $order_common_info['reciver_info'] = @unserialize($order_common_info['reciver_info']);
  177. $tpl_info = model('mailtemplates')->getTplInfo(array('mailmt_code' => 'send_pickup_code'));
  178. $data = array();
  179. $data['pickup_code'] = $param['pickup_code'];
  180. $ten_data=array($data['pickup_code']);
  181. $message = ds_replace_text($tpl_info['mailmt_content'], $data);
  182. $smslog_param=array(
  183. 'ali_template_code'=>$tpl_info['ali_template_code'],
  184. 'ali_template_param'=>$data,
  185. 'ten_template_code'=>$tpl_info['ten_template_code'],
  186. 'ten_template_param'=>$ten_data,
  187. 'message'=>$message,
  188. );
  189. $result = model('smslog')->sendSms($order_common_info['reciver_info']['mob_phone'], $smslog_param);
  190. if (!$result) {
  191. return ds_callback(false, '发送提货码短信消息失败order_id:' . $param['order_id']);
  192. }
  193. else {
  194. return ds_callback(true);
  195. }
  196. }else{
  197. return ds_callback(false, '发送提货码短信消息失败order_id:' . $param['order_id']);
  198. }
  199. }
  200. /**
  201. * 生成卡密代金券
  202. */
  203. public function build_pwdvoucher($t_id)
  204. {
  205. $t_id = intval($t_id);
  206. if ($t_id <= 0) {
  207. return ds_callback(false, '参数错误');
  208. }
  209. $voucher_model = model('voucher');
  210. //查询代金券详情
  211. $where = array();
  212. $where[] = array('vouchertemplate_id','=',$t_id);
  213. $gettype_arr = $voucher_model->getVoucherGettypeArray();
  214. $where[] = array('vouchertemplate_gettype','=',$gettype_arr['pwd']['sign']);
  215. $where[] = array('vouchertemplate_isbuild','=',0);
  216. $where[] = array('vouchertemplate_state','=',1);
  217. $t_info = $voucher_model->getVouchertemplateInfo($where);
  218. $t_total = intval($t_info['vouchertemplate_total']);
  219. if ($t_total <= 0) {
  220. return ds_callback(false, '代金券模板信息错误');
  221. }
  222. while ($t_total > 0) {
  223. $is_succ = false;
  224. $insert_arr = array();
  225. $step = $t_total > 1000 ? 1000 : $t_total;
  226. for ($t = 0; $t < $step; $t++) {
  227. $voucher_code = $voucher_model->getVoucherCode(0);
  228. if (!$voucher_code) {
  229. continue;
  230. }
  231. $voucher_pwd_arr = $voucher_model->createVoucherPwd($t_info['vouchertemplate_id']);
  232. if (!$voucher_pwd_arr) {
  233. continue;
  234. }
  235. $tmp = array();
  236. $tmp['voucher_code'] = $voucher_code;
  237. $tmp['vouchertemplate_id'] = $t_info['vouchertemplate_id'];
  238. $tmp['voucher_title'] = $t_info['vouchertemplate_title'];
  239. $tmp['voucher_desc'] = $t_info['vouchertemplate_desc'];
  240. $tmp['voucher_startdate'] = $t_info['vouchertemplate_startdate'];
  241. $tmp['voucher_enddate'] = $t_info['vouchertemplate_enddate'];
  242. $tmp['voucher_price'] = $t_info['vouchertemplate_price'];
  243. $tmp['voucher_limit'] = $t_info['vouchertemplate_limit'];
  244. $tmp['voucher_store_id'] = $t_info['vouchertemplate_store_id'];
  245. $tmp['voucher_state'] = 1;
  246. $tmp['voucher_activedate'] = TIMESTAMP;
  247. $tmp['voucher_owner_id'] = 0;
  248. $tmp['voucher_owner_name'] = '';
  249. $tmp['voucher_order_id'] = 0;
  250. $tmp['voucher_pwd'] = $voucher_pwd_arr[0];//md5
  251. $tmp['voucher_pwd2'] = $voucher_pwd_arr[1];
  252. $insert_arr[] = $tmp;
  253. $t_total--;
  254. }
  255. $result = $voucher_model->addVoucherBatch($insert_arr);
  256. if ($result && $is_succ == false) {
  257. $is_succ = true;
  258. }
  259. }
  260. //更新代金券模板
  261. if ($is_succ) {
  262. $voucher_model->editVouchertemplate(array('vouchertemplate_id' => $t_info['vouchertemplate_id']), array('vouchertemplate_isbuild' => 1));
  263. return ds_callback(true);
  264. }
  265. else {
  266. return ds_callback(false);
  267. }
  268. }
  269. /**
  270. * 上架
  271. *
  272. * @param int $goods_commonid
  273. */
  274. public function editProducesOnline($goods_commonid){
  275. $condition = array(array('goods_commonid','=',$goods_commonid));
  276. $update = model('goods')->editProducesOnline($condition);
  277. if (!$update){
  278. return ds_callback(false);
  279. }
  280. return ds_callback(true);
  281. }
  282. /**
  283. * 优惠套装过期
  284. *
  285. * @param int $store_id
  286. */
  287. public function editBundlingQuotaClose($store_id) {
  288. $pbundling_model=model('pbundling');
  289. if(intval(config('ds_config.promotion_bundling_price'))!=0){
  290. //如果没有购买过套餐,则将之前添加的优惠组合关闭
  291. Db::name('pbundling')->alias('pbundling')->join('pbundlingquota pbundlingquota', 'pbundling.store_id = pbundlingquota.store_id','LEFT')->where('pbundlingquota.store_id',null)->update(array('bl_state'=>$pbundling_model::STATE0));
  292. }
  293. $condition = array(array('store_id','=', $store_id));
  294. $update = $pbundling_model->editBundlingQuotaClose($condition);
  295. if (!$update) {
  296. return ds_callback(false);
  297. }
  298. return ds_callback(true);
  299. }
  300. /**
  301. * 推荐展位过期
  302. *
  303. * @param int $store_id
  304. */
  305. public function editBoothClose($store_id) {
  306. $pbooth_model=model('pbooth');
  307. if(intval(config('ds_config.promotion_bundling_price'))!=0){
  308. //如果没有购买过套餐,则将之前添加的优惠组合关闭
  309. Db::name('pboothgoods')->alias('pboothgoods')->join('pboothquota pboothquota', 'pboothgoods.store_id = pboothquota.store_id','LEFT')->where('pboothquota.store_id',null)->update(array('boothgoods_state'=>$pbooth_model::STATE0));
  310. }
  311. $condition = array(array('store_id','=', $store_id));
  312. $update = $pbooth_model->editBoothClose($condition);
  313. if (!$update) {
  314. return ds_callback(false);
  315. }
  316. return ds_callback(true);
  317. }
  318. /**
  319. * 抢购开始更新商品促销价格
  320. *
  321. * @param int $goods_commonid
  322. */
  323. public function editGoodsGroupbuyPrice($goods_commonid) {
  324. $condition = array();
  325. $condition[] = array('goods_commonid','=', $goods_commonid);
  326. $condition[] = array('groupbuy_starttime','<', TIMESTAMP);
  327. $condition[] = array('groupbuy_endtime','>', TIMESTAMP);
  328. $groupbuy = model('groupbuy')->getGroupbuyList($condition);
  329. $update=true;
  330. foreach ($groupbuy as $val) {
  331. $flag=model('goods')->editGoods(array('goods_promotion_price' => $val['groupbuy_price'], 'goods_promotion_type' => 1), array('goods_commonid' => $val['goods_commonid']));
  332. if(!$flag){
  333. $update=false;
  334. }
  335. }
  336. if (!$update) {
  337. return ds_callback(false);
  338. }
  339. return ds_callback(true);
  340. }
  341. /**
  342. * 抢购过期
  343. *
  344. * @param int $goods_commonid
  345. */
  346. public function editExpireGroupbuy($goods_commonid) {
  347. $condition = array(array('goods_commonid','=', $goods_commonid));
  348. //抢购活动过期
  349. $update = model('groupbuy')->editExpireGroupbuy($condition);
  350. if (!$update) {
  351. return ds_callback(false);
  352. }
  353. return ds_callback(true);
  354. }
  355. /**
  356. * 秒杀过期
  357. *
  358. * @param int $xianshi_id
  359. */
  360. public function editExpireXianshi($xianshi_id) {
  361. $condition = array(array('xianshi_id','=', $xianshi_id));
  362. //秒杀过期
  363. $update = model('pxianshi')->editExpireXianshi($condition);
  364. if (!$update) {
  365. return ds_callback(false);
  366. }
  367. return ds_callback(true);
  368. }
  369. /**
  370. * 批发过期
  371. *
  372. * @param int $wholesale_id
  373. */
  374. public function editExpireWholesale($wholesale_id) {
  375. $condition = array(array('wholesale_id','=', $wholesale_id));
  376. //秒杀过期
  377. $update = model('wholesale')->editExpireWholesale($condition);
  378. if (!$update) {
  379. return ds_callback(false);
  380. }
  381. return ds_callback(true);
  382. }
  383. /**
  384. * 更新使用的平台代金券状态
  385. * @param $input_voucher_list
  386. * @throws Exception
  387. */
  388. public function editMallVoucherState($mallvoucher_info)
  389. {
  390. $mallvoucheruser_model = model('mallvouchertemplate');
  391. $update = $mallvoucheruser_model->editMallVoucherUser(array('mallvoucheruser_state' => $mallvoucher_info['mallvoucheruser_state']), array('mallvoucheruser_id' => $mallvoucher_info['mallvoucheruser_id']), $mallvoucher_info['mallvoucheruser_ownerid']);
  392. return ds_callback(true);
  393. }
  394. }