ApigoodsController.class.php 59 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889
  1. <?php
  2. // $Id:$
  3. /**
  4. * lionfish 商城系统
  5. *
  6. * ==========================================================================
  7. * @link http://www.liofis.com/
  8. * @copyright Copyright (c) 2015 liofis.com.
  9. * @license http://www.liofis.com/license.html License
  10. * ==========================================================================
  11. *
  12. * @author fish
  13. *
  14. */
  15. namespace Home\Controller;
  16. class ApigoodsController extends CommonController {
  17. protected function _initialize() {
  18. parent::_initialize();
  19. $this->cur_page = 'apigoods';
  20. }
  21. public function get_goods_option_data()
  22. {
  23. $id = I('get.id',28);
  24. $token = I('get.token');
  25. $sku_str = I('get.sku_str','45_53');
  26. //45_53
  27. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  28. $member_id = $weprogram_token['member_id'];
  29. $goods_model = D('Home/Goods');
  30. $goods_option_mult_value = M('goods_option_mult_value')->where(array(
  31. 'goods_id' => $id
  32. ))->order('id asc')->select();
  33. $goods_option_mult_value_ref = array();
  34. foreach ($goods_option_mult_value as $key => $val) {
  35. $val['image'] = C('SITE_URL') . resize($val['image'], 200, 200);
  36. $goods_option_mult_value[$key] = $val;
  37. $goods_option_mult_value_ref[$val['rela_goodsoption_valueid']] = $val;
  38. }
  39. $need_data = array();
  40. $level_info = $goods_model->get_member_level_info($member_id, $id);
  41. $member_disc = 100;
  42. if( !empty($level_info) )
  43. {
  44. $member_disc = $level_info['member_discount'];
  45. }
  46. $max_member_level = M('member_level')->order('level desc')->find();
  47. /**
  48. $max_member_level = M('member_level')->order('level desc')->find();
  49. $goods[0]['memberprice'] = round( ($goods[0]['danprice'] * $member_disc) / 100 ,2);
  50. $max_get_money = round( ($goods[0]['danprice'] * (100 - $max_member_level['discount']) ) / 100 ,2);
  51. if(!empty($pin_info))
  52. {
  53. $pin_info['member_pin_price'] = round( ($pin_info['pin_price'] * $member_disc) / 100 ,2);
  54. $max_get_money = round( ($pin_info['pin_price'] * (100 - $max_member_level['discount']) ) / 100 ,2);
  55. }
  56. **/
  57. $goods_option_mult_value_ref[$sku_str]['member_pin_price'] = round( ($goods_option_mult_value_ref[$sku_str]['pin_price'] * $member_disc) / 100 ,2);
  58. $goods_option_mult_value_ref[$sku_str]['memberprice'] = round( ($goods_option_mult_value_ref[$sku_str]['dan_price'] * $member_disc) / 100 ,2);
  59. $goods_option_mult_value_ref[$sku_str]['max_member_pin_price'] = 0;
  60. $goods_option_mult_value_ref[$sku_str]['max_memberprice'] = 0;
  61. if( !empty($max_member_level) )
  62. {
  63. $goods_option_mult_value_ref[$sku_str]['max_member_pin_price'] = round( ($goods_option_mult_value_ref[$sku_str]['pin_price'] * (100 - $max_member_level['discount']) ) / 100 ,2);
  64. $goods_option_mult_value_ref[$sku_str]['max_memberprice'] = round( ($goods_option_mult_value_ref[$sku_str]['dan_price'] * (100 - $max_member_level['discount']) ) / 100 ,2);
  65. }
  66. $need_data['value'] = $goods_option_mult_value_ref[$sku_str];
  67. echo json_encode( array('code' =>0 , 'data' =>$need_data ) );
  68. die();
  69. }
  70. public function seller_info2()
  71. {
  72. $seller_id = I('get.id');
  73. $seller_info = M('seller')->field('s_true_name,s_logo')->where( array('s_id' => $seller_id) )->find();
  74. $seller_info['s_logo'] = C('SITE_URL').'Uploads/image/'.$seller_info['s_logo'];
  75. $seller_model = D('Home/Seller');
  76. $seller_count = $seller_model->getStoreSellerCount($seller_id);
  77. $goods_count = M('goods')->where( array('store_id' => $seller_id) )->count();
  78. $store_class_list = M('store_bind_class')->where( array('seller_id' => $seller_id) )->order('bid asc')->select();
  79. $store_class_ids = array();
  80. foreach($store_class_list as $class_val)
  81. {
  82. $store_class_ids[] = $class_val['class_1'];
  83. }
  84. $category_list = array();
  85. if( !empty($store_class_ids) )
  86. {
  87. $category_list = M('goods_category')->field('id,name')->where( array('id' => array('in', $store_class_ids) ) )->select();
  88. }
  89. $seller_info['seller_count'] = $seller_count;
  90. $seller_info['goods_count'] = $goods_count;
  91. $need_data = array();
  92. $need_data['seller_info'] = $seller_info;
  93. $need_data['category_list'] = $category_list;
  94. echo json_encode( array('code' => 0 , 'data' => $need_data) );
  95. die();
  96. }
  97. public function search()
  98. {
  99. /**
  100. C('SITE_URLS').resize($val['fan_image'], 220, 220)
  101. **/
  102. $parent_list = M('goods_category')->where( array('pid' =>0, 'is_search' =>1) )->order('c_sort_order desc,sort_order desc')->select();
  103. //logo
  104. foreach($parent_list as $key => $val)
  105. {
  106. if( !empty($val['logo']) )
  107. {
  108. $val['logo'] = C('SITE_URL').resize($val['logo'], 220, 220);
  109. }
  110. $child_list = M('goods_category')->where( array('pid' => $val['id'], 'is_search' =>1) )->order('c_sort_order desc,sort_order desc')->select();
  111. foreach($child_list as $kk => $vv)
  112. {
  113. if( !empty($vv['logo']) )
  114. {
  115. $vv['logo'] = C('SITE_URL').resize($vv['logo'], 220, 220);
  116. }
  117. $child_list[$kk] = $vv;
  118. }
  119. $val['child_list'] = $child_list;
  120. $parent_list[$key] = $val;
  121. }
  122. echo json_encode( array('code' => 0, 'data' => $parent_list) );
  123. die();
  124. //$this->parent_list = $parent_list;
  125. }
  126. /**
  127. 获取积分兑换商品
  128. **/
  129. public function get_integral_goods()
  130. {
  131. $goods_model = D('Home/Goods');
  132. $pre_page = 10;
  133. $page = I('get.page',1);
  134. $condition = array('type' => 'integral', 'status'=>1,'quantity' =>array('gt',0) );
  135. $offset = ($page -1) * $pre_page;
  136. $list = M('goods')->where($condition)->order('seller_count+virtual_count desc,goods_id asc')->limit($offset,$pre_page)->select();
  137. if(!empty($list)) {
  138. foreach($list as $key => $v){
  139. $goods_price_arr = $goods_model->get_goods_price($v['goods_id']);
  140. $list[$key]['pinprice'] = $goods_price_arr['price'];
  141. $list[$key]['image']=C('SITE_URL'). resize($v['image'], 400, 400);
  142. }
  143. }
  144. foreach($list as $key => $val)
  145. {
  146. $val['seller_count'] += $val['virtual_count'];
  147. $list[$key] = $val;
  148. }
  149. $integral_rules = C('integral_description');
  150. $qian=array("\r\n");
  151. $hou=array("@F@");
  152. $integral_rules_str = str_replace($qian,$hou,$integral_rules);
  153. $integral_rules_str = explode('@F@',$integral_rules_str);
  154. if( !empty($list) )
  155. {
  156. echo json_encode( array('code' => 0, 'data' => $list , 'integral_rules_str' => $integral_rules_str ) );
  157. die();
  158. } else {
  159. echo json_encode( array('code' => 1 , 'integral_rules_str' => $integral_rules_str) );
  160. die();
  161. }
  162. }
  163. public function get_category_goods()
  164. {
  165. $goods_model = D('Home/Goods');
  166. $pre_page = 10;
  167. $page = I('get.page',1);
  168. $id = I('get.id',0);
  169. $goods_ids_arr = M('goods_to_category')->where("class_id1 ={$id} or class_id2 ={$id} or class_id3 = {$id} ")->field('goods_id')->select();
  170. $ids_arr = array();
  171. foreach($goods_ids_arr as $val){
  172. $ids_arr[] = $val['goods_id'];
  173. }
  174. $ids_str = implode(',',$ids_arr);
  175. //lottery pintuan oneyuan normal
  176. $condition = array('goods_id' => array('in',$ids_str),'type' => array('in', array('normal','oneyuan','lottery','pintuan') ) , 'status'=>1,'quantity' =>array('gt',0) );
  177. $offset = ($page -1) * $pre_page;
  178. $list = M('goods')->where($condition)->order('seller_count+virtual_count desc,goods_id asc')->limit($offset,$pre_page)->select();
  179. if(!empty($list)) {
  180. foreach($list as $key => $v){
  181. $goods_price_arr = $goods_model->get_goods_price($v['goods_id']);
  182. $list[$key]['pinprice'] = $goods_price_arr['price'];
  183. //
  184. //$goods[0]['danprice'] = $goods_price_arr['danprice'];
  185. //$price_dol = explode('.', $goods_price_arr['pin_price']);
  186. $list[$key]['image']=C('SITE_URL'). resize($v['image'], 400, 400);
  187. }
  188. }
  189. foreach($list as $key => $val)
  190. {
  191. $val['seller_count'] += $val['virtual_count'];
  192. $list[$key] = $val;
  193. }
  194. if( !empty($list) )
  195. {
  196. echo json_encode( array('code' => 0, 'data' => $list ) );
  197. die();
  198. } else {
  199. echo json_encode( array('code' => 1) );
  200. die();
  201. }
  202. }
  203. /**
  204. 我的助力
  205. **/
  206. public function assist_free_coupon_me()
  207. {
  208. $token = I('get.token');
  209. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  210. $member_id = $weprogram_token['member_id'];
  211. $free_ad_list = M('plugins_slider')->where( array('type' => 'free_ad') )->order('slider_id desc')->find();
  212. $per_page = 10;
  213. $page = I('get.page',1);
  214. $offset = ($page - 1) * $per_page;
  215. $sql = 'select z.id,z.need_person,z.total_money as pinprice,z.deal_money,z.end_time,z.state,g.goods_id,g.name,g.quantity,g.price,g.danprice,g.image,g.fan_image,g.store_id,g.seller_count,g.virtual_count
  216. from '.C('DB_PREFIX').'goods as g ,'.C('DB_PREFIX').'bargain_order as z
  217. where z.member_id = '.$member_id.' and z.goods_id = g.goods_id order by z.end_time desc limit '.$offset.','.$per_page;
  218. $list = M()->query($sql);
  219. foreach($list as $key => $v){
  220. //$has_zan_count = M('zan_order_detail')->where( array('zan_order_id' => $v['id']) )->count();
  221. //$list[$key]['has_zan_count'] = $has_zan_count;
  222. if($v['state'] == 0 && $v['end_time'] < time())
  223. {
  224. $list[$key]['state'] = 2;
  225. }
  226. $list[$key]['seller_count'] += $v['virtual_count'];
  227. $list[$key]['image']= C('SITE_URL').resize($v['image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  228. }
  229. if(!empty($list))
  230. {
  231. echo json_encode( array('code' => 0, 'data' => $list ) );
  232. die();
  233. }else{
  234. echo json_encode( array('code' => 1) );
  235. die();
  236. }
  237. }
  238. /**
  239. 砍价详情
  240. **/
  241. public function bargain_detail()
  242. {
  243. $is_me = false;
  244. $has_kan = false;
  245. $token = I('get.token');
  246. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  247. $member_id = $weprogram_token['member_id'];
  248. $id = I('get.id');
  249. $bargain_info = M('bargain_order')->where( array('id' => $id) )->find();
  250. $bargain_info['already_money'] = round($bargain_info['total_money']-$bargain_info['deal_money'],2);
  251. if($bargain_info['member_id'] == $member_id)
  252. {
  253. $is_me = true;
  254. }
  255. if($bargain_info['state'] != 1 && $bargain_info['end_time'] > time() )
  256. {
  257. $bargain_info['state'] = 3;
  258. }
  259. $has_kan_count = M('bargain_order_detail')->where( array('member_id' => $member_id,'bargain_order_id' => $id) )->count();
  260. if($has_kan_count >0)
  261. {
  262. $has_kan = true;
  263. }
  264. //end_time
  265. $now_time = time();
  266. $goods_info = M('goods')->field('name,price,seller_count,virtual_count,image,fan_image')->where( array('goods_id' => $bargain_info['goods_id']) )->find();
  267. $goods_info['image'] = C('SITE_URL').resize($goods_info['image'],300,300);
  268. //fan_image
  269. if(!empty($goods_info['fan_image']))
  270. {
  271. $goods_info['image'] = C('SITE_URL').resize($goods_info['fan_image'],300,300);
  272. }
  273. $goods_info['seller_count'] += $goods_info['virtual_count'];
  274. $kan_order_list = M('bargain_order_detail')->where( array('bargain_order_id' =>$id) )->order('addtime desc')->limit(15)->select();
  275. $need_data = array();
  276. $need_data['kan_order_list'] = $kan_order_list;
  277. $need_data['bargain_info'] = $bargain_info;
  278. $need_data['goods_info'] = $goods_info;
  279. $need_data['is_me'] = $is_me;
  280. $need_data['has_kan'] = $has_kan;
  281. //$this->kan_order_list = $kan_order_list;
  282. //$this->bargain_info = $bargain_info;
  283. //$this->goods_info = $goods_info;
  284. //$this->is_me = $is_me;
  285. //$this->has_kan = $has_kan;
  286. //member_id
  287. $member_info = M('member')->where( array('member_id' => $bargain_info['member_id']) )->find();
  288. $need_data['member_info'] = $member_info;
  289. //$this->member_info = $member_info;
  290. $kan_description = C('kan_description');
  291. $qian=array("\r\n");
  292. $hou=array("@F@");
  293. $kan_description_str = str_replace($qian,$hou,$kan_description);
  294. $kan_description_str = explode('@F@',$kan_description_str);
  295. //$this->kan_description_str = $kan_description_str;
  296. //$this->kan_description_str = $kan_description_str;
  297. $need_data['kan_description_str'] = $kan_description_str;
  298. $kan_rules = C('kan_rules');
  299. $qian=array("\r\n");
  300. $hou=array("@F@");
  301. $kan_rules_str = str_replace($qian,$hou,$kan_rules);
  302. $kan_rules_str = explode('@F@',$kan_rules_str);
  303. //$this->kan_rules_str = $kan_rules_str;
  304. $need_data['kan_rules_str'] = $kan_rules_str;
  305. $kan_person_count = C('kan_person_count');
  306. //$this->kan_person_count = $kan_person_count;
  307. $need_data['kan_person_count'] = $kan_person_count;
  308. //随机商品 8 个
  309. $sql='SELECT goods_id,image,fan_image,price,danprice,name,seller_count,virtual_count FROM '.C('DB_PREFIX').'goods WHERE status=1 and type="normal" and quantity >0 ORDER BY rand() LIMIT 0,8';
  310. $list=M()->query($sql);
  311. $hashids = new \Lib\Hashids(C('PWD_KEY'), C('URL_ID'));
  312. foreach ($list as $k => $v) {
  313. $list[$k]['seller_count'] += $list[$k]['virtual_count'];
  314. $list[$k]['image']= C('SITE_URL').resize($v['image'], C('goods_related_thumb_width'), C('goods_related_thumb_height'));
  315. if(!empty($v['fan_image'])){
  316. $list[$k]['image']= C('SITE_URL').resize($v['fan_image'], C('goods_related_thumb_width'), C('goods_related_thumb_height'));
  317. }else {
  318. $list[$k]['image']= C('SITE_URL').resize($v['image'], C('goods_related_thumb_width'), C('goods_related_thumb_height'));
  319. }
  320. }
  321. //$this->related_goods=$list;
  322. $need_data['related_goods'] = $list;
  323. $bargain_order = M('bargain_order')->where( array('id' => $id) )->find();
  324. $goods_id = $bargain_order['goods_id'];
  325. $goods_info = M('goods')->where( array('goods_id' => $goods_id) )->find();
  326. //"我正在参加拼多多官方砍价,砍到0元就可以免费拿啦,帮我砍一下吧"
  327. $desc = "我正在参加".C('SITE_NAME')."砍价,砍到0元就可以免费拿啦,帮我砍一下吧";
  328. //$this->share_logo = C('SITE_URL').resize($goods_info['image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  329. $need_data['share_logo'] = C('SITE_URL').resize($goods_info['image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  330. $share_logo = '';
  331. if(!empty($goods_info['fan_image'])){
  332. $share_logo = C('SITE_URL').resize($goods_info['fan_image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  333. }else {
  334. $share_logo = C('SITE_URL').resize($goods_info['image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  335. }
  336. if(!empty($goods_description['water_image']))
  337. {
  338. $share_logo = C('SITE_URL').'/Uploads/image/'.$goods_description['water_image'];
  339. }
  340. $need_data['share_logo'] = $share_logo;
  341. //Subject/assist_bargain_coupon_detail/id/10.html kan_rules_str
  342. $need_data['indexsharetitle'] = '['.C('SITE_NAME')."]我在砍价免费拿".$goods_info['name'].",帮我砍价,0元拿回家!";
  343. $need_data['url'] = C('SITE_URL')."/index.php?s=/Subject/assist_bargain_coupon_detail/id/{$id}/rmid/{$hash_member_id}";
  344. $need_data['indexsharesummary'] = $desc;
  345. $need_data['cur_time'] = time();
  346. echo json_encode( array('code' => 0, 'data' => $need_data) );
  347. die();
  348. }
  349. /**
  350. 分享成功后,砍
  351. **/
  352. public function share_success_kan()
  353. {
  354. $id = I('get.id');
  355. $token = I('get.token');
  356. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  357. $member_id = $weprogram_token['member_id'];
  358. //$member_id = session('user_auth.uid');
  359. $bargain_order = M('bargain_order')->where( array('id' => $id) )->find();
  360. //is_share
  361. if($bargain_order['is_share'] == 0 && $member_id == $bargain_order['member_id'] )
  362. {
  363. $order_detail = M('bargain_order_detail')->where( array('member_id' => $member_id, 'bargain_order_id' => $id) )->find();
  364. $old = $order_detail['kan_money'];
  365. $state = $this->_bang_kan_order($id,$member_id,true,true );
  366. $bargain_order = M('bargain_order')->where( array('id' => $id) )->find();
  367. $bargain_order['kan_money'] = round($bargain_order['total_money'] - $bargain_order['deal_money'],2);
  368. $bargain_order['deal_money'] = round($bargain_order['deal_money'],2);
  369. $bargain_order['already_money'] = round($bargain_order['total_money']-$bargain_order['deal_money'],2);
  370. if($bargain_order['state'] != 1 && $bargain_order['end_time'] > time() )
  371. {
  372. $bargain_order['state'] = 3;
  373. }
  374. //{"code":0,"li_html":"","order_detail":{"id":"45","member_id":"456","kan_money":0.28,"bargain_order_id":"26","addtime":"1531465747","is_sleft":"1","avatar":"https:\/\/wx.qlogo.cn\/mmopen\/vi_32\/DYAIOgq83eqiajGaVicwDKXSNwdia7lyovicLib6cMDWNdR9Ce6sA9icfqibYbPYbXSq8x8uMB8zArckA67icRzSjDsSFA\/132","nickname":"\u4f59\u5efa"},"bargain_order":{"total_money":"5.00","deal_money":3.37,"kan_money":1.63,"already_money":1.63}}
  375. $order_detail = M('bargain_order_detail')->where( array('member_id' => $member_id, 'bargain_order_id' => $id) )->find();
  376. $order_detail['kan_money'] = round($order_detail['kan_money'] - $old, 2);
  377. $li_html = "";
  378. $kan_order_list = M('bargain_order_detail')->where( array('bargain_order_id' =>$id) )->order('addtime desc')->limit(15)->select();
  379. echo json_encode( array('code' => 0,'li_html' => $li_html,'kan_order_list' => $kan_order_list, 'order_detail' => $order_detail, 'bargain_order' => $bargain_order) );
  380. die();
  381. }else{
  382. echo json_encode( array('code' => 1) );
  383. die();
  384. }
  385. }
  386. /**
  387. 帮忙别人砍价
  388. **/
  389. public function kan_others_bargain()
  390. {
  391. $id = I('get.id',0);
  392. $token = I('get.token');
  393. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  394. $member_id = $weprogram_token['member_id'];
  395. if(empty($member_id))
  396. {
  397. echo json_encode( array('code' => 5, 'msg' => '请先登录') );
  398. die();
  399. }
  400. $state = $this->_bang_kan_order($id,$member_id,false);
  401. //1;//已经帮忙砍过
  402. //2; //活动已经成功,或者已经结束
  403. //3;//今天已经不能再帮别人砍价
  404. //4 砍价失败
  405. //0成功
  406. if($state > 0)
  407. {
  408. $msg = '';
  409. switch($state)
  410. {
  411. case 1 :
  412. $msg = '已经帮忙砍过了';
  413. break;
  414. case 2:
  415. $msg = '活动已经结束';
  416. break;
  417. case 3:
  418. $msg = '今天已经不能再帮别人砍价了';
  419. break;
  420. case 4:
  421. $msg = '砍价失败';
  422. break;
  423. }
  424. echo json_encode( array('code' => $state, 'msg' => $msg) );
  425. die();
  426. }else{
  427. $bargain_order = M('bargain_order')->field('total_money,deal_money')->where( array('id' => $id) )->find();
  428. $bargain_order['kan_money'] = round($bargain_order['total_money'] - $bargain_order['deal_money'],2);
  429. $bargain_order['deal_money'] = round($bargain_order['deal_money'],2);
  430. $bargain_order['already_money'] = round($bargain_order['total_money']-$bargain_order['deal_money'],2);
  431. $bargain_order['state'] = 3;
  432. $order_detail = M('bargain_order_detail')->where( array('member_id' => $member_id, 'bargain_order_id' => $id) )->find();
  433. $order_detail['kan_money'] = round($order_detail['kan_money'], 2);
  434. $li_html = "";
  435. echo json_encode( array('code' => 0,'li_html' => $li_html, 'order_detail' => $order_detail, 'bargain_order' => $bargain_order) );
  436. die();
  437. }
  438. }
  439. public function get_user_goods_qrcode2()
  440. {
  441. $token = I('get.token');
  442. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  443. $member_id = $weprogram_token['member_id'];
  444. $goods_id = I('get.goods_id');
  445. $goods_share_image = M('goods_share_image')->where( array('member_id' =>$member_id,'goods_id' => $goods_id ) )->find();
  446. if( !empty($goods_share_image) )
  447. {
  448. $result = array('code' => 0, 'image_path' => $goods_share_image['image_path']);
  449. echo json_encode($result);
  450. die();
  451. }else {
  452. $goods_model = D('Home/Goods');
  453. $goods_description = M('goods_description')->where( array('goods_id' =>$goods_id) )->find();
  454. if( empty($goods_description['wepro_qrcode_image']) || true)
  455. {
  456. $this->get_weshare_image($goods_id);
  457. $goods_description = M('goods_description')->where( array('goods_id' =>$goods_id) )->find();
  458. }
  459. $rocede_path = $goods_model->_get_goods_user_wxqrcode($goods_id,$member_id);
  460. $res = $goods_model->_get_compare_qrcode_bgimg($goods_description['wepro_qrcode_image'], $rocede_path);
  461. $data = array();
  462. $data['member_id'] = $member_id;
  463. $data['goods_id'] = $goods_id;
  464. $data['image_path'] = $res['full_path'];
  465. $data['addtime'] = time();
  466. M('goods_share_image')->add($data);
  467. $result = array('code' => 0, 'image_path' => $res['full_path']);
  468. echo json_encode($result);
  469. die();
  470. }
  471. }
  472. private function get_weshare_image($goods_id)
  473. {
  474. //400*400 fan_image
  475. //get_goods_price($goods_id)
  476. $goods_info = M('goods')->where( array('goods_id' => $goods_id) )->find();
  477. $goods_img = ROOT_PATH.'Uploads/image/'.$goods_info['image'];
  478. if( !empty($goods_info['fan_image']) )
  479. {
  480. $goods_img = ROOT_PATH.'Uploads/image/'.$goods_info['fan_image'];
  481. }
  482. $goods_model = D('Home/Goods');
  483. $goods_price = $goods_model->get_goods_price($goods_id);
  484. $goods_price['market_price'] = $goods_info['price'];
  485. //price
  486. $goods_title = $goods_info['name'];
  487. $need_img = $goods_model->_get_compare_zan_img($goods_img,$goods_title,$goods_price);
  488. //贴上二维码图
  489. //$rocede_path = $goods_model->_get_goods_user_wxqrcode($goods_id,$member_id);
  490. //$res = $goods_model->_get_compare_qrcode_bgimg($need_img['need_path'], $rocede_path);
  491. M('goods_description')->where( array('goods_id' =>$goods_id) )->save( array('wepro_qrcode_image' =>$need_img['need_path']) );
  492. return true;
  493. }
  494. /**
  495. 砍价开始
  496. **/
  497. public function get_user_goods_qrcode()
  498. {
  499. $token = I('get.token');
  500. //user_favgoods
  501. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  502. $member_id = $weprogram_token['member_id'];
  503. $data_json = file_get_contents('php://input');
  504. $data = json_decode($data_json, true);
  505. if(empty($data))
  506. {
  507. $this->get_user_goods_qrcode2();
  508. die();
  509. }
  510. $address_id = $data['address_id'];
  511. $goods_id = $data['goods_id'];
  512. $need_optionc = $data['sku_str'];
  513. $goods_model = D('Home/Goods');
  514. //寻找现在是否有未完成的订单,如果有的话,那么就不要继续生成了
  515. $goods_info = M('goods')->field('image,name')->where( array('goods_id' => $goods_id) )->find();
  516. $bargain_goods_info = M('bargain_goods')->where( array('goods_id' => $goods_id) )->find();
  517. //pin_count,pin_hour,
  518. //pin_price
  519. $now_time = time();
  520. $old_zan_order = M('bargain_order')->where("member_id={$member_id} and goods_id={$goods_id} and state =0 and begin_time < {$now_time} and end_time > {$now_time}")->find();
  521. if( !empty($old_zan_order) )
  522. {
  523. //一个会员当前一个商品 只能发出去一个二维码
  524. echo json_encode( array('code' => 0, 'id' => $old_zan_order['id']) );
  525. die();
  526. }
  527. //zan_order
  528. $zan_order_data = array();
  529. $zan_order_data['member_id'] = $member_id;
  530. $zan_order_data['goods_id'] = $goods_id;
  531. $zan_order_data['sku_str'] = $need_optionc;
  532. $zan_order_data['state'] = 0;
  533. $price = $bargain_goods_info['bargain_price'];
  534. //goods_option_mult_value
  535. if( !empty($need_optionc) )
  536. {
  537. $goods_option_mult_value = M('goods_option_mult_value')->where( array('rela_goodsoption_valueid' => $need_optionc,'goods_id' =>$goods_id) )->find();
  538. if(!empty($goods_option_mult_value))
  539. {
  540. $price = $goods_option_mult_value['pin_price'];
  541. }
  542. }
  543. $zan_order_data['need_person'] = empty($bargain_goods_info['bargain_count']) ? 1: $bargain_goods_info['bargain_count'];
  544. $zan_order_data['total_person'] = empty($bargain_goods_info['bargain_count']) ? 1: $bargain_goods_info['bargain_count'];
  545. $zan_order_data['deal_money'] = $price;
  546. $zan_order_data['total_money'] = $price;
  547. $zan_order_data['begin_time'] = $now_time;
  548. $zan_order_data['end_time'] = $now_time + 3600 * $bargain_goods_info['hour'];
  549. $zan_order_data['add_time'] = time();
  550. $zan_order_data['order_id'] = 0;
  551. $zan_order_data['address_id'] = $address_id;
  552. $zan_order_id = M('bargain_order')->add($zan_order_data);
  553. //bargain_order_detail
  554. //member_id kan_money bargain_order_id addtime avatar nickname
  555. $state = $this->_bang_kan_order($zan_order_id,$member_id,true);
  556. echo json_encode( array('code' =>0, 'id' => $zan_order_id) );
  557. die();
  558. }
  559. /**
  560. 开始砍价表
  561. **/
  562. private function _bang_kan_order($bargain_order_id,$member_id,$is_self = false, $just_update = false )
  563. {
  564. //检测是否砍过了
  565. $has_order = M('bargain_order_detail')->where( array('member_id'=>$member_id, 'bargain_order_id' =>$bargain_order_id) )->find();
  566. if(!empty($has_order) && !$just_update)
  567. {
  568. return 1;//已经帮忙砍过
  569. }
  570. //活动是否正常
  571. $bargain_order_info = M('bargain_order')->where( array('id' => $bargain_order_id) )->find();
  572. if( $bargain_order_info['state'] != 0 )
  573. {
  574. return 2; //活动已经成功,或者已经结束
  575. }
  576. $now_time = strtotime( date('Y-m-d').' 00:00:00' );
  577. $end_time = $now_time + 86400;
  578. $kan_person_count = C('kan_person_count');
  579. if(!$is_self)
  580. {
  581. //检测今天帮别人砍价的次数
  582. //addtime
  583. //bargain_order_detail
  584. $kan_count = M('bargain_order_detail')->where( array('addtime' =>array('between', array($now_time,$end_time) ), 'member_id'=>$member_id,'is_sleft' =>0 ) )->count();
  585. //$condition['id'] = array(between,array('1','8'));
  586. if($kan_person_count >0 && $kan_count >= $kan_person_count)
  587. {
  588. return 3;//今天已经不能再帮别人砍价
  589. }
  590. }
  591. //开始砍价流程
  592. if($bargain_order_info['need_person'] > 0)
  593. {
  594. $per_money = $bargain_order_info['deal_money'] / $bargain_order_info['need_person'];
  595. if($bargain_order_info['need_person'] >2)
  596. {
  597. $per_money = $per_money * 2;
  598. }
  599. }else{
  600. $per_money = round($bargain_order_info['deal_money'] ,2);
  601. }
  602. $min = 1;
  603. $max = $per_money * 100;
  604. $ran_money = round( mt_rand($min,$max) / 100 , 2) ;
  605. if($bargain_order_info['need_person'] < 0)
  606. {
  607. $win_rd = mt_rand(1,9);
  608. if($win_rd >=5)
  609. {
  610. $ran_money = $bargain_order_info['deal_money'];
  611. }
  612. }
  613. $member_info = M('member')->field('uname,avatar,we_openid')->where( array('member_id' => $member_id) )->find();
  614. //TODO 插入砍价详细订单
  615. if($just_update)
  616. {
  617. $res = M('bargain_order_detail')->where( array('bargain_order_id' => $bargain_order_id,'member_id' =>$member_id ) )->setInc('kan_money',$ran_money);
  618. //setInc
  619. M('bargain_order')->where( array('id' => $bargain_order_id) )->save( array('is_share' => 1) );
  620. } else{
  621. $ins_data = array();
  622. $ins_data['member_id'] = $member_id;
  623. $ins_data['kan_money'] = $ran_money;
  624. $ins_data['bargain_order_id'] = $bargain_order_id;
  625. $ins_data['addtime'] = time();
  626. $ins_data['is_sleft'] = $is_self ? 1: 0;
  627. $ins_data['avatar'] = $member_info['avatar'];
  628. $ins_data['nickname'] = $member_info['uname'];
  629. $res = M('bargain_order_detail')->add($ins_data);
  630. }
  631. if($res)
  632. {
  633. if(!$just_update)
  634. {
  635. M('bargain_order')->where( array('id' => $bargain_order_id) )->setDec('need_person',1);
  636. }
  637. M('bargain_order')->where( array('id' => $bargain_order_id) )->setDec('deal_money',$ran_money);
  638. $bargain_order_info = M('bargain_order')->where( array('id' => $bargain_order_id) )->find();
  639. if($bargain_order_info['deal_money'] <=0 )
  640. {
  641. //TODO send msg
  642. $model = D('Home/Goods');
  643. $order_id = $model->_zan_bargain_order($bargain_order_id);
  644. //M('zan_order')->where( array('id' => $zan_order_id) )->save( array('order_id' => $order_id,'state' => 1) );
  645. M('bargain_order')->where( array('id' => $bargain_order_id) )->save( array('order_id' => $order_id,'state' => 1) );
  646. //add order
  647. $or_member_info = M('member')->field('openid,we_openid')->where( array('member_id' => $bargain_order_info['member_id']) )->find();
  648. $or_open_id = $or_member_info['we_openid'];
  649. //$or_open_id = 'o0n_HwcGIfwf5b8PN8-gmNfsJBLA';
  650. $goods_info = M('goods')->field('name')->where( array('goods_id' => $bargain_order_info['goods_id']) )->find();
  651. //转小程序模板消息
  652. /**
  653. 5zZUGZhK46PzcJeAIidv_cdsJ6OaCCXe0PtGen0yvOA
  654. 复制
  655. 标题
  656. 砍价成功通知
  657. 关键词
  658. 商品名称
  659. {{keyword1.DATA}}
  660. 砍价状态
  661. {{keyword2.DATA}}
  662. 备注
  663. {{keyword3.DATA}}
  664. **/
  665. $first_title = "您参与:".$goods_info['name'];
  666. $keyword1 = '您的活动已砍价成功';
  667. $url = C('SITE_URL')."/index.php?s=/Order/info/id/{$order_id}.html";
  668. $template_data['keyword1'] = array('value' => $first_title, 'color' => '#030303');
  669. $template_data['keyword2'] = array('value' => '砍价成功', 'color' => '#030303');
  670. $template_data['keyword3'] = array('value' => '当前活动已成功,等待发货', 'color' => '#030303');
  671. $pay_order_msg_info = M('config')->where( array('name' => 'weprogram_template_kan_msg') )->find();
  672. $template_id = $pay_order_msg_info['value'];
  673. $pagepath = 'pages/order/order?id='.$order_id;
  674. $member_formid_info = M('member_formid')->where( array('member_id' => $bargain_order_info['member_id'], 'formid' =>array('neq',''),'state' => 0) )->order('id desc')->find();
  675. if( !empty($member_formid_info) )
  676. {
  677. $rs = send_wxtemplate_msg($template_data,$url,$pagepath,$or_open_id,$template_id,$member_formid_info['formid']);
  678. //更新
  679. M('member_formid')->where( array('id' => $member_formid_info['id']) )->save( array('state' => 1) );
  680. }
  681. }
  682. return 0;
  683. }else{
  684. return 4;//砍价失败
  685. }
  686. }
  687. public function get_category_keyword_goods()
  688. {
  689. $pre_page = 10;
  690. $page = I('get.page',1);
  691. $keyword = I('get.keyword','');
  692. $sort = I('get.sort', 'desc');
  693. $cur_type = I('get.cur_type','default');//default seller_count price
  694. $cur_price_index = I('get.cur_price_index',0);
  695. $search_min_price = I('get.search_min_price',0);
  696. $search_max_price = I('get.search_max_price',0);
  697. $goods_model = D('Home/Goods');
  698. $condition = array('name' => array('like','%'.$keyword.'%'), 'status'=>1,'quantity' =>array('gt',0) );
  699. $condition['type'] = array('NEQ','assistance');//'normal';
  700. $orderby = "seller_count {$sort},goods_id {$sort}";
  701. if($cur_type == 'seller_count')
  702. {
  703. $orderby = "seller_count+virtual_count desc";
  704. }else if($cur_type == 'price'){
  705. $orderby = "danprice {$sort}";
  706. }
  707. if($cur_price_index > 0)
  708. {
  709. if($search_min_price > 0 && $search_max_price > 0)
  710. {
  711. //$sql['jobSalary'] = array('between','0,1000');
  712. $condition['danprice'] = array('between',"{$search_min_price},{$search_max_price}");
  713. }else if($search_min_price > 0)
  714. {
  715. //'quantity' =>array('gt',0)
  716. $condition['danprice'] = array('egt', $search_min_price);
  717. } else if($search_max_price > 0){
  718. $condition['danprice'] = array('elt', $search_max_price);
  719. }
  720. //$search_min_price = I('get.search_min_price');
  721. //$search_max_price = I('get.search_max_price');
  722. }
  723. //$condition['lock_type'] = 'normal';
  724. $offset = ($page -1) * $pre_page;
  725. $list = M('goods')->where($condition)->order($orderby)->limit($offset,$pre_page)->select();
  726. if(!empty($list)) {
  727. foreach($list as $key => $v){
  728. $goods_price_arr = $goods_model->get_goods_price($v['goods_id']);
  729. $list[$key]['pinprice'] = $goods_price_arr['price'];
  730. $list[$key]['image']=C('SITE_URL'). resize($v['image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  731. }
  732. }
  733. foreach($list as $key => $val)
  734. {
  735. $val['seller_count'] += $val['virtual_count'];
  736. $list[$key] = $val;
  737. }
  738. if( !empty($list) )
  739. {
  740. echo json_encode( array('code' => 0, 'data' => $list ) );
  741. die();
  742. } else {
  743. echo json_encode( array('code' => 1) );
  744. die();
  745. }
  746. }
  747. public function get_goods_fujin_tuan()
  748. {
  749. $id = I('get.id');
  750. $count = I('get.count',2);
  751. $pin_model = D('Home/Pin');
  752. //正在进行中的商品团
  753. $fujin_tuan = $pin_model->get_goods_pintuan($id,$count);
  754. $fujin_list = $fujin_tuan['list'];
  755. echo json_encode( array('code' => 0, 'cur_time' => time(), 'data' => $fujin_list) );
  756. die();
  757. //$this->fujin_tuan = $fujin_tuan;
  758. }
  759. public function upload_image(){
  760. $dir=I('get.dir','goods');
  761. $dir .= '/'.date('Y-m-d');
  762. //$this->del_old_image();
  763. $upload = new \Think\Upload();// 实例化上传类
  764. $image_dir=ROOT_PATH.'Uploads/image/'.$dir;
  765. RecursiveMkdir($image_dir);
  766. $upload->autoSub = false;
  767. $upload->maxSize = 3145728 ;// 设置附件上传大小
  768. $upload->exts = array('jpg', 'gif', 'png', 'jpeg');// 设置附件上传类型
  769. $upload->rootPath = $image_dir.'/';
  770. $info = $upload->upload();
  771. if(!$info) {
  772. $data['result'] = false;
  773. $this->ajaxReturn($data);
  774. }else{// 上传成功
  775. //{"image_thumb":"Uploads\/image\/cache\/goods\/2017-11-01\/59f9460eac183-100x100.jpg",
  776. //"image":"goods\/2017-11-01\/59f9460eac183.jpg"}
  777. $filename=$dir.'/'.$info['file']['savepath'].$info['file']['savename'];
  778. $data['image_thumb'] = C('SITE_URL').resize($filename, 300, 300);
  779. $data['image'] = C('SITE_URL').'Uploads/image/'.$filename;
  780. $data['image_o'] = $filename;
  781. $this->ajaxReturn($data);
  782. }
  783. }
  784. public function get_goods_simple() {
  785. $id = I('get.id');
  786. $goods_info = M('goods')->where( array('goods_id' => $id) )->find();
  787. $goods_info['image'] = C('SITE_URL') . resize($goods_info['image'], 400 , 400);
  788. if ($goods[0]['type'] == 'pintuan' || $goods[0]['type'] == 'lottery') {
  789. $pin_info = M('pin_goods')->where(array(
  790. 'goods_id' => $id
  791. ))->find();
  792. }
  793. $need_data = array();
  794. $need_data['goods_id'] = $id;
  795. $need_data['name'] = $goods_info['name'];
  796. $need_data['price'] = empty($pin_info) ? $goods_info['danprice'] : $pin_info['pin_price'];
  797. $need_data['image'] = $goods_info['image'];
  798. echo json_encode( array('code' =>0, 'data' => $need_data) );
  799. die();
  800. }
  801. public function get_goods_detail() {
  802. $id = I('get.id');
  803. $pin_id = I('get.pin_id', 0);
  804. $token = I('get.token');
  805. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  806. $member_id = $weprogram_token['member_id'];
  807. $need_data = array();
  808. $sql = "select g.*,gd.description,gd.is_untake_level,level_discount,gd.video_src,gd.video_size_width,gd.vedio_size_height,gd.is_video,gd.summary,gd.share_title,gd.activity_summary,gd.tag from " . C('DB_PREFIX') . "goods g," . C('DB_PREFIX') . "goods_description gd where g.goods_id=gd.goods_id and g.goods_id=" . $id;
  809. $goods = M()->query($sql);
  810. $pin_model = D('Home/Pin');
  811. $goods_model = D('Home/Goods');
  812. $qian = array(
  813. "/Uploads/image"
  814. );
  815. $c_site_url = str_replace('/dan','',C('SITE_URL'));
  816. $hou = array(
  817. $c_site_url . "/Uploads/image"
  818. );
  819. $goods[0]['video_src'] = C('SITE_URL')."Uploads/image/".$goods[0]['video_src'];
  820. $goods[0]['description'] = str_replace($qian, $hou, $goods[0]['description']);
  821. $goods[0]['description'] = htmlspecialchars_decode($goods[0]['description']);
  822. $qian = array(
  823. "\r\n"
  824. );
  825. $hou = array(
  826. "<br/>"
  827. );
  828. $goods[0]['summary'] = str_replace($qian, $hou, $goods[0]['summary']);
  829. $hou = array(
  830. "@EOF@"
  831. );
  832. //string(469) "活动时间:@EOF@1.参与活动人人有奖,一等奖为本商品(1 人),参与奖退款并赠送专属优惠券 。@EOF@2.只有参加拼团,而且拼团成功的用户,才有资格参与抽奖@EOF@3.活动结束后24小时内,从有资格抽奖的用户中,随机抽取中奖者 。@EOF@4.抽奖活动结束后,中奖商品3天内发货,参与奖专属优惠券3天内发放。@EOF@5.本活动真实有效,最终解释权归狮子鱼所有。"
  833. $goods[0]['activity_summary'] = str_replace($qian, $hou, $goods[0]['activity_summary']);
  834. $goods[0]['activity_summary'] = explode('@EOF@',$goods[0]['activity_summary']);
  835. //var_dump($goods[0]['activity_summary']);die();
  836. if (isset($goods)) {
  837. foreach ($goods as $k => $v) {
  838. $goods[$k]['image_thumb'] = C('SITE_URL') . resize($v['image'], 400, 400);
  839. }
  840. }
  841. $sql = "select image,is_video_click from " . C('DB_PREFIX') . "goods_image where goods_id=" . $id;
  842. $goods_image = M()->query($sql);
  843. if (isset($goods_image)) {
  844. foreach ($goods_image as $k => $v) {
  845. $goods_image[$k]['image_' . C('goods_thumb_width') . '_' . C('goods_thumb_height') ] = C('SITE_URL') . resize($v['image'], C('goods_thumb_width') , C('goods_thumb_height'));
  846. $goods_image[$k]['image'] = C('SITE_URL') . 'Uploads/image/' . $v['image'];
  847. }
  848. }
  849. $goods[0]['seller_count']+= $goods[0]['virtual_count'];
  850. $goods_price_arr = $goods_model->get_goods_price($id);
  851. $goods[0]['danprice'] = $goods_price_arr['danprice'];
  852. //danprice
  853. /** $need_data['goods_price_arr'] = $goods_price_arr; **/
  854. $price_dol = explode('.', $goods_price_arr['pin_price']);
  855. if (!empty($goods[0]['tag'])) $goods[0]['tag'] = explode(',', $goods[0]['tag']);
  856. $goods[0]['fan_image'] = C('SITE_URL') . 'Uploads/image/' . $goods[0]['fan_image'];
  857. $goods[0]['image'] = C('SITE_URL') . 'Uploads/image/' . $goods[0]['image'];
  858. unset($goods[0]['lock_type']);
  859. unset($goods[0]['lock_price']);
  860. unset($goods[0]['points']);
  861. unset($goods[0]['transport_id']);
  862. unset($goods[0]['express_list']);
  863. unset($goods[0]['is_free_in']);
  864. unset($goods[0]['pick_up']);
  865. unset($goods[0]['pick_just']);
  866. unset($goods[0]['shipping']);
  867. unset($goods[0]['stock_status_id']);
  868. unset($goods[0]['index_sort']);
  869. unset($goods[0]['is_index_show']);
  870. unset($goods[0]['sku']);
  871. unset($goods[0]['model']);
  872. $pin_info = array();
  873. $token = I('get.token');
  874. //user_favgoods
  875. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  876. $member_id = $weprogram_token['member_id'];
  877. $user_favgoods = M('user_favgoods')->where( array('member_id' => $member_id,'goods_id' =>$id) )->find();
  878. if( !empty($user_favgoods) )
  879. {
  880. $goods[0]['favgoods'] = 2;
  881. }else{
  882. $goods[0]['favgoods'] = 1;
  883. }
  884. $price = $goods[0]['danprice'];
  885. if ($goods[0]['type'] == 'pintuan' || $goods[0]['type'] == 'lottery') {
  886. $pin_info = M('pin_goods')->where(array(
  887. 'goods_id' => $id
  888. ))->find();
  889. $pin_info['pin_price'] = $goods_price_arr['pin_price'];
  890. $price = $pin_info['pin_price'];
  891. if( $goods[0]['type'] == 'pintuan' && $pin_info['end_time'] < time() )
  892. {
  893. if( C('PIN_ADD_TIME') > 0)
  894. {
  895. $yan_time = time() + 86400 * C('PIN_ADD_TIME');
  896. M('pin_goods')->where(array(
  897. 'id' => $pin_info['id']
  898. ))->save( array('end_time' => $yan_time) );
  899. $pin_info['end_time'] = $yan_time;
  900. }
  901. }
  902. //pin_goods end_time
  903. }
  904. $lottery_info = array();
  905. if ($goods[0]['type'] == 'lottery') {
  906. $lottery_info = M('lottery_goods')->field('is_open_lottery,end_time')->where(array(
  907. 'goods_id' => $id
  908. ))->find();
  909. //验证抽奖商品状态
  910. //end_time
  911. $lottery_is_end_open_status = 0;
  912. //正常可以继续抽奖 0
  913. //已结束,等待开奖 1
  914. //已开奖 活动已结束 2
  915. $now_time = time();
  916. if($lottery_info['end_time'] < $now_time)
  917. {
  918. $lottery_is_end_open_status = 1;
  919. if($lottery_info['is_open_lottery'] == 1)
  920. {
  921. $lottery_is_end_open_status = 2;
  922. }
  923. }
  924. $lottery_info['lottery_is_end_open_status'] = $lottery_is_end_open_status;
  925. }
  926. $need_data['lottery_info'] = $lottery_info;
  927. //lottery_goods
  928. //gd.share_title
  929. if ($goods[0]['type'] == 'integral' ) {
  930. $goods[0]['score'] = intval($goods_price_arr['price']);
  931. if( empty($goods[0]['share_title']) )
  932. {
  933. $goods[0]['share_title'] = intval($price).'积分 '.$goods[0]['name'];
  934. }
  935. }else{
  936. if( empty($goods[0]['share_title']) )
  937. {
  938. $goods[0]['share_title'] = $price.'元 '.$goods[0]['name'];
  939. }
  940. }
  941. /** 商品会员折扣begin **/
  942. $is_show_member_disc = 0;
  943. $member_disc = 100;
  944. $level_info = M('config')->where( array('name' => 'member_level_is_open') )->find();
  945. $member_level_info = array('is_show_member_disc' => $is_show_member_disc);
  946. $member_level_list = array();//会员等级列表
  947. $max_level_logo = C('SITE_URL')."Common/images/plus.png";
  948. $max_member_level = array('level' => 0,'logo'=>'');//最大等级
  949. $max_get_money = 0;//
  950. $max_get_pin_money = 0;//最大折扣拼团省钱
  951. $max_get_dan_money = 0;//最大折扣单独购买省钱
  952. $is_show_max_level = 0;
  953. if( !empty($member_id) && $member_id > 0 && $level_info['value'] == 1 && $goods[0]['is_untake_level'] == 0)
  954. {
  955. $member_info = M('member')->field('level_id')->where( array('member_id' => $member_id) )->find();
  956. $member_level_info = $goods_model->get_member_level_info($member_id, $id);
  957. $member_level_info['is_show_member_disc'] = 1;
  958. $member_disc = $member_level_info['member_discount'];
  959. $max_member_level = M('member_level')->order('level desc')->find();
  960. //level
  961. if($max_member_level['level'] > $member_level_info['level'])
  962. {
  963. $is_show_max_level = 1;
  964. //max_level_logo
  965. if( !empty($max_member_level['logo']) )
  966. {
  967. $max_member_level['logo'] = C('SITE_URL').'Uploads/image/'.$max_member_level['logo'];
  968. }else{
  969. $max_member_level['logo'] = $max_level_logo;
  970. }
  971. }
  972. $member_level_list = M('member_level')->order('id asc')->select();
  973. if( !empty($member_level_list) )
  974. {
  975. foreach( $member_level_list as $key => $val )
  976. {
  977. $val['discount'] = $val['discount'] / 10;
  978. $member_level_list[$key] = $val;
  979. }
  980. }
  981. }
  982. //$max_get_pin_money = 0;//最大折扣拼团省钱
  983. //$max_get_dan_money = 0;//最大折扣单独购买省钱
  984. /** 商品会员折扣end **/
  985. $goods[0]['memberprice'] = sprintf('%.2f', round( ($goods[0]['danprice'] * $member_disc) / 100 ,2));
  986. $max_get_dan_money = round( ($goods[0]['danprice'] * (100 - $max_member_level['discount']) ) / 100 ,2);
  987. $max_get_money = $max_get_dan_money;
  988. if(!empty($pin_info))
  989. {
  990. $pin_info['member_pin_price'] = sprintf('%.2f',round( ($pin_info['pin_price'] * $member_disc) / 100 ,2));
  991. $max_get_pin_money = round( ($pin_info['pin_price'] * (100 - $max_member_level['discount']) ) / 100 ,2);
  992. $max_get_money = $max_get_pin_money;
  993. }
  994. $need_data['pin_info'] = $pin_info; /**$need_data['price_dol'] = $price_dol;**/
  995. if(!empty($member_id) && $member_id > 0 && $goods[0]['type'] == 'integral')
  996. {
  997. $member_info = M('member')->field('score')->where( array('member_id' => $member_id) )->find();
  998. if($member_info['score'] < $goods[0]['score'])
  999. {
  1000. $goods[0]['score_enough'] = 0;
  1001. }else{
  1002. $goods[0]['score_enough'] = 1;
  1003. }
  1004. }
  1005. $need_data['member_level_info'] = $member_level_info;
  1006. $need_data['member_level_list'] = $member_level_list;
  1007. $need_data['max_member_level'] = $max_member_level;
  1008. $need_data['max_get_money'] = sprintf('%.2f',$max_get_money);
  1009. $need_data['max_get_pin_money'] = $max_get_pin_money;
  1010. $need_data['max_get_dan_money'] = $max_get_dan_money;
  1011. //$max_get_pin_money = 0;//最大折扣拼团省钱
  1012. //$max_get_dan_money = 0;//最大折扣单独购买省钱
  1013. $need_data['is_show_max_level'] = $is_show_max_level;
  1014. $need_data['goods'] = $goods[0];
  1015. $need_data['goods_image'] = $goods_image;
  1016. $seller_info = M('seller')->field('s_id,s_true_name,s_logo,s_qq,certification')->where(array(
  1017. 's_id' => $goods[0]['store_id']
  1018. ))->find();
  1019. $seller_model = D('Home/Seller');
  1020. $seller_info['seller_count'] = $seller_model->getStoreSellerCount($goods[0]['store_id']);
  1021. $seller_goods_count = M('goods')->where(array(
  1022. 'store_id' => $goods[0]['store_id']
  1023. ))->count();
  1024. $seller_info['goods_count'] = $seller_goods_count;
  1025. $seller_info['s_logo'] = C('SITE_URL') . 'Uploads/image/' . $seller_info['s_logo'];
  1026. $need_data['seller_info'] = $seller_info;
  1027. $need_data['site_name'] = C('SITE_NAME');
  1028. $need_data['options'] = $goods_model->get_goods_options($id);
  1029. $goods_option_mult_value = M('goods_option_mult_value')->where(array(
  1030. 'goods_id' => $id
  1031. ))->order('id asc')->select();
  1032. $order_comment_count = M('order_comment')->where( array('goods_id' => $id, 'state' => 1) )->count();
  1033. $comment_list = array();
  1034. if($order_comment_count > 0)
  1035. {
  1036. $sql = "select o.*,m.name as name2,m.avatar as avatar2 from ".C('DB_PREFIX')."order_comment as o left join ".C('DB_PREFIX')."member as m on o.member_id=m.member_id
  1037. where o.state = 1 and o.goods_id = {$id} order by o.add_time desc limit 2";
  1038. $comment_list=M()->query($sql);
  1039. foreach($comment_list as $key => $val)
  1040. {
  1041. //user_name
  1042. if( empty($val['user_name']) )
  1043. {
  1044. $val['name'] = $val['name2'];
  1045. $val['avatar'] = $val['avatar2'];
  1046. }else{
  1047. $val['name'] = $val['user_name'];
  1048. }
  1049. if($val['type'] == 0)
  1050. {
  1051. $order_goods_info = M('order_goods')->field('order_goods_id')->where( array('order_id' => $val['order_id'],'goods_id' => $id) )->find();
  1052. $order_option_info = M('order_option')->field('value')->where( array('order_id' =>$val['order_id'],'order_goods_id' => $order_goods_info['order_goods_id']) )->select();
  1053. $option_arr = array();
  1054. foreach($order_option_info as $option)
  1055. {
  1056. $option_arr[] = $option['value'];
  1057. }
  1058. $option_str = implode(',', $option_arr);
  1059. }else{
  1060. $option_str = '';
  1061. }
  1062. if( !empty($val['images']) )
  1063. {
  1064. $img_list = unserialize($val['images']);
  1065. $need_img_list = array();
  1066. foreach($img_list as $kk => $vv)
  1067. {
  1068. if(!empty($vv) )
  1069. {
  1070. $vv = C('SITE_URL') .resize($vv, C('goods_thumb_width'), C('goods_thumb_height'));
  1071. $img_list[$kk] = $vv;
  1072. $need_img_list[$kk] = $vv;
  1073. }
  1074. }
  1075. $val['images'] = $need_img_list ;
  1076. }
  1077. $val['option_str'] = $option_str;
  1078. $val['add_time'] = date('Y-m-d', $val['add_time']) ;
  1079. $comment_list[$key] = $val;
  1080. }
  1081. //$this->comment_list = $comment_list;
  1082. }
  1083. $need_data['cur_time'] = time();
  1084. $need_data['pin_id'] = $pin_id;
  1085. echo json_encode(array(
  1086. 'code' => 1,
  1087. 'comment_list' => $comment_list,
  1088. 'order_comment_count' => $order_comment_count,
  1089. 'data' => $need_data
  1090. ));
  1091. die();
  1092. }
  1093. /**
  1094. 商品评价
  1095. **/
  1096. public function comment_info()
  1097. {
  1098. $goods_id = I('get.goods_id',0);
  1099. $token = I('get.token');
  1100. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  1101. $member_id = $weprogram_token['member_id'];
  1102. $result = array('code' =>0);
  1103. if( empty($member_id))
  1104. {
  1105. $result['msg'] = '未登录';
  1106. echo json_encode($result);
  1107. die();
  1108. }
  1109. $goods_info = M('goods')->where( array('goods_id' => $goods_id ) )->find();
  1110. if(empty($goods_info)) {
  1111. $result['msg'] = '没有此商品';
  1112. echo json_encode($result);
  1113. die();
  1114. }
  1115. $page = I('get.page',1);
  1116. $per_page = I('get.per_page',10);
  1117. // $per_page = 4;
  1118. $offset = ($page - 1) * $per_page;
  1119. $sql = "select o.*,m.name as name2,m.avatar as avatar2 from ".C('DB_PREFIX')."order_comment as o left join ".C('DB_PREFIX')."member as m on o.member_id=m.member_id
  1120. where o.state =1 and o.goods_id = {$goods_id} order by o.add_time desc limit {$offset},{$per_page}";
  1121. $list=M()->query($sql);
  1122. foreach($list as $key => $val)
  1123. {
  1124. if( empty($val['user_name']) )
  1125. {
  1126. $val['name'] = $val['name2'];
  1127. $val['avatar'] = $val['avatar2'];
  1128. }else{
  1129. $val['name'] = $val['user_name'];
  1130. }
  1131. if($val['type'] == 0)
  1132. {
  1133. $order_goods_info = M('order_goods')->field('order_goods_id')->where( array('order_id' => $val['order_id'],'goods_id' => $id) )->find();
  1134. $order_option_info = M('order_option')->field('value')->where( array('order_id' =>$val['order_id'],'order_goods_id' => $order_goods_info['order_goods_id']) )->select();
  1135. $option_arr = array();
  1136. foreach($order_option_info as $option)
  1137. {
  1138. $option_arr[] = $option['value'];
  1139. }
  1140. $option_str = implode(',', $option_arr);
  1141. }else{
  1142. $option_str = '';
  1143. }
  1144. if( !empty($val['images']) )
  1145. {
  1146. $img_list = unserialize($val['images']);
  1147. if(!empty($img_list))
  1148. {
  1149. $need_img_list = array();
  1150. foreach($img_list as $kk => $vv)
  1151. {
  1152. if( empty($vv) )
  1153. {
  1154. continue;
  1155. }
  1156. $vv = C('SITE_URL'). resize($vv, C('goods_thumb_width'), C('goods_thumb_height'));
  1157. $img_list[$kk] = $vv;
  1158. $need_img_list[$kk] = $vv;
  1159. }
  1160. $val['images'] = $need_img_list;
  1161. }else{
  1162. $val['images'] = array();
  1163. }
  1164. }
  1165. //<view class="time span">{{item.addtime}}</view>
  1166. // <view class="style span">{{item.option_str}} </view>
  1167. $val['add_time'] = date('Y-m-d', $val['add_time']) ;
  1168. $val['option_str'] = $option_str;
  1169. $list[$key] = $val;
  1170. }
  1171. $result = array();
  1172. $result['code'] = 1;
  1173. $result['list'] = $list;
  1174. echo json_encode($result);
  1175. die();
  1176. }
  1177. public function get_lottery_info()
  1178. {
  1179. ///goods_id/30
  1180. $goods_id = I('get.goods_id',0);
  1181. // $goods_info = M('goods')->where( array('goods_id' => $goods_id,'type' => 'lottery') )->find();
  1182. $goods_info = M('goods')->where( array('goods_id' => $goods_id) )->find();
  1183. $pin_goods = M('pin_goods')->where( array('goods_id' => $goods_id) )->find();
  1184. if(empty($goods_info)) {
  1185. die('非法操作');
  1186. }
  1187. $page = I('get.page',1);
  1188. $per_page = I('get.per_page',4);
  1189. $per_page = 1000;
  1190. $offset = ($page - 1) * $per_page;
  1191. $goods_info['image'] = C('SITE_URL').resize($goods_info['image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  1192. $sql = "select m.avatar,m.uname,o.order_num_alias,o.shipping_tel from ".C('DB_PREFIX')."order as o ,".C('DB_PREFIX')."order_goods as og,".C('DB_PREFIX')."member as m
  1193. where o.lottery_win = 1 and o.order_id = og.order_id and og.goods_id and o.member_id = m.member_id and og.goods_id = {$goods_id} and o.date_added > ".$pin_goods['begin_time']." order by o.order_id asc limit {$offset},{$per_page}";
  1194. //begin_time
  1195. $this->goods_info = $goods_info;
  1196. $list=M()->query($sql);
  1197. $count_sql = "select count(o.order_num_alias) as count from ".C('DB_PREFIX')."order as o ,".C('DB_PREFIX')."order_goods as og,".C('DB_PREFIX')."member as m
  1198. where o.lottery_win = 1 and o.order_id = og.order_id and og.goods_id and o.member_id = m.member_id and og.goods_id = {$goods_id} ";
  1199. $count=M()->query($count_sql);
  1200. $count = $count[0]['count'];
  1201. $max_page = ceil($count / $per_page);
  1202. $this->pin_goods = $pin_goods;
  1203. $this->list = $list;
  1204. $this->goods_id = $goods_id;
  1205. //if(empty($list)) {
  1206. // $jia_page = $page - $max_page;
  1207. // $offset = ($jia_page - 1) * $per_page;
  1208. $sql = "select avatar,uname,order_sn as order_num_alias,mobile as shipping_tel from
  1209. ".C('DB_PREFIX')."jiaorder
  1210. where goods_id = {$goods_id} and addtime > ".$pin_goods['begin_time']." order by id asc limit {$offset},{$per_page}";
  1211. // where goods_id = {$goods_id} order by id asc limit {$offset},{$per_page}";
  1212. $lists=M()->query($sql);
  1213. foreach($lists as $vv)
  1214. {
  1215. $list[] = $vv;
  1216. }
  1217. // $this->list = $list;
  1218. // }
  1219. if(!empty($list))
  1220. {
  1221. foreach($list as $key => $val)
  1222. {
  1223. $list[$key]['shipping_tel'] = substr($val['shipping_tel'],0,3)."*****".substr($val['shipping_tel'],-3,3);
  1224. }
  1225. $need_data = array();
  1226. $need_data['code'] = 0;
  1227. $need_data['goods_info'] = $goods_info;
  1228. $need_data['pin_goods'] = $pin_goods;
  1229. $need_data['data'] = $list;
  1230. }else {
  1231. $need_data = array();
  1232. $need_data['code'] = 0;
  1233. $need_data['goods_info'] = $goods_info;
  1234. $need_data['pin_goods'] = $pin_goods;
  1235. $need_data['data'] = $list;
  1236. }
  1237. echo json_encode($need_data);
  1238. die();
  1239. }
  1240. function get_subcategory()
  1241. {
  1242. // /id/'+cur_pid
  1243. $cate_id = I('get.id',0);
  1244. $level = 0;
  1245. $cur_cate_name = '';
  1246. //name
  1247. if($cate_id > 0)
  1248. {
  1249. $parinfo = M('goods_category')->where( array('id' => $cate_id) )->find();
  1250. $cur_cate_name = $parinfo['name'];
  1251. if($parinfo['pid'] > 0)
  1252. {
  1253. $level = 2;
  1254. }
  1255. }
  1256. $goods_category_list = M('goods_category')->where( array('pid' => $cate_id) )->order('sort_order desc, id asc')->select();
  1257. foreach($goods_category_list as $key => $val)
  1258. {
  1259. $val['logo'] = C('SITE_URL').'Uploads/image/'.$val['logo'];
  1260. $goods_category_list[$key] = $val;
  1261. }
  1262. if(!empty($goods_category_list))
  1263. {
  1264. echo json_encode( array('code' => 0,'level' => $level, 'cur_cate_name' => $cur_cate_name,'data' => $goods_category_list) );
  1265. die();
  1266. } else{
  1267. echo json_encode( array('code' => 1,'level' => $level,'cur_cate_name' => $cur_cate_name) );
  1268. die();
  1269. }
  1270. }
  1271. /**
  1272. 获得商户优惠券
  1273. **/
  1274. public function get_seller_quan()
  1275. {
  1276. $seller_id = I('get.store_id',1);
  1277. $where = "";
  1278. $where = "total_count>send_count and store_id ={$seller_id} and is_index_show=1 and end_time>".time();
  1279. $quan_list = M('voucher')->where($where)->order('add_time desc')->limit(4)->select();
  1280. echo json_encode( array('code' => 0, 'quan_list' => $quan_list) );
  1281. die();
  1282. }
  1283. public function seller_info()
  1284. {
  1285. $seller_id = I('get.id',0);
  1286. //s_true_name s_logo
  1287. $seller_info = M('seller')->field('s_true_name,s_logo,s_banner')->where( array('s_id' => $seller_id) )->find();
  1288. $seller_info['s_logo'] = C('SITE_URL').'Uploads/image/'.$seller_info['s_logo'];
  1289. if( empty($seller_info['s_banner']) )
  1290. {
  1291. $seller_info['s_banner'] = C('SITE_URL').'Common/mogu/image/170923_1bk3970j2eb9jia57aa8k3i661ck5_750x270.jpg';
  1292. } else{
  1293. $seller_info['s_banner'] = C('SITE_URL').'Uploads/image/'.$seller_info['s_banner'];
  1294. }
  1295. //s_banner
  1296. $seller_model = D('Home/Seller');
  1297. $seller_count = $seller_model->getStoreSellerCount($seller_id);
  1298. $goods_count = M('goods')->where( array('store_id' => $seller_id) )->count();
  1299. $seller_info['seller_count'] = $seller_count;
  1300. $seller_info['goods_count'] = $goods_count;
  1301. //$this->goods_count = $goods_count;
  1302. //$this->seller_count = $seller_count;
  1303. $store_class_list = M('store_bind_class')->where( array('seller_id' => $seller_id) )->order('bid asc')->select();
  1304. $store_class_ids = array();
  1305. foreach($store_class_list as $class_val)
  1306. {
  1307. $store_class_ids[] = $class_val['class_1'];
  1308. }
  1309. $category_list = array();
  1310. if( !empty($store_class_ids) )
  1311. {
  1312. $category_list = M('goods_category')->field('id,name,logo')->where( array('id' => array('in', $store_class_ids) ) )->select();
  1313. foreach($category_list as $key => $val)
  1314. {
  1315. $val['logo'] = C('SITE_URL').'Uploads/image/'.$val['logo'];
  1316. $category_list[$key] = $val;
  1317. }
  1318. }
  1319. //["name"]=> string(12) "食品食品" ["logo"]=>
  1320. //$this->category_list = $category_list;
  1321. $fans_count = M('user_favstore')->where( array('store_id' => $seller_id) )->count();
  1322. $seller_info['fans_count'] = $fans_count;
  1323. $seller_info['category_list'] = $category_list;
  1324. $where = "";
  1325. $where = "total_count>send_count and store_id ={$seller_id} and is_index_show=1 and end_time>".time();
  1326. $quan_list = M('voucher')->where($where)->order('add_time desc')->limit(4)->select();
  1327. $seller_info['quan_list'] = $quan_list;
  1328. //$this->quan_list = $quan_list;
  1329. echo json_encode( array('code' =>0, 'data' => $seller_info) );
  1330. die();
  1331. }
  1332. public function getQuan()
  1333. {
  1334. $token = I('get.token');
  1335. //user_favgoods
  1336. $weprogram_token = M('weprogram_token')->field('member_id')->where( array('token' =>$token) )->find();
  1337. $member_id = $weprogram_token['member_id'];
  1338. $data_json = file_get_contents('php://input');
  1339. $data = json_decode($data_json, true);
  1340. $result = array('code' => 0,'msg' => '被抢光啦');
  1341. $quan_id = $data['quan_id'];
  1342. if($quan_id >0){
  1343. $quan_model = D('Home/Voucher');
  1344. $res = $quan_model->send_user_voucher_byId($quan_id,$member_id,true);
  1345. //1 被抢光了 2 已领过 3 领取成功
  1346. $mes_arr = array(1 => '被抢光了',2 => '已领过', 3 => '领取成功');
  1347. $result['code'] = $res;
  1348. $result['msg'] = $mes_arr[$res];
  1349. }
  1350. echo json_encode($result);
  1351. die();
  1352. }
  1353. public function notify_order()
  1354. {
  1355. //$map['id'] = array('neq',100);
  1356. $notify_order = M('notify_order')->where( array('state' => array('lt', 1)) )->order('state asc,id asc')->find();
  1357. //username
  1358. $result = array('ret' => 0);
  1359. if(empty($notify_order))
  1360. {
  1361. echo json_encode($result);
  1362. die();
  1363. }
  1364. M('notify_order')->where( array('id' => $notify_order['id']) )->setInc('state', 1);
  1365. $miao = (time() -$notify_order['order_time']) % 60;
  1366. $result['ret'] = 1;
  1367. $result['username'] = $notify_order['username'];
  1368. $result['avatar'] = $notify_order['avatar'];
  1369. $result['order_id'] = $notify_order['order_id'];
  1370. $result['order_url'] = $notify_order['order_url'];
  1371. $result['miao'] = $miao;
  1372. //->save( array('state' => 1) );
  1373. echo json_encode($result);
  1374. die();
  1375. }
  1376. public function seller_goods_list()
  1377. {
  1378. $pre_page = I('get.pre_page',2);
  1379. $page = I('get.page',1);
  1380. $seller_id = I('get.seller_id',0);
  1381. $gid = I('get.gid',0);
  1382. $keyword = I('get.keyword','');
  1383. $order_by = I('get.order_by','default');
  1384. switch($order_by)
  1385. {
  1386. case 'default':
  1387. $order_by = 'sort_order asc';
  1388. break;
  1389. case 'hot':
  1390. $order_by = 'seller_count desc';
  1391. break;
  1392. case 'new':
  1393. $order_by = 'goods_id desc';
  1394. break;
  1395. }
  1396. $where = " and (g.type='pintuan' or g.type='lottery') and g.store_id = {$seller_id} and g.status =1 and g.quantity > 0 ";
  1397. $offset = ($page -1) * $pre_page;
  1398. if( $gid > 0)
  1399. {
  1400. $where .= " and (gt.class_id1 = {$gid} or gt.class_id2 = {$gid} or gt.class_id3 = {$gid}) ";
  1401. }
  1402. if( !empty($keyword) )
  1403. {
  1404. $where .= " and g.name like '%{$keyword}%' ";
  1405. }
  1406. $sql = "select g.* from ".C('DB_PREFIX')."goods as g ,".C('DB_PREFIX')."goods_to_category as gt
  1407. where g.goods_id = gt.goods_id {$where} order by {$order_by} limit {$offset},{$pre_page} ";
  1408. $list = M()->query($sql);
  1409. $goods_data = array();
  1410. if(!empty($list)) {
  1411. foreach($list as $key => $v){
  1412. //$list[$key]['seller_count'] += $v['virtual_count'];
  1413. $tmp_goods = array();
  1414. $tmp_goods['goods_id'] = $v['goods_id'];
  1415. $tmp_goods['name'] = $v['name'];
  1416. $tmp_goods['quantity'] = $v['quantity'];
  1417. $tmp_goods['image'] = C('SITE_URL').'Uploads/image/' .$v['image'];
  1418. $tmp_goods['price'] = $v['price'];
  1419. $tmp_goods['danprice'] = $v['danprice'];
  1420. $tmp_goods['seller_count'] = $v['seller_count']+$v['virtual_count'];
  1421. $tmp_goods['fav_count'] = M('user_favgoods')->where( array('goods_id' => $v['goods_id']) ) ->count();
  1422. $goods_data[] = $tmp_goods;
  1423. //$list[$key]['image']=resize($v['image'], C('common_image_thumb_width'), C('common_image_thumb_height'));
  1424. }
  1425. }
  1426. if( empty($goods_data) )
  1427. {
  1428. echo json_encode( array('code' => 1) );
  1429. die();
  1430. } else {
  1431. echo json_encode( array('code' => 0, 'data' => $goods_data) );
  1432. die();
  1433. }
  1434. }
  1435. }