store.ctrl.php 3.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677
  1. <?php
  2. /**
  3. * [WeEngine System] Copyright (c) 2014 WE7.CC
  4. * WeEngine is NOT a free software, it under the license terms, visited http://www.we7.cc/ for more details.
  5. */
  6. defined('IN_IA') or exit('Access Denied');
  7. uni_user_permission_check('mc_business');
  8. $dos = array('display', 'post','delete');
  9. $do = in_array($do, $dos) ? $do : 'display';
  10. $_W['page']['title'] = '商家设置-粉丝营销';
  11. if($do == 'post') {
  12. $id = intval($_GPC['id']);
  13. if($id > 0) {
  14. $sql = 'SELECT * FROM '.tablename('activity_stores').' WHERE id = :id AND uniacid = :uniacid';
  15. $item = pdo_fetch($sql, array(':id' => $id, ':uniacid' => $_W['uniacid']));
  16. if(empty($item)) {
  17. message('商家不存在',referer(),'info');
  18. }
  19. $item['category'] = iunserializer($item['category']);
  20. $item['photo_list'] = iunserializer($item['photo_list']);
  21. $item['opentime'] = explode('-', $item['opentime']);
  22. $item['open_time_start'] = $item['opentime'][0];
  23. $item['open_time_end'] = $item['opentime'][1];
  24. }else {
  25. $item['open_time_start'] = '8:00';
  26. $item['open_time_end'] = '24:00';
  27. }
  28. if(checksubmit('submit')) {
  29. $insert = array();
  30. $insert['uniacid'] = intval($_W['uniacid']);
  31. $insert['business_name'] = trim($_GPC['business_name']);
  32. $insert['branch_name'] = trim($_GPC['branch_name']);
  33. $insert['category'] = iserializer(array(
  34. 'cate' => trim($_GPC['class']['cate']),
  35. 'sub' => trim($_GPC['class']['sub']),
  36. 'clas' => trim($_GPC['class']['clas'])
  37. ));
  38. $insert['province'] = trim($_GPC['reside']['province']);
  39. $insert['city'] = trim($_GPC['reside']['city']);
  40. $insert['district'] = trim($_GPC['reside']['district']);
  41. $insert['address'] = trim($_GPC['address']);
  42. $insert['longitude'] = trim($_GPC['baidumap']['lng']);
  43. $insert['latitude'] = trim($_GPC['baidumap']['lat']);
  44. $insert['telephone'] = trim($_GPC['telephone']);
  45. $insert['photo_list'] = iserializer($_GPC['photo_list']);
  46. $insert['avg_price'] = intval($_GPC['avg_price']);
  47. $insert['opentime'] = trim($_GPC['open_time_start']). '-'.trim($_GPC['open_time_end']);
  48. $insert['recommend'] = trim($_GPC['recommend']);
  49. $insert['special'] = trim($_GPC['special']);
  50. $insert['introduction'] = trim($_GPC['introduction']);
  51. if($id > 0) {
  52. pdo_update('activity_stores',$insert,array('id' => $id, 'uniacid' => $_W['uniacid']));
  53. message('更新商家成功',url('mc/business/display'),'success');
  54. }else {
  55. pdo_insert('activity_stores', $insert);
  56. message('添加门店成功', url('mc/business/display'), 'success');
  57. }
  58. }
  59. }
  60. if($do == 'display') {
  61. $pindex = max(1, intval($_GPC['page']));
  62. $psize = 15;
  63. $limit = 'ORDER BY id DESC LIMIT ' . ($pindex - 1) * $psize . ", {$psize}";
  64. $total = pdo_fetchcolumn('SELECT COUNT(*) FROM '.tablename('activity_stores').' WHERE uniacid = :uniacid', array(':uniacid' => $_W['uniacid']));
  65. $list = pdo_fetchall('SELECT * FROM '.tablename('activity_stores'). " WHERE uniacid = :uniacid {$limit}", array(':uniacid' => $_W['uniacid']));
  66. $pager = pagination($total,$pindex,$psize);
  67. foreach($list as &$key) {
  68. $key['category'] = iunserializer($key['category']);
  69. $key['category'] = implode('-', $key['category']);
  70. }
  71. }
  72. if($do =='delete') {
  73. pdo_delete('activity_stores',array('id' => $_GPC['id'], 'uniacid' => $_W['uniacid']));
  74. message('删除成功',referer(), 'success');
  75. }
  76. template('mc/store');