nizongfeng
/
ZZCS
1
0
派生 0
代码 工单 0 合并请求 0 版本发布 0 百科 动态
您最多选择25个主题 主题必须以字母或数字开头，可以包含连字符 (-)，并且长度不得超过35个字符
2 提交
1 分支
14 MiB
 
 
 
 
分支: master
分支列表 标签列表
${ item.name }
创建分支 ${ searchTerm }
从 'master'
${ noResults }
ZZCS/coding/application/lineManager/singleLine.class.php

554 行
24 KiB
原始文件 永久链接 Blame 文件历史 

  1. <?php

  2. 

  3. /**

  4.  * Created by PhpStorm.

  5.  * User: 张帅

  6.  * Date: 2016/10/12

  7.  * Time: 14:30

  8.  */

  9. class singleLine extends base

  10. {

  11.     /**

  12.      * @param line_id 线路id

  13.      * @param line_name 线路名称

  14.      * @param line_code 线路代码

  15.      * @param line_type 线路类型1

  16.      * @param line_sub_type 线路类型2

  17.      * @param time_type 时间类型

  18.      * @param time_info 时间

  19.      * @param supply_id 供应商id

  20.      * @param station_list 线路id  格式{上下车类型，站点顺序，到达用时，检票口，站点RES_ID,站点AREA_ID} 上下车类型： 108：上车 109:同时上下车 110：下客 114：不停靠；检票口目前默认都为0，如果有检票口需要在base_resource中配置

  21.      * @return array|null

  22.      * User: Steven

  23.      */

  24.     function addLine($param)

  25.     {

  26.         $valid = zzcsUtils::validateParams(array('line_name,line_code,line_type,line_sub_type,time_type,time_info,supply_id,station_list,allow_selected_seat' => 'empty'), $param);

  27.         if (!$valid['status']) {

  28.             $result['code'] = (string)$valid['status'];

  29.             $result['info'] = $valid['info'];

  30.             return $result;

  31.         }

  32.         $line_name = isset($param['line_name']) ? trim($param['line_name']) : false;//线路名称

  33.         $line_code = isset($param['line_code']) ? trim($param['line_code']) : false;//线路代码

  34.         $line_type = isset($param['line_type']) ? trim($param['line_type']) : false;//线路类型1

  35.         $line_sub_type = isset($param['line_sub_type']) ? trim($param['line_sub_type']) : false;//线路类型2

  36.         $time_type = isset($param['time_type']) ? trim($param['time_type']) : false;//时间类型

  37.         $time_info = isset($param['time_info']) ? trim($param['time_info']) : false;//时间

  38.         $supply_id = isset($param['supply_id']) ? trim($param['supply_id']) : false;//供应商id

  39.         //格式{上下车类型，站点顺序，到达用时，检票口，站点RES_ID,站点AREA_ID} 上下车类型： 108：上车 109:同时上下车 110：下客 114：不停靠；检票口目前默认都为0，如果有检票口需要在base_resource中配置

  40.         $station_list = isset($param['station_list']) ? trim($param['station_list']) : false;//站点列表

  41.         $allow_selected_seat = isset($param['allow_selected_seat']) ? trim($param['allow_selected_seat']) : false;//是否支持换座

  42.         $user_id = $this->user_id;

  43.         $data = [

  44.             'user_id'=>$user_id,

  45.             'line_name'=>$line_name,

  46.             'line_code'=>$line_code,

  47.             'line_type'=>$line_type,

  48.             'line_sub_type'=>$line_sub_type,

  49.             'time_type'=>$time_type,

  50.             'time_info'=>$time_info,

  51.             'supply_id'=>$supply_id,

  52.             'station_list'=>$station_list,

  53.             'allow_selected_seat'=>$allow_selected_seat,

  54.         ];

  55.         $result=$this->httpRequest('http://'.CS1_DOMAIN.'/api/run-edit/add-line',$data);

  56. //        $sql_check = 'SELECT line_id count from opera_line WHERE line_code = \'' . $line_code . '\' AND cancel_flag = 0';

  57. //        $res_check = $this->query($sql_check);

  58. //        if (count($res_check) > 0) {

  59. //            $result['code'] = '3';

  60. //            $result['info'] = "线路编号已存在";

  61. //            return $result;

  62. //        }

  63. //        $sql = "CALL sp_add_line_station_xm(" . $user_id . ",'" . $line_name . "','" . $line_code . "'," . $line_type . "," . $line_sub_type . "," . $time_type . ",'" . $time_info . "'," . $supply_id . ",'" . $station_list  . "')";

  64. //        zzcsUtils::writeLog($sql);

  65. //        $result = $this->procQuery($sql);

  66. //        if ($result['code'] == 0) {

  67. //            $json['code'] = '0';

  68. //            $json['info'] = '添加线路成功';

  69. //            $json['line_id'] = $result['data'][0][0]['line_id'];

  70. //            $json['line_type'] = $line_type;

  71. //        } else {

  72. //            $json['code'] = $result['code'];

  73. //            $json['info'] = $result['info'];

  74. //        }

  75. //        echo json_encode($json);

  76.         return json_decode($result);

  77.     }

  78. 

  79.     function httpRequest($url, $data = null)

  80.     {

  81.         $ch = curl_init();

  82.         curl_setopt($ch, CURLOPT_URL, $url);

  83.         curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);

  84.         curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false);

  85.         if (!empty($data)) {

  86.             curl_setopt($ch, CURLOPT_POST, 1);

  87.             curl_setopt($ch, CURLOPT_POSTFIELDS, $data);

  88.         }

  89.         curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

  90.         $output = curl_exec($ch);

  91.         curl_close($ch);

  92.         return $output;

  93.     }

  94. 

  95.     /**

  96.      * 单一线路详情

  97.      * @param $param

  98.      */

  99.     function getLineDetail($param)

  100.     {

  101.         $line_id = isset($param['line_id']) ? trim($param['line_id']) : false;//线路id

  102.         if (!$line_id) {

  103.             $json['code'] = '2';

  104.             $json['info'] = '缺少必要参数';

  105.             return $json;

  106.         }

  107.         $data = array(

  108.             'line_id' => $line_id

  109.         );

  110.         $json = $this->httpRequest('http://' . CS1_DOMAIN . '/api/run-edit/get-line-detail', $data);

  111. //        $sql = "SELECT

  112. //                    l.tailor_flag,l.line_id,l.line_name,l.line_code,l.line_type,l.org_id,l.sale_expired_type,l.sale_expired_time,s.order_id,s.res_id,s.start_minutes,s.inout_type,s.checkport_res_id,s.area_id,s.distance,l.allow_select_seat

  113. //                FROM

  114. //                    opera_line AS l,

  115. //                    opera_station AS s

  116. //                WHERE

  117. //                    l.line_id = s.line_id

  118. //                AND l.cancel_flag = 0

  119. //                AND s.cancel_flag = 0

  120. //                AND l.line_id = " . $line_id;

  121. //        $line_info = $this->query($sql);

  122. //        if (count($line_info) == 0) {

  123. //            $json['code'] = '1';

  124. //            $json['info'] = '该线路配置不全';

  125. //            return $json;

  126. //        }

  127. //        foreach ($line_info as $k => $v) {

  128. //            if (!isset($line_base_info)) {

  129. //                $line_base_info['tailor_flag'] = $v['tailor_flag'];

  130. //                $line_base_info['line_id'] = $v['line_id'];

  131. //                $line_base_info['line_name'] = $v['line_name'];

  132. //                $line_base_info['line_code'] = $v['line_code'];

  133. //                $line_base_info['line_type'] = $v['line_type'];

  134. //                $line_base_info['org_id'] = $v['org_id'];

  135. //                $line_base_info['sale_expired_type'] = $v['sale_expired_type'];

  136. //                $line_base_info['sale_expired_time'] = $v['sale_expired_time'];

  137. //            }

  138. //            $res_base_info[$v['order_id']]['res_id'] = $v['res_id'];

  139. //            $res_base_info[$v['order_id']]['inout_type'] = $v['inout_type'];

  140. //            $res_base_info[$v['order_id']]['checkport_res_id'] = $v['checkport_res_id'];

  141. //            $res_base_info[$v['order_id']]['area_id'] = $v['area_id'];

  142. //            $res_base_info[$v['order_id']]['start_minutes'] = $v['start_minutes'];

  143. //            $res_base_info[$v['order_id']]['distance'] = $v['distance'];

  144. //        }

  145. //        ksort($res_base_info);

  146. //        foreach ($res_base_info as $order_id => $res_v) {

  147. //            $res_detail_info = $this->getStationInfo(array('res_id' => $res_v['res_id']));

  148. //            if ($res_detail_info['code'] != '0') {

  149. //                $json['code'] = '1';

  150. //                $json['info'] = '站点信息有误';

  151. //                return $json;

  152. //            }

  153. //            $res_detail_info = $res_detail_info['res_info'];

  154. //            foreach ($res_detail_info['parent_area'] as $k => $v) {

  155. //                if ($v['id'] == $res_v['area_id']) {

  156. //                    $res_detail_info['parent_area'][$k]['checked'] = '1';

  157. //                } else {

  158. //                    $res_detail_info['parent_area'][$k]['checked'] = '0';

  159. //                }

  160. //            }

  161. //            foreach ($res_detail_info['inout_type'] as $k => $v) {

  162. //                if ($v['id'] == $res_v['inout_type']) {

  163. //                    $res_detail_info['inout_type'][$k]['checked'] = '1';

  164. //                } else {

  165. //                    $res_detail_info['inout_type'][$k]['checked'] = '0';

  166. //                }

  167. //            }

  168. //            foreach ($res_detail_info['check_port'] as $k => $v) {

  169. //                if ($v['id'] == $res_v['checkport_res_id']) {

  170. //                    $res_detail_info['check_port'][$k]['checked'] = '1';

  171. //                } else {

  172. //                    $res_detail_info['check_port'][$k]['checked'] = '0';

  173. //                }

  174. //            }

  175. //            $res_detail_info['start_minutes'] = $res_v['start_minutes'];

  176. //            $res_detail_info['distance'] = $res_v['distance'];

  177. //            $res_array[$order_id] = $res_detail_info;

  178. //        }

  179. //        $json['code'] = '0';

  180. //        $json['info'] = '返回数据成功';

  181. //        $json['line_info'] = $line_base_info;

  182. //        $json['station_info'] = array_merge($res_array);

  183.         return json_decode($json);

  184.     }

  185. 

  186.     /**

  187.      * 获取线路列表配置信息

  188.      * @return mixed

  189.      */

  190.     function getLineListBase()

  191.     {

  192.         $res = $this->productLine();  //获取产品线

  193.         $supply = $this->getSupply();

  194.         $json['code'] = '0';

  195.         $json['info'] = '获取供应商列表成功';

  196.         $json['product_list'] = $res;

  197.         $json['supply_list'] = $supply;

  198.         return $json;

  199.     }

  200. 

  201.     /**

  202.      * 单一线路列表

  203.      * @param $param

  204.      */

  205.     function getLineList($post)

  206.     {

  207.         $page_size = isset($post['page_size']) ? trim($post['page_size']) : false;

  208.         $current_page = isset($post['current_page']) ? trim($post['current_page']) : false;

  209.         $line_code = isset($post['line_code']) ? (empty($post['line_code']) ? "''" : "'" . trim($post['line_code']) . "'") : false;

  210.         $supply_id = isset($post['supply_id']) ? trim($post['supply_id']) : false;

  211.         $line_status = isset($post['line_status']) ? trim($post['line_status']) : false;

  212.         $line_type = isset($post['line_type']) ? trim($post['line_type']) : false;

  213.         $tailor_type = isset($post['tailor_type']) ? $post['tailor_type'] : 0;

  214.         if (!$page_size || !$current_page || !$line_code || !$supply_id || !$line_type) {

  215.             $json['code'] = '2';

  216.             $json['info'] = '缺少必要参数';

  217.             return $json;

  218.         }

  219.         $where['line_type'] = $line_type;

  220.         $where['line_code'] = $line_code;

  221.         $where['supply_id'] = $supply_id;

  222.         $where['line_status'] = $line_status;

  223.         $where['tailor_type'] = $tailor_type;

  224.         $start_row = ($current_page - 1) * $page_size;

  225. 

  226.         $extra_sql = "";

  227.         if (isset($_COOKIE["opera_org_id"]) && mb_strlen($_COOKIE["opera_org_id"]) > 0) {

  228.             $extra_sql .= ' AND ORG_ID IN( ' . $_COOKIE["opera_org_id"] . ' ) ';

  229.         }

  230.         if (isset($_COOKIE["user_main_corp"]) && mb_strlen($_COOKIE["user_main_corp"]) > 0 && $_COOKIE["user_main_corp"] > 0) {

  231.             $extra_sql .= ' AND MAIN_CORP_ID IN( ' . $_COOKIE["user_main_corp"] . ' ) ';

  232.         }

  233. 

  234.         $search_line_type = "l.line_type = " . $where['line_type'] . ' AND l.tailor_type = ' . $where['tailor_type'];

  235. 

  236.         if ($where['line_type'] == 255) {

  237.             $search_line_type = "l.line_type IN (255,368) ";//一日游线路

  238.         }

  239.         $sql = "SELECT

  240.                     l.line_id,l.line_code,l.line_name,

  241.                     IFNULL((SELECT type_name FROM dict_type WHERE id = l.line_sub_type),'') AS line_sub_type,

  242.                     IFNULL((SELECT supplier_name FROM base_supplier WHERE id = l.org_id ), '' ) AS org_name,

  243.                     CASE l.if_disabled WHEN 0 THEN '启用' ELSE '停用' END AS disabled_status,

  244.                     count(t.id) AS cnt

  245.                 FROM

  246.                     opera_line AS l LEFT JOIN       

  247.                     (SELECT id,line_id FROM opera_tickets_group WHERE cancel_flag = 0) AS t

  248.                     ON l.line_id = t.line_id

  249.                 WHERE

  250.                     l.cancel_flag = 0

  251.                 AND {$search_line_type} 

  252.                 AND IF(TRIM(" . $where['line_code'] . ")='',0=0,(l.line_code LIKE CONCAT('%'," . $where['line_code'] . ",'%') OR l.line_name LIKE CONCAT('%'," . $where['line_code'] . ",'%')))

  253.                 AND IF(TRIM(" . $where['supply_id'] . ")=-1,0=0,l.org_id = " . $where['supply_id'] . ")

  254.                 AND IF(TRIM(" . $where['line_status'] . ")=-1,0=0,l.if_disabled = " . $where['line_status'] . ")" . $extra_sql . "

  255.                 GROUP BY

  256.                     l.line_id,l.line_code,l.line_name,l.line_sub_type,l.org_id,l.if_disabled

  257.                 ORDER BY

  258.                     l.line_id DESC

  259.                 LIMIT " . $start_row . "," . $page_size;

  260.         $line_list = $this->query($sql);

  261.         if (count($line_list) == 0) {

  262.             $json['code'] = '0';

  263.             $json['info'] = '没有符合的线路';

  264.             $json['line_list'] = array();

  265.             $json['page']['page_size'] = $page_size;

  266.             $json['page']['current_page'] = $current_page;

  267.             $json['page']['total_count'] = '0';

  268.             $json['page']['total_page'] = '0';

  269.             return $json;

  270.         }

  271. 

  272.         $count_sql = "SELECT

  273.                             count(line_id) as total_count

  274.                         FROM

  275.                             opera_line as l

  276.                         WHERE

  277.                             cancel_flag = 0

  278.                         AND {$search_line_type} 

  279.                         AND IF(TRIM(" . $where['line_code'] . ")='',0=0,(line_code LIKE CONCAT('%'," . $where['line_code'] . ",'%') OR line_name LIKE CONCAT('%'," . $where['line_code'] . ",'%')))

  280.                         AND IF(TRIM(" . $where['supply_id'] . ")=-1,0=0,org_id = " . $where['supply_id'] . ")

  281.                         AND IF(TRIM(" . $where['line_status'] . ")=-1,0=0,if_disabled = " . $where['line_status'] . ") " . $extra_sql;

  282.         $total_count = $this->query($count_sql);

  283.         $total_count = $total_count[0]['total_count'];

  284.         $total_page = ceil($total_count / $page_size);

  285.         $json['code'] = '0';

  286.         $json['info'] = '返回线路列表成功符合的线路';

  287.         $json['line_list'] = $line_list;

  288.         $json['page']['page_size'] = $page_size;

  289.         $json['page']['current_page'] = $current_page;

  290.         $json['page']['total_count'] = $total_count;

  291.         $json['page']['total_page'] = $total_page;

  292.         return $json;

  293.     }

  294. 

  295.     /**

  296.      * @param tailor_flag 接驳flag

  297.      * @param line_id 线路id

  298.      * @param line_name 线路名称

  299.      * @param line_code 线路代码

  300.      * @param line_type 线路类型1

  301.      * @param line_sub_type 线路类型2

  302.      * @param time_type 时间类型

  303.      * @param time_info 时间

  304.      * @param supply_id 供应商id

  305.      * @param station_list 线路id  格式{上下车类型，站点顺序，到达用时，检票口，站点RES_ID,站点AREA_ID} 上下车类型： 108：上车 109:同时上下车 110：下客 114：不停靠；检票口目前默认都为0，如果有检票口需要在base_resource中配置

  306.      * @return array|null

  307.      * User: Steven

  308.      */

  309.     function lineUpdate($param)

  310.     {

  311.         $valid = zzcsUtils::validateParams(array('line_id,line_name,line_code,line_type,line_sub_type,time_type,time_info,supply_id,station_list,allow_selected_seat' => 'empty'), $param);

  312.         if (!$valid['status']) {

  313.             $result['code'] = (string)$valid['status'];

  314.             $result['info'] = $valid['info'];

  315.             return $result;

  316.         }

  317.         $user_id = $this->user_id;

  318.         $data = [

  319.             'user_id'=>$this->user_id,

  320.             'line_code'=>$param['line_code'],

  321.             'line_id'=>$param['line_id'],

  322.             'line_name'=>$param['line_name'],

  323.             'line_type'=>$param['line_type'],

  324.             'line_sub_type'=>$param['line_sub_type'],

  325.             'time_type'=>$param['time_type'],

  326.             'time_info'=>$param['time_info'],

  327.             'supply_id'=>$param['supply_id'],

  328.             'station_list'=>$param['station_list'],

  329.             'tailor_flag'=>$param['tailor_flag'],

  330.             'allow_selected_seat'=>$param['allow_selected_seat']

  331. 

  332.         ];

  333.         $result=$this->httpRequest('http://'.CS1_DOMAIN.'/api/run-edit/upt-line',$data);

  334. //        $sql_check = 'SELECT line_id count FROM opera_line WHERE  cancel_flag = 0 AND line_code = \'' . $param['line_code'] . '\' AND line_id != ' . $param['line_id'];

  335. //        $res_check = $this->query($sql_check);

  336. //        if (count($res_check) > 0) {

  337. //            $result['code'] = '3';

  338. //            $result['info'] = "线路编号已存在";

  339. //            return $result;

  340. //        }

  341. //        $sql = "CALL sp_update_line_station_xm(" . $user_id . "," . $param['line_id'] . ",'" . $param['line_name'] . "','" . $param['line_code'] . "'," . $param['line_type'] . "," . $param['line_sub_type'] . "," . $param['time_type'] . ",'" . $param['time_info'] . "'," . $param['supply_id'] . ",'" . $param['station_list'] . "'," . $param['tailor_flag'] . "," . $param['allow_selected_seat'] . ")";

  342. //        zzcsUtils::writeLog($sql);

  343. //        $result = $this->procQuery($sql);

  344. //        if ($result['code'] == 0) {

  345. //            $json['code'] = '0';

  346. //            $json['info'] = '修改线路成功';

  347. //            $json['line_id'] = $param['line_id'];

  348. //            $json['line_type'] = $param['line_type'];

  349. //        } else {

  350. //            $json['code'] = $result['code'];

  351. //            $json['info'] = $result['info'];

  352. //        }

  353.         return json_decode($result);

  354.     }

  355. 

  356.     /**

  357.      * 单一线路启用

  358.      * @param $param

  359.      */

  360.     function lineStart($param)

  361.     {

  362.         //hyk

  363.         $line_id = isset($param['line_id']) ? trim($param['line_id']) : false;

  364.         if (!$line_id) {

  365.             $json['code'] = '2';

  366.             $json['info'] = '缺少必要参数';

  367.             return $json;

  368.         }

  369.         $update_time = date('Y-m-d h:i:s');//更新时间

  370.         $sql = "UPDATE opera_line SET if_disabled= 0 ,update_user_id=" . $this->user_id . " , update_time= '" . $update_time . "'  WHERE line_id IN(" . $line_id . ") AND cancel_flag =0";

  371.         $result = $this->exec($sql);

  372.         if ($result === false) {

  373.             $json['code'] = '1';

  374.             $json['info'] = '数据库异常';

  375.             return $json;

  376.         } else {

  377.             $json['code'] = '0';

  378.             $json['info'] = '更新成功';

  379.             return $json;

  380. 

  381.         }

  382.     }

  383. 

  384.     /**

  385.      * 单一线路停用

  386.      * @param $param

  387.      */

  388.     function lineStop($param)

  389.     {

  390.         //hyk

  391.         $line_id = isset($param['line_id']) ? trim($param['line_id']) : false;

  392.         if (!$line_id) {

  393.             $json['code'] = '2';

  394.             $json['info'] = '缺少必要参数';

  395.             return $json;

  396.         }

  397.         $update_time = date('Y-m-d h:i:s');//更新时间

  398.         $sql = "UPDATE opera_line SET if_disabled= 1,update_user_id=" . $this->user_id . " , update_time= '" . $update_time . "' WHERE line_id IN(" . $line_id . ") AND cancel_flag =0";

  399.         $result = $this->exec($sql);

  400.         if ($result === false) {

  401.             $json['code'] = '1';

  402.             $json['info'] = '数据库异常';

  403.             return $json;

  404.         } else {

  405.             $json['code'] = '0';

  406.             $json['info'] = '更新成功';

  407.             return $json;

  408. 

  409.         }

  410.     }

  411. 

  412.     /**

  413.      * 获取添加线路的基础信息

  414.      * @param $param OK

  415.      */

  416.     function getBaseManager()

  417.     {

  418.         //1.售卖情况时间列表

  419.         $time_type = $this->getTimeType();

  420.         //2.巴士类型表

  421.         $bus_type = $this->getBusType();

  422.         //3.供应商列表

  423.         $supply_list = $this->getSupply();

  424.         $json['code'] = '0';

  425.         $json['info'] = '返回数据成功';

  426.         $json['bus_type'] = $bus_type;

  427.         $json['supply_list'] = $supply_list;

  428.         $json['time_type'] = $time_type;

  429.         return $json;

  430.     }

  431. 

  432.     /**

  433.      * 获取全部站点

  434.      * @param $param

  435.      */

  436.     function getLineStation($post)

  437.     {

  438.         $res_name = trim($post['res_name']);//输入框输入的站点信息

  439.         $sql = "SELECT

  440.                     res_id,

  441.                     res_name

  442.                 FROM

  443.                     base_resource

  444.                 WHERE

  445.                     res_type_id = 24

  446.                 AND cancel_flag = 0

  447.                 AND res_name LIKE '%" . $res_name . "%'";

  448.         $res_list = $this->query($sql);//场站列表

  449.         $json['code'] = '0';

  450.         $json['info'] = '返回数据成功';

  451.         $json['res_list'] = $res_list;

  452.         return $json;

  453.     }

  454. 

  455.     /**

  456.      * 获取站点详情

  457.      * @param $param

  458.      */

  459.     function getStationInfo($post)

  460.     {

  461.         $res_id = trim($post['res_id']);//站点id

  462.         $check_area = "SELECT

  463.                             ifnull(area_id, 0) AS area_id

  464.                         FROM

  465.                             base_resource

  466.                         WHERE

  467.                             res_id = " . $res_id;

  468.         $area = $this->query($check_area);//场站列表

  469.         if ($area[0]['area_id'] == 0) {

  470.             $json['code'] = '1';

  471.             $json['info'] = '该站点无应用POI，请先配置应用POI！';

  472.             return $json;

  473.         }

  474. 

  475.         //获取站点信息详情

  476.         $station_info = "SELECT

  477.                             a.res_id,

  478.                             a.res_name,

  479.                             IFNULL(concat(b.parent_area_id_list,'{',b.area_id,'}'),'') AS parent_area_id_list,

  480.                             IFNULL(concat(b.parent_area_name_list,'{',b.area_name,'}'),'') AS parent_area_name_list,

  481.                             IFNULL(

  482.                                 (

  483.                                     SELECT

  484.                                         group_concat(res_id)

  485.                                     FROM

  486.                                         base_resource

  487.                                     WHERE

  488.                                         res_type_id = 79

  489.                                     AND cancel_flag = 0

  490.                                     AND parent_id = a.res_id

  491.                                 ),

  492.                                 0

  493.                             ) AS checkport_res_id,

  494.                             IFNULL(

  495.                                 (

  496.                                     SELECT

  497.                                         group_concat(res_name)

  498.                                     FROM

  499.                                         base_resource

  500.                                     WHERE

  501.                                         res_type_id = 79

  502.                                     AND cancel_flag = 0

  503.                                     AND parent_id = a.res_id

  504.                                 ),

  505.                                 ''

  506.                             ) AS checkport_res_name

  507.                         FROM

  508.                             base_resource a

  509.                         LEFT JOIN base_area_view b ON a.area_id = b.area_id

  510.                         WHERE

  511.                             a.cancel_flag = 0

  512.                         AND a.res_id = " . $res_id;

  513.         $res_info = $this->query($station_info);//场站详情

  514.         $res_info = $res_info[0];

  515.         $res_info['parent_area_id_list'] = substr($res_info['parent_area_id_list'], 1, -1);

  516.         $res_info['parent_area_name_list'] = substr($res_info['parent_area_name_list'], 1, -1);

  517.         $res_info['parent_area_id_list'] = explode("}{", $res_info['parent_area_id_list']);//应用POI站点id数组

  518.         $res_info['parent_area_name_list'] = explode("}{", $res_info['parent_area_name_list']);//应用POI站点name数组

  519.         $res_info['checkport_res_id'] = explode(",", $res_info['checkport_res_id']);//检票口id数组

  520.         $res_info['checkport_res_name'] = explode(",", $res_info['checkport_res_name']);//检票口name数组

  521.         //规整返回前端的站点数据

  522.         $res = array();

  523.         $res['res_id'] = $res_info['res_id'];

  524.         $res['res_name'] = $res_info['res_name'];

  525.         foreach ($res_info['parent_area_id_list'] as $k => $v) {

  526.             $res['parent_area'][$k]['id'] = $v;

  527.             $res['parent_area'][$k]['name'] = $res_info['parent_area_name_list'][$k];

  528.         }

  529.         foreach ($res_info['checkport_res_id'] as $k => $v) {

  530.             $res['check_port'][$k]['id'] = $v;

  531.             $res['check_port'][$k]['name'] = $res_info['checkport_res_name'][$k];

  532.         }

  533.         $res['inout_type'] = array(

  534.             0 => array(

  535.                 'id' => '108',

  536.                 'name' => '上'

  537.             ),

  538.             1 => array(

  539.                 'id' => '109',

  540.                 'name' => '上下'

  541.             ),

  542.             2 => array(

  543.                 'id' => '110',

  544.                 'name' => '下'

  545.             )

  546.         );

  547. 

  548.         $json['code'] = '0';

  549.         $json['info'] = '返回数据成功';

  550.         $json['res_info'] = $res;

  551.         return $json;

  552.     }

  553. 

  554. }