Soft_cash.php 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499
  1. <?php
  2. namespace Agent\Lib;
  3. use Dever;
  4. Class Soft_cash
  5. {
  6. public function updateSoft($id, $name, $data){
  7. // print_R($data);die;
  8. $mobile = Dever::param('mobile', $data);
  9. $cash = Dever::param('cash', $data);
  10. $price = Dever::param('price', $data);
  11. $pic = Dever::param('pic', $data);
  12. $status = Dever::param('status', $data);
  13. $audit = Dever::param('audit', $data);
  14. $audit_desc = Dever::param('audit_desc', $data);
  15. $cdate = Dever::param('cdate',$data);
  16. $buy_cdate = Dever::param('buy_cdate',$data);
  17. $soft = Dever::db('agent/soft_cash')->one($id);
  18. if($soft['mid']<0){
  19. $info = Dever::db('agent/member')->find(array('mobile'=>$soft['mobile']));
  20. }else{
  21. $info = Dever::db('agent/member')->find(array('id'=>$soft['mid']));
  22. }
  23. if($info){
  24. $update['where_id'] = $id;
  25. $update['set_mid'] = $info['id'];
  26. $update['set_role'] = $info['role'];
  27. if (!$soft['order_num']) {
  28. $update['set_order_num'] = $this->getOrderId($id);
  29. }
  30. if($cash){
  31. $update['set_cash'] = $cash;
  32. } else {
  33. $cash = $soft['cash'];
  34. }
  35. if($price){
  36. $update['set_price'] = $price;
  37. }
  38. if($pic){
  39. $update['set_pic'] = $pic;
  40. }
  41. if($status){
  42. $update['set_status'] = $status;
  43. }
  44. if($audit){
  45. $update['set_audit'] = $audit;
  46. }
  47. if($audit_desc){
  48. $update['set_audit_desc'] = $audit_desc;
  49. }
  50. if($soft){
  51. if($audit == 3 ){
  52. $update['set_status'] = 4;
  53. } elseif($audit == 2){
  54. $update['set_status'] = 3;
  55. $update['set_zdate'] = time();
  56. $order['role'] = $info['role'];
  57. $order['soft_cash'] = $cash;
  58. $order['price'] = $cash;
  59. $order['cdate'] = $cdate;
  60. $order['type'] = 3;
  61. $order['sign'] = '';
  62. $order['name'] = $info['name'];
  63. $order['mobile'] = $info['mobile'];
  64. $order['mid'] = $info['id'];
  65. $order['id'] = $id;
  66. $order['area'] = $info['area'];
  67. $order['idcard'] = $info['idcard'];
  68. $order['idcard_front'] = $info['idcard_front'];
  69. $order['idcard_back'] = $info['idcard_back'];
  70. $order['company_name'] = $info['company_name'];
  71. $order['company_pic'] = $info['company_pic'];
  72. // print_R($order);die;
  73. $update['set_agreement_id'] = Dever::load('agent/lib/agreement')->up($order,1,3);
  74. }
  75. }
  76. if (!$audit) {
  77. if ($soft['status'] == 4) {
  78. $update['status'] = 2;
  79. }
  80. }
  81. $ids=Dever::db('agent/soft_cash')->update($update);
  82. // echo Dever::sql();die;
  83. }
  84. }
  85. public function getOrderId($id)
  86. {
  87. $order = Dever::order();
  88. $info = Dever::db('agent/soft_cash')->one(array('order_num'=>$order));
  89. if ($info) {
  90. return $this->createOrderId($id);
  91. } else {
  92. return $order;
  93. }
  94. }
  95. public function soft_show($id){
  96. $info = Dever::db('agent/soft_cash')->find($id);
  97. $html['num'] = $info['order_num'].'</br>'.date('Y-m-d',$info['buy_date']).'<br/>'.date('Y-m-d',$info['cdate']);
  98. return $html;
  99. }
  100. public function show(){
  101. $id = Dever::input('id');
  102. $info = Dever::db('agent/soft_cash')->find($id);
  103. $member = Dever::db('agent/member')->find($info['mid']);
  104. $type = Dever::db('agent/member')->config['config_type'];
  105. $config_status = Dever::db('agent/soft_cash')->config['config_status'];
  106. $status = Dever::status($config_status,$info['status']);
  107. // print_R($status);die;
  108. $buy_date = date('Y-m-d H:i',$info['buy_date']);
  109. $role = Dever::db('setting/role')->one($member['role']);
  110. $area = Dever::load("area/api.string", $member['area']);
  111. $idcard_pic = '<a href="'.$member['idcard_front'].'" target="_blank"><img src="'.$member['idcard_front'].'" width="100" /></a>';
  112. if ($member['idcard_back']) {
  113. $idcard_pic .= '<a href="'.$member['idcard_back'].'" target="_blank"><img src="'.$member['idcard_back'].'" width="100" /></a>';
  114. }
  115. $picture = explode(',',$info['pic']);
  116. $pic = '';
  117. foreach ($picture as $k => $v){
  118. $pic .= '<a href="'.$v.'" target="_blank"><img src="'.$v.'" width="100" /></a>';
  119. }
  120. $result['订单信息'] = array
  121. (
  122. 'type' => 'info',
  123. 'content' => array
  124. (
  125. array
  126. (
  127. array('订单号', $info['order_num']),
  128. array('订单状态', $status),
  129. array('购买时间', $buy_date),
  130. ),
  131. array
  132. (
  133. array('备注', $info['audit_desc']),
  134. array('管理员备注', $info['admin_desc']),
  135. // array('购买时间', $buy_date),
  136. ),
  137. ),
  138. );
  139. $result['代理商信息'] = array
  140. (
  141. 'type' => 'info',
  142. 'content' => array
  143. (
  144. array
  145. (
  146. array('手机号', $member['mobile']),
  147. array('名称', $member['name']),
  148. array('类型', $type[$member['type']]),
  149. ),
  150. array
  151. (
  152. array('代理商角色', $role['name']),
  153. array('代理区域', $area),
  154. array('身份证号', $member['idcard']),
  155. ),
  156. array
  157. (
  158. array('身份证照片', $idcard_pic),
  159. ),
  160. ),
  161. );
  162. $result['费用信息'] = array
  163. (
  164. 'type' => 'info',
  165. 'content' => array
  166. (
  167. array
  168. (
  169. array('软件服务费', $info['cash']),
  170. array('原始期权价值', $info['price']),
  171. ),
  172. array
  173. (
  174. array('支付凭证', $pic),
  175. ),
  176. ),
  177. );
  178. $button = $this->show_button($info);
  179. if($info['status'] == 3 ){
  180. $member_goods = Dever::db('agent/member_agreement')->find($info['agreement_id']);
  181. if ($member_goods && $member_goods['sign']) {
  182. $sign_pic = '<a href="'.$member_goods['sign'].'" target="_blank"><img src="'.$member_goods['sign'].'" width="100" /></a>';
  183. } else {
  184. $sign_pic = '暂无';
  185. }
  186. $this->show_agreement($info, $role, $sign_pic, $result);
  187. }
  188. $head = array
  189. (
  190. 'name' => '基本信息',
  191. 'btn' => $button,
  192. );
  193. // $foot = $button;
  194. $html = Dever::show($head, $result);
  195. return $html;
  196. }
  197. public function show_button($info){
  198. $button = array();
  199. $purl = Dever::url('project/database/update?project=agent&table=soft_cash&where_id='.$info['id'].'&col=audit_desc', 'manage');
  200. $button[] = array
  201. (
  202. 'type' => 'edit',
  203. 'link' => $purl,
  204. 'name' => '备注',
  205. );
  206. $purl = Dever::url('project/database/update&project=agent&&page_type=2&table=soft_cash&menu=agent&search_option_state=1&where_id='.$info['id']);
  207. if($info['status'] < 3 || $info['status'] == 4){
  208. $button[] = array
  209. (
  210. 'type' => 'edit',
  211. 'link' => $purl,
  212. 'name' => '修改信息',
  213. );
  214. }
  215. $purl = Dever::url('project/database/update?project=agent&table=soft_cash&where_id='.$info['id'].'&audit=2&col=id,audit,audit_desc', 'manage');
  216. // if($aduit)
  217. if($info['status'] == 1){
  218. $button[] = array
  219. (
  220. 'type' => 'edit',
  221. 'link' => $purl,
  222. 'name' => '待业务初审',
  223. );
  224. }
  225. $purl = Dever::url('project/database/update?project=agent&table=soft_cash&where_id='.$info['id'].'&audit=2&col=id,audit,audit_desc', 'manage');
  226. if (Dever::load('manage/auth')->checkFunc('agent.soft_cash', 'edit1', '待财务终审')) {
  227. if($info['status'] == 2){
  228. $button[] = array
  229. (
  230. 'type' => 'edit',
  231. 'link' => $purl,
  232. 'name' => '待财务终审',
  233. );
  234. }
  235. }
  236. $purl = Dever::url('project/database/update?project=agent&table=soft_cash&where_id='.$info['id'].'&audit=3&col=id,audit,audit_desc', 'manage');
  237. if (Dever::load('manage/auth')->checkFunc('agent.soft_cash', 'edit2', '驳回')) {
  238. if($info['status'] == 4){
  239. }
  240. }
  241. if (Dever::load('manage/auth')->checkFunc('agent.soft_cash', 'close', '取消订单')) {
  242. if ($info['status'] == 4) {
  243. # 未完成审核的订单,可以随时挂起
  244. $button[] = array
  245. (
  246. 'type' => 'action',
  247. 'link' => Dever::url('lib/soft_cash.setOrderStatus?id=' . $info['id'] . '&value=4', 'agent'),
  248. 'name' => '取消订单',
  249. );
  250. }
  251. }
  252. $button[] = array
  253. (
  254. 'type' => 'link',
  255. 'link' => 'refer',
  256. 'name' => '返回上一页',
  257. );
  258. return $button;
  259. }
  260. public function setOrderStatus_api()
  261. {
  262. $where['where_id'] = Dever::input('id');
  263. $order = Dever::db('agent/soft_cash')->find($where['where_id']);
  264. if ($order) {
  265. $where['status'] = Dever::input('value');
  266. if ($where['status'] == 4) {
  267. $where['status'] = 5;
  268. $where['state'] = 2;
  269. }
  270. // print_R($where);die;
  271. Dever::db('agent/soft_cash')->update($where);
  272. }
  273. return 'reload';
  274. }
  275. private function show_agreement($info, $role, $sign_pic, &$result)
  276. {
  277. $table = array();
  278. $table['head'] = array('合同类型', '合同名称', '合同签名', '合同状态');
  279. $table['body'] = array();
  280. $agreement_type = Dever::db('setting/agreement')->config['config_type'];
  281. $agreement_status = Dever::db('agent/member_agreement')->config['status'];
  282. if($info['status'] == 3 && $info['agreement_id']){
  283. $agreement_title = '(已生成合同)';
  284. $agreement_button = array();
  285. $agreement = Dever::db('agent/member_agreement')->find(array('id' => $info['agreement_id']));
  286. if($agreement){
  287. $agreement_info = Dever::db('setting/agreement')->find($agreement['agreement_id']);
  288. // print_r($agreement_info);die;
  289. $agreement_status_name = Dever::status($agreement_status, $agreement['status']);
  290. // echo dever::sql();die;
  291. $table['body'] = array(Dever::status($agreement_type, $agreement_info['type']), Dever::load('agent/lib/agreement')->name($agreement_info, $agreement, $role, 2), $sign_pic, $agreement_status_name);
  292. }else{
  293. $agreement_title = '';
  294. }
  295. }
  296. $result['生成软件服务合同' . $agreement_title] = array
  297. (
  298. 'type' => 'table',
  299. 'head' => array('name' => '&nbsp;', 'btn' => $agreement_button),
  300. 'content' => $table
  301. );
  302. }
  303. public function insertSoft($id,$name,$data){
  304. $mobile = Dever::param('mobile',$data);
  305. $member = Dever::db('agent/member')->find(array('mobile'=>$mobile));
  306. if(!$member){
  307. Dever::alert('代理商不存在');
  308. }
  309. }
  310. public function search_api()
  311. {
  312. $value = Dever::input('value');
  313. if(!preg_match('/^1[3|5|6|7|8|9]\d{9}$/', $value)){
  314. return '代理商手机号不正确';
  315. }
  316. if ($value) {
  317. $data = Dever::db('agent/member')->one(array('mobile' => $value,'state' =>1));
  318. $table = array();
  319. if ($data) {
  320. $table = array();
  321. $table['head'] = array('序列号', '姓名', '手机号');
  322. $table['body'] = array();
  323. $table['body'] = array($data['id'], $data['name'], $data['mobile']);
  324. // foreach ($data as $k => $v) {
  325. // $member = Dever::db('agent/member')->find($v['mid']);
  326. // $table['body'][] = array($k+1, $member['name'], $v['mobile']);
  327. // }
  328. $result[] = array
  329. (
  330. 'type' => 'table',
  331. 'content' => $table,
  332. );
  333. $html = Dever::show('', $result, false, false);
  334. return $html;
  335. }else{
  336. return '代理商不存在';
  337. // Dever::alert('代理商不存在');
  338. }
  339. // Dever::alert('暂无账号');
  340. // return '暂无账号';
  341. } else {
  342. return '';
  343. }
  344. }
  345. public function list($id){
  346. $info = Dever::db('agent/soft_cash')->find(array('id'=>$id));
  347. $config_status = Dever::db('agent/soft_cash')->config['config_status'];
  348. $data['status'] = Dever::status($config_status,$info['status'],true);
  349. $config_type = Dever::db('agent/soft_cash')->config['config_type'];
  350. $data['type'] = Dever::status($config_type,$info['type']);
  351. if($info['zdate']){
  352. $data['zdate'] = date('Y-m-d H:i',$info['zdate']);
  353. }else{
  354. $data['zdate'] = '-';
  355. }
  356. if($info['fdate']){
  357. $data['fdate'] = date('Y-m-d H:i',$info['fdate']);
  358. }else{
  359. $data['fdate'] = '-';
  360. }
  361. // print_R($data);die;
  362. $html = $data['status'];
  363. $html .= '<br />' . $data['type'];
  364. $html .= '<br />' . $data['zdate'];
  365. $html .= '<br />' . $data['fdate'];
  366. return $html;
  367. }
  368. #数据导出
  369. public function out_soft_cash_api($data){
  370. $header = array('合同乙方', '手机号码', '身份证号码','合同总期数(年)', '合同类型', '签订日期', '合同金额', '购买日期', '录入日期', '终审日期');
  371. $body = array();
  372. $agreement_name = '';
  373. foreach($data as $k => $v){
  374. $member = Dever::db('agent/member')->find($v['mid']);
  375. $role = Dever::db('setting/role')->find($member['role']);
  376. $agreement = Dever::db('agent/member_agreement')->find(array('id'=>$v['agreement_id'],'mid'=>$v['mid']));
  377. if($agreement && $agreement['agreement_id']){
  378. $name = Dever::db('setting/agreement')->find(array('id'=>$agreement['agreement_id']));
  379. $config_type= Dever::db('setting/agreement')->config['config_type'];
  380. $agreement_name = Dever::status($config_type,$name['type']);
  381. }
  382. $type = 2;
  383. # 这里加判断
  384. if ($role['type'] == 2 && $role['area'] == 1) {
  385. $type = 1;
  386. } elseif ($v['cash'] > 6000 && $v['cash'] <= 30000 && $v['cash']%5000 == 0) {
  387. $type = 3;
  388. } elseif ($v['cash'] <= 6000 && $v['cash']%1000 == 0) {
  389. $type = 4;
  390. } else {
  391. $type = 2;
  392. }
  393. # 城市代理
  394. if ($type == 1) {
  395. $name = '城市代理版';
  396. $year = 1;
  397. }
  398. # 定制版
  399. elseif ($type == 2) {
  400. $name = '定制版';
  401. $year = 1;
  402. }
  403. # 升级版
  404. elseif ($type == 3) {
  405. $name = '升级版';
  406. $year = intval($v['cash']/5000);
  407. if ($year > 6) {
  408. $year = 6;
  409. }
  410. }
  411. # 基础版
  412. else {
  413. $name = '基础版';
  414. $year = intval($v['cash']/1000);
  415. if ($year > 6) {
  416. $year = 6;
  417. }
  418. }
  419. if($v['fdate']){
  420. $fdate = date('Y-m-d H:i',$v['fdate']);
  421. }else{
  422. $fdate = '-';
  423. }
  424. if($v['buy_date']){
  425. $buy_date = date('Y-m-d H:i',$v['buy_date']);
  426. }else{
  427. $buy_date = '-';
  428. }
  429. if($v['zdate']){
  430. $zdate = date('Y-m-d H:i',$v['zdate']);
  431. }else{
  432. $zdate = '-';
  433. }
  434. if($v['cdate']){
  435. $cdate = date('Y-m-d H:i',$v['cdate']);
  436. }else{
  437. $cdate = '-';
  438. }
  439. $d = array
  440. (
  441. $member['name'],
  442. $v['mobile'],
  443. $member['idcard'],
  444. $year,
  445. $name,
  446. $fdate,
  447. $v['cash'],
  448. $buy_date,
  449. $cdate,
  450. $zdate,
  451. );
  452. $body[] = $d;
  453. }
  454. $file = Dever::input('excel_name');
  455. return Dever::excelExport($body, $header, $file);
  456. }
  457. public function update_role_api(){
  458. $data = Dever::db('agent/soft_cash')->state();
  459. foreach($data as $k => $v){
  460. if(!$v['role']){
  461. $member = Dever::db('agent/member')->find($v['mid']);
  462. $where['where_id'] = $v['id'];
  463. $where['set_role'] = $member['role'];
  464. Dever::db('agent/soft_cash')->update($where);
  465. }
  466. if(!$v['fdate'] && $v['status'] == 3){
  467. $agreement = Dever::db('agent/member_agreement')->find(array('id'=>$v['agreement_id'],'mid'=>$v['mid']));
  468. $where['where_id'] = $v['id'];
  469. $where['set_type'] = $agreement['status'];
  470. $where['set_zdate'] = $agreement['qdate'];
  471. $where['set_fdate'] = $agreement['qdate'];
  472. Dever::db('agent/soft_cash')->update($where);
  473. }
  474. }
  475. }
  476. }