Sign.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566
  1. <?php
  2. namespace Pay\Yspay;
  3. use Dever;
  4. header("Content-Type:text/html;charset=utf-8");
  5. Class Sign
  6. {
  7. private $key = "o5ho739mgrphdm28g5rwx1nw";
  8. private $accesser_id = '2d9081bd7db8ad75017dbbe68981314f';
  9. private $url = 'https://yinshangpai.chinaums.com/self-contract-nmrs/interface/autoReg/';
  10. private $sign_type = 'SHA-256';
  11. private $test = 2;
  12. /*
  13. 0-银联卡(1)
  14. 1-全民付(86)
  15. 2-POS通(68)
  16. 4-营销联盟(40)
  17. 8-公共支付-通用(9)
  18. 16-代付业务(74)
  19. 21-统一会员卡(37)
  20. in1-APP支付(in1)
  21. in2-H5支付(in2)
  22. in3-公众号支付(in3)
  23. in4-小程序支付(in4)
  24. */
  25. private $product_id = array('8');
  26. private $document_type = array
  27. (
  28. 'idcard_front' => ['document_type' => '0001','document_name' => '身份证正面'],
  29. 'idcard_back' => ['document_type' => '0011','document_name' => '身份证反面'],
  30. 'license' => ['document_type' => '0002','document_name' => '营业执照'],
  31. 'tax' => ['document_type' => '0003','document_name' => '税务登记证'],
  32. 'door' => ['document_type' => '0005','document_name' => '门头照'],
  33. 'hand_idcard' => ['document_type' => '0007','document_name' => '手持身份证自拍照'],
  34. 'open' => ['document_type' => '0006','document_name' => '开户许可证'],
  35. 'bank_fount' => ['document_type' => '0025','document_name' => '银行卡正面照'],
  36. 'bank_back' => ['document_type' => '0026','document_name' => '银行卡反面照'],
  37. 'house_pic' => ['document_type' => '0015','document_name' => '室内照片'],
  38. 'screen_pic' => ['document_type' => '0034','document_name' => '商户网站/APP截图'],
  39. );
  40. public function update($id, $name, $data)
  41. {
  42. $cash = Dever::param('cash', $data);
  43. $sign = Dever::db('pay/yspay_sign')->find($id);
  44. if ($cash && $cash > 0) {
  45. $this->account_check($sign, $cash);
  46. }
  47. }
  48. # 计划任务
  49. public function cron_api()
  50. {
  51. $where['step'] = '4,5';
  52. $data = Dever::db('pay/yspay_sign')->getData($where);
  53. if ($data) {
  54. foreach ($data as $k => $v) {
  55. $this->check($v);
  56. }
  57. }
  58. return 'ok';
  59. }
  60. # 获取合同链接
  61. public function getAgreement_api($sign_id)
  62. {
  63. $sign = Dever::db('pay/yspay_sign')->find($sign_id);
  64. return $this->agreement($sign, false);
  65. }
  66. # 获取当前状态
  67. public function getStatus_api($sign_id)
  68. {
  69. $sign = Dever::db('pay/yspay_sign')->find($sign_id);
  70. return $this->check($sign);
  71. }
  72. # 获取最新一条日志
  73. public function getLog($sign_id, $status)
  74. {
  75. if ($status == 1) {
  76. return '签约已完成';
  77. }
  78. $sign = Dever::db('pay/yspay_sign')->find($sign_id);
  79. $log = Dever::db('pay/yspay_sign_log')->find(array('merchant_id' => $sign['merchant_id']));
  80. if ($log) {
  81. $date = date('Y-m-d H:i', $log['cdate']);
  82. $step = Dever::db('pay/yspay_sign_log')->config['step'][$log['step']];
  83. return $date . '<br />' . $step . '<br />' . $log['desc'];
  84. } else {
  85. return '待签约提审';
  86. }
  87. }
  88. # 获取日志列表
  89. public function getLogList($sign_id)
  90. {
  91. $sign = Dever::db('pay/yspay_sign')->find($sign_id);
  92. if (!$sign) {
  93. return Dever::timeline('填写资料');
  94. }
  95. $result = array();
  96. $log = Dever::db('pay/yspay_sign_log')->select(array('merchant_id' => $sign['merchant_id']));
  97. if ($log) {
  98. foreach ($log as $k => $v) {
  99. if ($v['step'] == 4) {
  100. //$v['response'] = Dever::json_decode($v['response']);
  101. $url = $this->agreement($sign, false);
  102. $v['desc'] .= ' <a href="'.$url.'" target="_blank">点此打开</a> <a style="cursor:pointer" data-clipboard-text="'.$url.'" class="clipboard">复制链接</a>';
  103. }
  104. $date = date('Y-m-d H:i', $v['cdate']);
  105. $name = '';
  106. if ($v['admin_id'] > 0) {
  107. $admin = Dever::db('manage/admin')->find($v['admin_id']);
  108. if ($admin) {
  109. $name = '[' . $admin['username'] . ']&nbsp;&nbsp;';
  110. }
  111. }
  112. $result[] = $date . '&nbsp;&nbsp;' . $name . ''. $v['desc'];
  113. }
  114. }
  115. if ($sign['step'] == -1) {
  116. $url = Dever::url('pay/yspay/sign.handle?sign_id=' . $sign['id'] . '&json=1');
  117. $result[] = '<a href="javascript:;" onclick="load(\''.$url.'\')">点此上传资料</a>';
  118. }
  119. $result = Dever::timeline('签约记录', $result);
  120. return $result;
  121. }
  122. # 统一处理接口
  123. public function handle_api($sign_id)
  124. {
  125. $sign = Dever::db('pay/yspay_sign')->find($sign_id);
  126. if (!$sign) {
  127. Dever::alert('档案资料未上传');
  128. }
  129. $sign['merchant'] = Dever::db('pay/yspay_merchant')->one($sign['merchant_id']);
  130. $sign['yspay'] = Dever::db('pay/yspay')->one(array('account_id' => $sign['merchant']['account_id']));
  131. $this->key = $sign['yspay']['sign_key'];
  132. $this->accesser_id = $sign['yspay']['sign_accesser_id'];
  133. $sign['bank_acct_no'] = trim($sign['bank_acct_no']);
  134. switch($sign['step']) {
  135. case -1:
  136. # 提交资料
  137. return $this->up($sign);
  138. break;
  139. case 1:
  140. case 6:
  141. if ($sign['bank_acct_type'] == 1) {
  142. # 对公打款
  143. return $this->account($sign);
  144. } else {
  145. # 签约
  146. return $this->agreement($sign);
  147. }
  148. break;
  149. case 2:
  150. # 打款验证
  151. return $this->account_check($sign);
  152. break;
  153. case 4:
  154. case 5:
  155. # 验证签约
  156. return $this->check($sign);
  157. break;
  158. case 6:
  159. # 签约成功,变更签约?
  160. return '签约已成功,后续可以变更签约';
  161. return $this->up($sign);
  162. break;
  163. }
  164. return 'ok';
  165. }
  166. # 上传图片
  167. public function upload_api()
  168. {
  169. $document_type = $this->document_type;
  170. $key = Dever::input('key');
  171. $upload = Dever::json_decode(Dever::input('upload'));
  172. if ($upload && isset($document_type[$key]) && isset($upload['url'])) {
  173. $url = md5($upload['url']);
  174. $sign_pic = Dever::db('pay/yspay_sign_pic')->find(array('key' => $key, 'url' => $url));
  175. if (!$sign_pic) {
  176. $pic = $this->pic($upload['url']);
  177. if ($pic && isset($pic['data']['file_path']) && $pic['data']['file_path']) {
  178. $insert = array();
  179. $insert['url'] = $url;
  180. $insert['document_type'] = $document_type[$key]['document_type'];
  181. $insert['document_name'] = $document_type[$key]['document_name'];
  182. $insert['key'] = $key;
  183. $insert['path'] = Dever::json_encode($pic['data']);
  184. Dever::db('pay/yspay_sign_pic')->insert($insert);
  185. }
  186. }
  187. }
  188. return 'ok';
  189. }
  190. #3.2 详细采集档案资料上传接口
  191. private function up($sign)
  192. {
  193. $service = 'complex_upload';
  194. $data['remark'] = '线上支付商户';
  195. $data['accesser_user_id'] = $sign['id'];
  196. if ($sign['reg_mer_type'] == 1) {
  197. $sign['reg_mer_type'] = '00';
  198. } elseif ($sign['reg_mer_type'] == 2) {
  199. $sign['reg_mer_type'] = '01';
  200. } elseif ($sign['reg_mer_type'] == 3) {
  201. $sign['reg_mer_type'] = '02';
  202. }
  203. $data['reg_mer_type'] = $sign['reg_mer_type'];#注册类型
  204. $data['legal_name'] = $sign['name'];#法人姓名
  205. $data['legal_idcard_no'] = $sign['idcard'];#法人身份证号
  206. $data['legal_mobile'] = $sign['mobile'];#法人手机号
  207. $data['legal_card_deadline'] = $sign['card_deadline'] == '长期' ? '9999-12-31' : date('Y-m-d',$sign['card_deadline']);#证件截止代表日期
  208. $data['shop_name'] = $sign['merchant']['name'];#商户名称
  209. if ($sign['bank_acct_type'] == -1) {
  210. $data['bank_acct_type'] = 0;
  211. $data['bank_acct_name'] = $sign['name'];#开户账号名称
  212. } else {
  213. $data['bank_acct_type'] = 1;
  214. $data['bank_acct_name'] = $sign['company_name'];#开户账号名称
  215. }
  216. $data['bank_acct_no'] = $sign['bank_acct_no'];#开户行账号
  217. $data['mccCode'] = $sign['mccCode'];
  218. $area = explode(',', $sign['area']);
  219. $data['shop_province_id'] = $area[0]/10000;
  220. $data['shop_city_id'] = $area[1]/100;
  221. $data['shop_country_id'] = $area[2];
  222. $sign_area = explode(',',$sign['area']);
  223. $data['shop_lic'] = $sign['license_number'];#营业执照号
  224. $bank = $this->bank_list($sign_area[0]/10000, $sign['bank_acct_noname']);
  225. if($bank && isset($bank['branchBankList']) && $bank['branchBankList']){
  226. $bank['branchBankList'] = $bank['branchBankList'][0];
  227. $in['where_id'] = $sign['id'];
  228. $in['bank_no'] = $bank['branchBankList']['code'];
  229. $in['shop_addr_ext'] = $bank['branchBankList']['bankBranchName'];
  230. Dever::db('pay/yspay_sign')->update($in);
  231. $data['bank_no'] = $bank['branchBankList']['code'];
  232. $data['shop_addr_ext'] = $bank['branchBankList']['bankBranchName'];
  233. } else {
  234. return $this->log(1, $sign, '开户行行号不存在');
  235. }
  236. if ($sign['reg_mer_type'] == '00' && $sign['bank_acct_type'] != '1') {
  237. return $this->log(1, $sign, '账户类型不正确1');
  238. }
  239. if ($sign['legalmanHomeAddr']) {
  240. $data['legalmanHomeAddr'] = $sign['legalmanHomeAddr'];
  241. }
  242. $document_type = $this->document_type;
  243. foreach ($document_type as $k => $v) {
  244. if (isset($sign[$k]) && $sign[$k]) {
  245. $sign[$k] = Dever::pic($sign[$k]);
  246. $url = md5($sign[$k]);
  247. $sign_pic = Dever::db('pay/yspay_sign_pic')->find(array('key' => $k, 'url' => $url));
  248. if (!$sign_pic) {
  249. $pic = $this->pic($sign[$k]);
  250. if ($pic && isset($pic['data']['file_path']) && $pic['data']['file_path']) {
  251. $insert = array();
  252. $insert['url'] = $url;
  253. $insert['document_type'] = $v['document_type'];
  254. $insert['document_name'] = $v['document_name'];
  255. $insert['key'] = $k;
  256. $insert['path'] = Dever::json_encode($pic['data']);
  257. Dever::db('pay/yspay_sign_pic')->insert($insert);
  258. $data['pic_list'][] = array('document_name' => $v['document_name'], 'document_type' => $v['document_type'] , 'file_path'=> $pic['data']['file_path'], 'file_size'=>$pic['data']['file_size']);
  259. }
  260. } else {
  261. $pic = Dever::json_decode($sign_pic['path']);
  262. $data['pic_list'][] = array('document_name' => $sign_pic['document_name'], 'document_type' => $sign_pic['document_type'] , 'file_path'=> $pic['file_path'], 'file_size'=>$pic['file_size']);
  263. }
  264. }
  265. }
  266. $ids = $this->product_id;
  267. $data['product'] = array();
  268. foreach ($ids as $k => $v) {
  269. $data['product'][$k] = ['product_id' => $v];
  270. }
  271. $result = $this->get($service, $data);
  272. if ($result && $result['code'] == 1 && isset($result['data']['ums_reg_id']) && $result['data']['ums_reg_id']) {
  273. $update = array();
  274. $update['where_id'] = $sign['id'];
  275. $sign['ums_reg_id'] = $update['ums_reg_id'] = $result['data']['ums_reg_id'];
  276. Dever::db('pay/yspay_sign')->update($update);
  277. $this->log(1, $sign, '资料上传成功', $data, $result['data'], $result['request_seq']);
  278. if ($data['bank_acct_type'] == 1) {
  279. return $this->account($sign);
  280. } else {
  281. return $this->agreement($sign);
  282. }
  283. } else {
  284. $this->log(1, $sign, $result['msg'], $data, $result['data'], $result['request_seq']);
  285. }
  286. return Dever::input('json') == 1 ? 'reload' : $result;
  287. }
  288. # 3.7 发起对公账户验证交易接口
  289. public function account($sign)
  290. {
  291. $step = 2;
  292. $service = 'request_account_verify';
  293. $data['ums_reg_id'] = $sign['ums_reg_id'];
  294. $data['company_account'] = $sign['bank_acct_no'];
  295. $result = $this->get($service, $data);
  296. if ($result && $result['code'] == 1 && isset($result['data']['request_seq']) && $result['data']['request_seq']) {
  297. $update = array();
  298. $update['where_id'] = $sign['id'];
  299. $update['step'] = $step;
  300. $update['clear'] = true;
  301. Dever::db('pay/yspay_sign')->update($update);
  302. $this->log($update['step'], $sign, '公户打款成功', $data, $result['data'], $result['request_seq']);
  303. } else {
  304. $this->log($step, $sign, $result['msg'], $data, $result['data'], $result['request_seq']);
  305. }
  306. return Dever::input('json') == 1 ? 'reload' : $result;
  307. }
  308. # 3.6 对公账户认证接口
  309. public function account_check($sign, $num)
  310. {
  311. $step = 3;
  312. $trans_amt = $num;
  313. $service = 'company_account_verify';
  314. $data['ums_reg_id'] = $sign['ums_reg_id'];
  315. $data['company_account'] = $sign['bank_acct_no'];
  316. $data['trans_amt'] = $trans_amt;
  317. $result = $this->get($service, $data, $sign['ums_reg_id']);
  318. if ($result && $result['code'] == 1 && isset($result['data']['request_seq']) && $result['data']['request_seq']) {
  319. $update = array();
  320. $update['where_id'] = $sign['id'];
  321. $update['step'] = $step;
  322. $update['clear'] = true;
  323. Dever::db('pay/yspay_sign')->update($update);
  324. $this->log($update['step'], $sign, '公户对账成功', $data, $result['data'], $result['request_seq']);
  325. return $this->agreement($sign);
  326. } else {
  327. $this->log($step, $sign, $result['msg'], $data, $result['data'], $result['request_seq']);
  328. }
  329. return $result;
  330. }
  331. # 3.3 前台签约接口
  332. public function agreement($sign, $log = true)
  333. {
  334. $step = 4;
  335. $service = 'agreement_sign';
  336. $data['ums_reg_id'] = $sign['ums_reg_id'];
  337. $data['pcOrH5'] = 'H5';
  338. $result = $this->get($service, $data);
  339. if ($result && $result['code'] == 1 && isset($result['data']['url']) && $result['data']['url']) {
  340. $update = array();
  341. $update['where_id'] = $sign['id'];
  342. $update['step'] = $step;
  343. $update['url'] = $result['data']['url'];
  344. $update['clear'] = true;
  345. Dever::db('pay/yspay_sign')->update($update);
  346. if ($log) {
  347. $this->log($update['step'], $sign, '请复制链接进行合同签署', $data, $result['data'], $result['request_seq']);
  348. } else {
  349. return $update['url'];
  350. }
  351. } else {
  352. $this->log($step, $sign, $result['msg'], $data, $result['data'], $result['request_seq']);
  353. }
  354. return Dever::input('json') == 1 ? 'reload' : $result;
  355. }
  356. # 3.4 入网状态查询接口
  357. public function check($sign)
  358. {
  359. $step = 5;
  360. $service = 'apply_qry';
  361. $data['ums_reg_id'] = $sign['ums_reg_id'];
  362. $result = $this->get($service, $data, $sign['ums_reg_id']);
  363. if ($result && $result['code'] == 1 && isset($result['data']['apply_status'])) {
  364. if ($result['data']['apply_status'] == '03') {
  365. $step = 6;
  366. }
  367. $update = array();
  368. $update['where_id'] = $sign['id'];
  369. $update['step'] = $step;
  370. $update['clear'] = true;
  371. if ($result['data']['apply_status'] == '03' && isset($result['data']['mer_no']) && $result['data']['mer_no']) {
  372. $mid = $result['data']['mer_no'];
  373. Dever::db('pay/yspay_merchant')->update(array('merchant_id' => $sign['merchant_id'], 'mid' => $mid));
  374. }
  375. Dever::db('pay/yspay_sign')->update($update);
  376. $this->log($update['step'], $sign, $result['data']['apply_status_msg'], $data, $result['data'], $result['request_seq']);
  377. } else {
  378. $this->log($step, $sign, $result['data']['apply_status_msg'], $data, $result['data'], $result['request_seq']);
  379. }
  380. return $result;
  381. }
  382. private function encrypt($data)
  383. {
  384. $res = bin2hex(openssl_encrypt($data, 'DES-EDE3', $this->key, OPENSSL_RAW_DATA));
  385. return $res;
  386. }
  387. private function decrypt($data)
  388. {
  389. return openssl_decrypt(pack('H*',$data), 'DES-EDE3', $this->key, OPENSSL_RAW_DATA);
  390. }
  391. private function get($service, $data)
  392. {
  393. $accesser_id = $this->accesser_id;
  394. $sign_type = $this->sign_type;
  395. $param = $data;
  396. $param['service'] = $service;
  397. $param['sign_type'] = $sign_type;
  398. $param['accesser_id'] = $accesser_id;
  399. $param['request_date'] = date('YmdHis');
  400. $param['request_seq'] = Dever::order();
  401. $sign_data = json_encode($param, JSON_UNESCAPED_SLASHES|JSON_UNESCAPED_UNICODE);
  402. $send['json_data'] = $this->encrypt($sign_data);
  403. $send['sign_data'] = hash('sha256', $sign_data);
  404. $send['accesser_id'] = $accesser_id;
  405. $url = $this->url;
  406. $result = array();
  407. $result['request_seq'] = $param['request_seq'];
  408. $result['code'] = 2;
  409. $result['msg'] = '请求失败';
  410. $result['data'] = array();
  411. if ($service == 'agreement_sign') {
  412. $result['code'] = 1;
  413. $result['msg'] = '请求成功';
  414. $result['data']['url'] = $url . '?' . http_build_query($send);
  415. return $result;
  416. }
  417. if ($this->test != 1) {
  418. $response = Dever::curl($url, $send, 'post');
  419. } else {
  420. # 数据模拟
  421. $response = $this->data($service, $param);
  422. }
  423. $result['data'] = $response;
  424. if ($response) {
  425. $response = Dever::json_decode($response);
  426. if (isset($response['res_code']) && ($response['res_code'] == '0000' || $response['res_code'] == '1446')) {
  427. $result['code'] = 1;
  428. $result['msg'] = '请求成功';
  429. $result['data'] = $response;
  430. } elseif (isset($response['res_msg']) && $response['res_msg']) {
  431. $result['code'] = 2;
  432. $result['msg'] = $response['res_msg'];
  433. $result['data'] = $response;
  434. } elseif (isset($response['apply_status_msg']) && $response['apply_status_msg']) {
  435. $result['code'] = 2;
  436. $result['msg'] = $response['apply_status_msg'];
  437. $result['data'] = $response;
  438. }
  439. }
  440. return $result;
  441. }
  442. private function data($service, $data)
  443. {
  444. $result = array();
  445. $result['res_code'] = '0000';
  446. $result['res_msg'] = 'ok';
  447. $result['request_seq'] = $data['request_seq'];
  448. if ($service == 'pic_upload') {
  449. $result['file_path'] = $data['request_seq'];
  450. $result['file_type'] = 'jpg';
  451. $result['file_size'] = strlen($result['file_path']);
  452. } elseif ($service == 'complex_upload') {
  453. $result['ums_reg_id'] = $data['request_seq'];
  454. } elseif ($service == 'agreement_sign') {
  455. $result['url'] = 'https://www.baidu.com/';
  456. } elseif ($service == 'apply_qry') {
  457. $result['apply_status'] = '03';
  458. $result['apply_status_msg'] = '入网成功(最终成功状态)';
  459. } elseif ($service == 'branch_bank_list') {
  460. $result['branchBankList'][] = array('code' => '308100005607', 'bankBranchName' => '招商银行股份有限公司北京天通苑支行');
  461. }
  462. return Dever::json_encode($result);
  463. }
  464. private function pic($pic)
  465. {
  466. $service = 'pic_upload';
  467. if ($pic) {
  468. $pic_base64 = $this->test != 1 ? file_get_contents($pic) : 'content';
  469. if ($pic_base64) {
  470. $temp = explode('?', $pic);
  471. if ($temp) {
  472. $one = pathinfo($temp[0]);
  473. } else {
  474. $one = pathinfo($pic);
  475. }
  476. $data['pic_base64'] = "data:image/".$one['extension'].";base64,".base64_encode($pic_base64);
  477. $result = $this->get($service, $data);
  478. return $result;
  479. }
  480. }
  481. return false;
  482. }
  483. # 查询支行
  484. private function bank_list($areaCode, $key)
  485. {
  486. $service = 'branch_bank_list';
  487. $data['areaCode'] = $areaCode;
  488. $data['key'] = $key;
  489. $result = $this->get($service,$data);
  490. return $result['data'];
  491. }
  492. # 记录日志
  493. private function log($step, $sign, $msg, $request = array(), $response = array(), $request_seq = '')
  494. {
  495. if (!$sign) {
  496. return $msg;
  497. }
  498. $data['step'] = $step;
  499. $data['merchant_id'] = $sign['merchant_id'];
  500. $data['desc'] = $msg;
  501. $info = false;
  502. if ($step == 4 || $step == 5) {
  503. $info = Dever::db('pay/yspay_sign_log')->find($data);
  504. }
  505. $admin = Dever::load('manage/auth.info');
  506. if ($admin) {
  507. $data['admin_id'] = $admin['id'];
  508. }
  509. if ($request_seq) {
  510. $data['request_seq'] = $request_seq;
  511. }
  512. if ($request) {
  513. $data['request'] = Dever::json_encode($request);
  514. }
  515. if ($response) {
  516. if (is_array($response)) {
  517. $response = Dever::json_encode($response);
  518. }
  519. $data['response'] = $response;
  520. }
  521. if ($info) {
  522. $data['where_id'] = $info['id'];
  523. Dever::db('pay/yspay_sign_log')->update($data);
  524. } else {
  525. Dever::db('pay/yspay_sign_log')->insert($data);
  526. }
  527. return $msg;
  528. }
  529. }