MessageBoardModel.class.php 2.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. <?php
  2. namespace Common\Model;
  3. use Common\Model\BaseModel;
  4. /**
  5. * 留言板
  6. * @author: linch
  7. * Class MessageBoardModel
  8. * @package Common\Model
  9. */
  10. class MessageBoardModel extends BaseModel
  11. {
  12. //使用x-motion.cn数据库
  13. protected $connection ='DB_CONFIG_XMOTION';
  14. protected $mod;
  15. //状态
  16. const status_wait = 0; //待处理
  17. const status_processed = 1; //已联系
  18. //软删状态
  19. const flag_off = 0; //删除
  20. const flag_on = 1; //正常
  21. //来源
  22. const source_official_web = 1; //官网
  23. const source_official_wap = 2; //wap
  24. public function __construct() {
  25. parent::__construct();
  26. $this->mod = M('message_board');
  27. }
  28. /**
  29. * 添加留言信息
  30. * @author: linch
  31. * @param $data
  32. * @param $source
  33. * @param $ad_message_id
  34. * @return array
  35. */
  36. public function data_add($data, $source, $ad_message_id = 0) {
  37. $time = date('Y-m-d H:i:s');
  38. $save_data = array(
  39. 'name' => $data['name'],
  40. 'tel' => $data['tel'],
  41. 'address' => $data['address'],
  42. 'message' => $data['message'],
  43. 'source' => $source,
  44. 'status' => self::status_wait,
  45. 'c_time' => $time,
  46. );
  47. if (!empty($ad_message_id)) {
  48. $save_data['ad_message_id'] = (int)$ad_message_id;
  49. }
  50. $result = $this->check_edit_data($save_data);
  51. if ($result['code'] == false) {
  52. $msg = array('code' => $result['code'], 'msg' => $result['msg']);
  53. } else {
  54. $id = $this->data($save_data)->add();
  55. if ($id == false) {
  56. $msg = array('code' => false, 'msg' => '内部错误,稍后重试');
  57. } else {
  58. $msg = array('code' => true, 'msg' => '提交成功');
  59. }
  60. }
  61. return $msg;
  62. }
  63. /**
  64. * 验证数据
  65. * @author: linch
  66. * @param $data
  67. * @return array
  68. */
  69. public function check_edit_data($data) {
  70. if (empty($data['name'])) {
  71. return array('code' => false, 'msg' => '姓名不能为空');
  72. }
  73. if (empty($data['tel'])) {
  74. return array('code' => false, 'msg' => '手机不能为空');
  75. }
  76. if (empty($data['address'])) {
  77. return array('code' => false, 'msg' => '地址不能为空');
  78. }
  79. if (empty($data['message'])) {
  80. return array('code' => false, 'msg' => '留言不能为空');
  81. }
  82. if (!preg_match('/^[1][3,4,5,7,8][0-9]{9}$/', $data['tel'])) {
  83. return array('code' => false, 'msg' => '手机号错误');
  84. }
  85. return array('code' => true, 'msg' => '数据符合');
  86. }
  87. }