API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 7th, 2020
214
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 31.18 KB | None | 0 0
raw download clone embed print report
  1. public function search(Request $request)
  2.     {
  3.         // dd($request->all());
  4.         $user_type = user_type();
  5.         $org_id = org();
  6.         $currentPage = LengthAwarePaginator::resolveCurrentPage();
  7.         $perPage = 20;
  8.         if($request->Entries == 20 || $request->Entries == 40 || $request->Entries == 80 || $request->Entries == 120 || $request->Entries == 160){
  9.             session()->put('operatingPagi', $request->Entries);
  10.             $perPage =$request->Entries;
  11.         }
  12.         if(session()->get('operatingPagi')[0] != null){
  13.             $perPage =session()->get('operatingPagi');
  14.         }
  15.         session()->put('operatingPagi', $perPage);
  16.  
  17.         $start = ($currentPage-1)*$perPage;
  18.         $stt = 1;
  19.         // $strDate15 = strtotime("-15 day");
  20.         // $date15 = (date('Y-m-d', $strDate15));
  21.         // Search Date
  22.         $searchDateStart ="";
  23.         if($request->dateStart != null)
  24.             $searchDateStart = "AND T.operating_date >= '$request->dateStart'";
  25.         $searchDateEnd="";
  26.         if($request->dateEnd != null) {
  27.             $searchDateEnd = "AND T.operating_date <= '$request->dateEnd'";
  28.         }
  29.         //end
  30.  
  31.         // Search Status
  32.         $searchStatus="";
  33.         if(!$request->status)
  34.             $request->status = 0;
  35.         if($request->status != 0 && !empty($request->status)){
  36.             if($request->status ==4){
  37.                 //bổ sung search ngày đi hàng trống
  38.                 $searchDateStart ="";
  39.                 $searchDateEnd="";
  40.                 $searchStatus = "AND T.operating_date IS NUll";
  41.                 //
  42.             }else{
  43.                 $searchStatus = "AND T.status = '$request->status'";
  44.             }
  45.         }
  46.         // end
  47.  
  48.         //form search
  49.         $search =[];
  50.         $search['search_car'] =['column'=>'tbl_car.car_num','default_column'=>'T.car_id'];
  51.         $search['search_car_type'] =['decrypt'=>'tbl_car.car_type_id','default_column'=>'tbl_car.car_type_id'];
  52.         $search['search_receipt'] =['column'=>'receipt_container.name_deposit','default_column'=>'T.receipt_place_id'];
  53.         $search['search_delivery'] =['column'=>'delivery.name','default_column'=>'T.delivery_place_id'];
  54.         $search['search_owner'] =['column'=>'tbl_partner.partner_short_name','default_column'=>'T.owner_id'];
  55.         $search['search_transport_partner'] =['column'=>'org_short_name','default_column'=>'T.transport_partner_id'];
  56.         $search['search_container_serial'] =['column'=>'T.container_serial','default_column'=>'T.container_serial'];
  57.         $search['search_container_seal'] =['column'=>'T.container_seal','default_column'=>'T.container_seal'];
  58.         $search['search_container_type'] =['column'=>'T.container_type','default_column'=>'T.container_type'];
  59.         $search['search_deposit'] =['column'=>'lowering_container.name_deposit','default_column'=>'T.lowering_container_id'];
  60.         $search['search_start_point'] =['column'=>'start_point.name_point','default_column'=>'T.start_point_id'];
  61.         $search['search_end_point'] =['column'=>'end_point.name_point','default_column'=>'T.end_point_id'];
  62.         $search['search_driver'] =['column'=>'driver.nick_name','default_column'=>'T.driver_id'];
  63.         $search['search_driver2'] =['column'=>'driver2.nick_name','default_column'=>'T.driver2_id'];
  64.         $search['search_assistant_driver'] =['column'=>'assistant.nick_name','default_column'=>'T.assistant_driver_id'];
  65.         $search['search_departure_time'] =['column'=>'T.departure_time','default_column'=>'T.departure_time'];
  66.         $search['search_trailer'] =['column'=>'tbl_trailer.trailer_num','default_column'=>'T.trailer_id'];
  67.         $search['search_trailer_type'] =['decrypt'=>'tbl_trailer.trailer_type_id','default_column'=>'tbl_trailer.trailer_type_id'];
  68.         $search['search_note1'] =['column'=>'T.container_note_1','default_column'=>'T.container_note_1'];
  69.         $search['search_note2'] =['column'=>'T.container_note_2','default_column'=>'T.container_note_2'];
  70.         $search['search_note3'] =['column'=>'T.note','default_column'=>'T.note'];
  71.         $search['search_tool1'] =['column'=>'tool_name','default_column'=>'tool_name'];
  72.         $search['search_tool2'] =['column'=>'tool_name','default_column'=>'tool_name'];
  73.         $search['search_clear_tank'] =['column'=>'tbl_clear_tank.clear_tank_name','default_column'=>'tbl_clear_tank.clear_tank_name'];
  74.         $search['search_curator'] =['column'=>'curator.nick_name','default_column'=>'T.curator_id'];
  75.         $search['search_ordershow'] =['column'=>'T.order_show','default_column'=>'T.order_show'];
  76.         $search['search_history'] =[];
  77.  
  78.         $search['search_lifting_cost'] =['column'=>'lifting_cost','default_column'=>'lifting_cost','value_not_0'=>'lifting_cost','complete_cost'=>'complete_lifting_cost'];
  79.         $search['search_lowering_cost'] =['column'=>'lowering_cost','default_column'=>'lowering_cost','value_not_0'=>'lowering_cost','complete_cost'=>'complete_lowering_cost'];
  80.         $search['search_surcharge_lifting_cost'] =['column'=>'surcharge_lifting_cost','default_column'=>'surcharge_lifting_cost','value_not_0'=>'surcharge_lifting_cost','complete_cost'=>'complete_surcharge_lifting_cost'];
  81.         $search['search_container_deposit_cost'] =['column'=>'container_deposit_cost','default_column'=>'container_deposit_cost','value_not_0'=>'container_deposit_cost','complete_cost'=>'complete_container_deposit_cost'];
  82.         $search['search_transport_cost'] =['column'=>'transport_cost','default_column'=>'transport_cost','value_not_0'=>'transport_cost','complete_cost'=>'complete_transport_cost'];
  83.         $search['search_transport_cost_foreign'] =['column'=>'transport_cost_foreign','default_column'=>'transport_cost_foreign','value_not_0'=>'transport_cost_foreign','complete_cost'=>'complete_transport_cost_foreign'];
  84.         $search['search_other_pay_cost_transport_partner'] =['column'=>'other_pay_cost_transport_partner','default_column'=>'other_pay_cost_transport_partner','value_not_0'=>'other_pay_cost_transport_partner','complete_cost'=>'complete_other_pay_cost_transport_partner'];
  85.         $search['search_advanced_salary'] =['column'=>'advanced_salary','default_column'=>'advanced_salary','value_not_0'=>'advanced_salary','complete_cost'=>'complete_advanced_salary'];
  86.         $search['search_lifting_lowering_cost'] =['column'=>'lifting_lowering_cost','default_column'=>'lifting_lowering_cost','value_not_0'=>'lifting_lowering_cost','complete_cost'=>'complete_lifting_lowering_cost'];
  87.         $search['search_surcharge_lifting_cost_1'] =['column'=>'surcharge_lifting_cost_1','default_column'=>'surcharge_lifting_cost_1','value_not_0'=>'surcharge_lifting_cost_1','complete_cost'=>'complete_surcharge_lifting_cost_1'];
  88.         $search['search_container_deposit_cost_1'] =['column'=>'container_deposit_cost_1','default_column'=>'container_deposit_cost_1','value_not_0'=>'container_deposit_cost_1','complete_cost'=>'complete_container_deposit_cost_1'];
  89.         $search['search_transport_cost_1'] =['column'=>'transport_cost_1','default_column'=>'transport_cost_1','value_not_0'=>'transport_cost_1','complete_cost'=>'complete_transport_cost_1'];
  90.         $search['search_other_pay_cost'] =['column'=>'other_pay_cost','default_column'=>'other_pay_cost','value_not_0'=>'other_pay_cost','complete_cost'=>'complete_other_pay_cost'];
  91.         $search['search_other_pay_cost_1'] =['column'=>'other_pay_cost_1','default_column'=>'other_pay_cost_1','value_not_0'=>'other_pay_cost_1','complete_cost'=>'complete_other_pay_cost_1'];
  92.         $search['search_other_pay_cost_2'] =['column'=>'other_pay_cost_2','default_column'=>'other_pay_cost_2','value_not_0'=>'other_pay_cost_2','complete_cost'=>'complete_other_pay_cost_2'];
  93.         $search['search_tire_cost'] =['column'=>'tire_cost','default_column'=>'tire_cost','value_not_0'=>'tire_cost','complete_cost'=>'complete_tire_cost'];
  94.         $search['search_road_cost'] =['column'=>'road_cost','default_column'=>'road_cost','value_not_0'=>'road_cost','complete_cost'=>'complete_road_cost'];
  95.         $search['search_repair_cost'] =['column'=>'repair_cost','default_column'=>'repair_cost','value_not_0'=>'repair_cost','complete_cost'=>'complete_repair_cost'];
  96.         $search['search_other_cost'] =['column'=>'other_cost','default_column'=>'other_cost','value_not_0'=>'other_cost','complete_cost'=>'complete_other_cost'];
  97.         $search['search_other_cost_1'] =['column'=>'other_cost_1','default_column'=>'other_cost_1','value_not_0'=>'other_cost_1','complete_cost'=>'complete_other_cost_1'];
  98.         $search['search_other_cost_2'] =['column'=>'other_cost_2','default_column'=>'other_cost_2','value_not_0'=>'other_cost_2','complete_cost'=>'complete_other_cost_2'];
  99.         $search['search_operating_oil'] =['column'=>'operating_oil','default_column'=>'operating_oil','value_not_0'=>'operating_oil','complete_cost'=>'complete_operating_oil'];
  100.         $search['search_operating_distance'] =['column'=>'operating_distance','default_column'=>'operating_distance','value_not_0'=>'operating_distance'];
  101.  
  102.         $searchTransport = "";
  103.         $search1 = "";
  104.         preg_match_all('/\d+/',$request->ContentSearch1 ,$value_search1_departure_time );
  105.         $value_search1_departure_time = $value_search1_departure_time[0] ? $value_search1_departure_time[0][0] : '0';
  106.         if($request->search1!=null && $request->ContentSearch1!=null && array_key_exists($request->search1,$search)){
  107.             if(array_key_exists('value_not_0',$search[$request->search1]) && $request->ContentSearch1 =='...'){
  108.                 $search1 = "AND ".$search[$request->search1]['value_not_0']." != '0'";
  109.             }elseif (array_key_exists('value_not_0',$search[$request->search1]) && $request->ContentSearch1 =='+++') {
  110.                 $search1 = "AND ".$search[$request->search1]['value_not_0']." > '0'";
  111.             }elseif (array_key_exists('value_not_0',$search[$request->search1]) && $request->ContentSearch1 =='---') {
  112.                 $search1 = "AND ".$search[$request->search1]['value_not_0']." < '0'";
  113.             }elseif (array_key_exists('value_not_0',$search[$request->search1]) && str_split($request->ContentSearch1, 1)[0] == '<') {
  114.                 $search1 = "AND ".$search[$request->search1]['value_not_0']." < '".explode('<', $request->ContentSearch1)[1]."'";
  115.             }elseif (array_key_exists('value_not_0',$search[$request->search1]) && str_split($request->ContentSearch1, 1)[0] == '>') {
  116.                 $search1 = "AND ".$search[$request->search1]['value_not_0']." > '".explode('>', $request->ContentSearch1)[1]."'";
  117.             }elseif (array_key_exists('complete_cost',$search[$request->search1]) && $request->ContentSearch1 ==',,,') {
  118.                 $search1 = "AND ".$search[$request->search1]['complete_cost']." = '1'";
  119.             }elseif (array_key_exists('decrypt',$search[$request->search1]) ) {
  120.                 $search1 = "AND ".$search[$request->search1]['decrypt']." = "._decrypt($request->ContentSearch1,'DieuXeCont')."";
  121.             }elseif ($request->search1 == "search_history" && $request->ContentSearch1 =='...') {
  122.                 $search1 = "AND (SELECT COUNT(ref_operating_id) FROM tbl_history_operating WHERE tbl_history_operating.ref_operating_id = T.operating_id) > 1";
  123.             }elseif ( ($request->search1 == "search_driver" || $request->search1 == "search_driver2" || $request->search1 == "search_assistant_driver" || $request->search1 == "search_container_serial" || $request->search1 == "search_clear_tank" || $request->search1 == "search_car" || $request->search1 == "search_trailer" || $request->search1 == "search_container_seal" || $request->search1 == "search_receipt" || $request->search1 == "search_delivery" || $request->search1 == "search_deposit") && $request->ContentSearch1 =='...') {
  124.                 $search1 = "AND ".$search[$request->search1]['default_column']." IS NOT NULL";
  125.             }elseif ($request->search1 == "search_transport_partner"){
  126.                 if($request->ContentSearch1 == '!!!'){
  127.                     $search1 = "AND ".$search[$request->search1]['default_column']." IS NOT NULL";
  128.                 }else{
  129.                     $searchTransport = "HAVING ".$search[$request->search1]['column']." LIKE '%$request->ContentSearch1%'";
  130.                 }
  131.             }elseif ($request->search1 == "search_tool1") {
  132.                 $request->ContentSearch1 = $request->ContentSearch1=='...' ? '' : $request->ContentSearch1;
  133.                 $searchTransport = "HAVING ".$search[$request->search1]['column']." LIKE '%1::$request->ContentSearch1%'";
  134.             }elseif ($request->search1 == "search_tool2") {
  135.                 $request->ContentSearch1 = $request->ContentSearch1=='...' ? '' : $request->ContentSearch1;
  136.                 $searchTransport = "HAVING ".$search[$request->search1]['column']." LIKE '%2::$request->ContentSearch1%'";
  137.             }elseif ($request->search1 == "search_departure_time" && str_split($request->ContentSearch1, 1)[0] == '<') {
  138.                 $searchTransport = "HAVING CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) <= ".$value_search1_departure_time;
  139.             }elseif ($request->search1 == "search_departure_time" && str_split($request->ContentSearch1, 1)[0] == '>') {
  140.                 $searchTransport = "HAVING CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) >= ".$value_search1_departure_time;
  141.             }elseif ($request->search1 == "search_container_type" && ($request->ContentSearch1=="X" || $request->ContentSearch1=="N")) {
  142.                 if($request->ContentSearch1=="X"){$arrContainerType = '(3,4,6)';}
  143.                 if($request->ContentSearch1=="N"){$arrContainerType = '(1,2,5)';}
  144.                 $search1 = "AND ".$search[$request->search1]['column']." IN $arrContainerType";
  145.             }else{
  146.                 $search1 = "AND ".$search[$request->search1]['column']." LIKE '%$request->ContentSearch1%'";
  147.             }
  148.         }elseif ($request->search1!=null && $request->ContentSearch1==null && array_key_exists($request->search1,$search)) {
  149.             if(array_key_exists('value_not_0',$search[$request->search1])){
  150.                 $search1 = "AND ".$search[$request->search1]['default_column']." = '0'";
  151.             }elseif ($request->search1 == "search_history") {
  152.                 $search1 = "AND (SELECT COUNT(ref_operating_id) FROM tbl_history_operating WHERE tbl_history_operating.ref_operating_id = T.operating_id) = 1";
  153.             }elseif ($request->search1 == "search_tool1") {
  154.                 $searchTransport = "HAVING ".$search[$request->search1]['default_column']." NOT LIKE '%1::%' OR tool_name IS NULL";
  155.             }elseif ($request->search1 == "search_tool2") {
  156.                 $searchTransport = "HAVING ".$search[$request->search1]['default_column']." NOT LIKE '%2::%' OR tool_name IS NULL";
  157.             }else{
  158.                 $search1 = "AND ".$search[$request->search1]['default_column']." IS NULL";
  159.             }
  160.         }
  161.         $search2 = "";
  162.         preg_match_all('/\d+/',$request->ContentSearch2 ,$value_search2_departure_time );
  163.         $value_search2_departure_time = $value_search2_departure_time[0] ? $value_search2_departure_time[0][0] : '0';
  164.         if($request->search2!=null && $request->ContentSearch2!=null && array_key_exists($request->search2,$search)){
  165.             if(array_key_exists('value_not_0',$search[$request->search2]) && $request->ContentSearch2 =='...'){
  166.                 $search2 = "AND ".$search[$request->search2]['value_not_0']." != '0'";
  167.             }elseif (array_key_exists('value_not_0',$search[$request->search2]) && $request->ContentSearch2 =='+++') {
  168.                 $search2 = "AND ".$search[$request->search1]['value_not_0']." > '0'";
  169.             }elseif (array_key_exists('value_not_0',$search[$request->search2]) && $request->ContentSearch2 =='---') {
  170.                 $search2 = "AND ".$search[$request->search2]['value_not_0']." < '0'";
  171.             }elseif (array_key_exists('value_not_0',$search[$request->search2]) && str_split($request->ContentSearch2, 1)[0] == '<') {
  172.                 $search2 = "AND ".$search[$request->search2]['value_not_0']." < '".explode('<', $request->ContentSearch2)[1]."'";
  173.             }elseif (array_key_exists('value_not_0',$search[$request->search2]) && str_split($request->ContentSearch2, 1)[0] == '>') {
  174.                 $search2 = "AND ".$search[$request->search2]['value_not_0']." > '".explode('>', $request->ContentSearch2)[1]."'";
  175.             }elseif (array_key_exists('complete_cost',$search[$request->search2]) && $request->ContentSearch2 ==',,,') {
  176.                 $search2 = "AND ".$search[$request->search2]['complete_cost']." = '1'";
  177.             }elseif (array_key_exists('decrypt',$search[$request->search2]) ) {
  178.                 $search2 = "AND ".$search[$request->search2]['decrypt']." = "._decrypt($request->ContentSearch2,'DieuXeCont')."";
  179.             }elseif ($request->search2 == "search_history" && $request->ContentSearch2 =='...') {
  180.                 $search2 = "AND (SELECT COUNT(ref_operating_id) FROM tbl_history_operating WHERE tbl_history_operating.ref_operating_id = T.operating_id) > 1";
  181.             }elseif ( ($request->search2 == "search_driver" || $request->search2 == "search_driver2" || $request->search2 == "search_assistant_driver" || $request->search2 == "search_container_serial" || $request->search2 == "search_clear_tank" || $request->search2 == "search_car" || $request->search2 == "search_trailer" || $request->search2 == "search_container_seal" || $request->search2 == "search_receipt" || $request->search2 == "search_delivery" || $request->search2 == "search_deposit") && $request->ContentSearch2 =='...') {
  182.                 $search2 = "AND ".$search[$request->search2]['default_column']." IS NOT NULL";
  183.             }elseif ($request->search2 == "search_transport_partner"){
  184.                 if($request->ContentSearch2 == '!!!'){
  185.                     $search2 = "AND ".$search[$request->search2]['default_column']." IS NOT NULL";
  186.                 }else{
  187.                     if($searchTransport==""){
  188.                         $searchTransport = "HAVING ".$search[$request->search2]['column']." LIKE '%$request->ContentSearch2%'";
  189.                     }else{
  190.                         $searchTransport .= " AND ".$search[$request->search2]['column']." LIKE '%$request->ContentSearch2%'";
  191.                     }
  192.                 }
  193.             }elseif ($request->search2 == "search_tool1") {
  194.                 $request->ContentSearch2 = $request->ContentSearch2=='...' ? '' : $request->ContentSearch2;
  195.                 if($searchTransport==""){
  196.                     $searchTransport = "HAVING ".$search[$request->search2]['column']." LIKE '%1::$request->ContentSearch2%'";
  197.                 }else{
  198.                     $searchTransport .= " AND ".$search[$request->search2]['column']." LIKE '%1::$request->ContentSearch2%'";
  199.                 }
  200.             }elseif ($request->search2 == "search_tool2") {
  201.                 $request->ContentSearch2 = $request->ContentSearch2=='...' ? '' : $request->ContentSearch2;
  202.                 if($searchTransport==""){
  203.                     $searchTransport = "HAVING ".$search[$request->search2]['column']." LIKE '%2::$request->ContentSearch2%'";
  204.                 }else{
  205.                     $searchTransport .= " AND ".$search[$request->search2]['column']." LIKE '%2::$request->ContentSearch2%'";
  206.                 }
  207.             }elseif ($request->search2 == "search_departure_time" && str_split($request->ContentSearch2, 1)[0] == '<') {
  208.                 if($searchTransport==""){
  209.                     $searchTransport = "HAVING CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) <= ".$value_search2_departure_time;
  210.                 }else{
  211.                     $searchTransport .= " AND CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) <= ".$value_search2_departure_time;
  212.                 }
  213.             }elseif ($request->search2 == "search_departure_time" && str_split($request->ContentSearch2, 1)[0] == '>') {
  214.                 if($searchTransport==""){
  215.                     $searchTransport = "HAVING CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) >= ".$value_search2_departure_time;
  216.                 }else{
  217.                     $searchTransport .= " AND CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) >= ".$value_search2_departure_time;
  218.                 }
  219.             }elseif ($request->search2 == "search_container_type" && ($request->ContentSearch2=="X" || $request->ContentSearch2=="N")) {
  220.                 if($request->ContentSearch2=="X"){$arrContainerType = '(3,4,6)';}
  221.                 if($request->ContentSearch2=="N"){$arrContainerType = '(1,2,5)';}
  222.                 $search2 = "AND ".$search[$request->search2]['column']." IN $arrContainerType";
  223.             }else{
  224.                 $search2 = "AND ".$search[$request->search2]['column']." LIKE '%$request->ContentSearch2%'";
  225.             }
  226.         }elseif ($request->search2!=null && $request->ContentSearch2==null && array_key_exists($request->search2,$search)) {
  227.             if(array_key_exists('value_not_0',$search[$request->search2])){
  228.                 $search2 = "AND ".$search[$request->search2]['default_column']." = '0'";
  229.             }elseif ($request->search2 == "search_history") {
  230.                 $search2 = "AND (SELECT COUNT(ref_operating_id) FROM tbl_history_operating WHERE tbl_history_operating.ref_operating_id = T.operating_id) = 1";
  231.             }elseif ($request->search2 == "search_tool1") {
  232.                 if($searchTransport==""){
  233.                     $searchTransport = "HAVING ".$search[$request->search2]['default_column']." NOT LIKE '%1::%' OR tool_name IS NULL";
  234.                 }else{
  235.                     $searchTransport .= " AND ".$search[$request->search2]['default_column']." NOT LIKE '%1::%' OR tool_name IS NULL";
  236.                 }
  237.             }elseif ($request->search2 == "search_tool2") {
  238.                 if($searchTransport==""){
  239.                     $searchTransport = "HAVING ".$search[$request->search2]['default_column']." NOT LIKE '%2::%' OR tool_name IS NULL";
  240.                 }else{
  241.                     $searchTransport .= " AND ".$search[$request->search2]['default_column']." NOT LIKE '%2::%' OR tool_name IS NULL";
  242.                 }
  243.             }else{
  244.                 $search2 = "AND ".$search[$request->search2]['default_column']." IS NULL";
  245.             }
  246.         }
  247.  
  248.         $search3 = "";
  249.         preg_match_all('/\d+/',$request->ContentSearch3 ,$value_search3_departure_time );
  250.         $value_search3_departure_time = $value_search3_departure_time[0] ? $value_search3_departure_time[0][0] : '0';
  251.         if($request->search3!=null && $request->ContentSearch3!=null && array_key_exists($request->search3,$search)){
  252.             if(array_key_exists('value_not_0',$search[$request->search3]) && $request->ContentSearch3 =='...'){
  253.                 $search3 = "AND ".$search[$request->search3]['value_not_0']." != '0'";
  254.             }elseif (array_key_exists('value_not_0',$search[$request->search3]) && $request->ContentSearch3 =='+++') {
  255.                 $search3 = "AND ".$search[$request->search3]['value_not_0']." > '0'";
  256.             }elseif (array_key_exists('value_not_0',$search[$request->search3]) && $request->ContentSearch3 =='---') {
  257.                 $search3 = "AND ".$search[$request->search3]['value_not_0']." < '0'";
  258.             }elseif (array_key_exists('value_not_0',$search[$request->search3]) && str_split($request->ContentSearch3, 1)[0] == '<') {
  259.                 $search3 = "AND ".$search[$request->search3]['value_not_0']." < '".explode('<', $request->ContentSearch3)[1]."'";
  260.             }elseif (array_key_exists('value_not_0',$search[$request->search3]) && str_split($request->ContentSearch3, 1)[0] == '>') {
  261.                 $search3 = "AND ".$search[$request->search3]['value_not_0']." > '".explode('>', $request->ContentSearch3)[1]."'";
  262.             }elseif (array_key_exists('complete_cost',$search[$request->search3]) && $request->ContentSearch3 ==',,,') {
  263.                 $search3 = "AND ".$search[$request->search3]['complete_cost']." = '1'";
  264.             }elseif (array_key_exists('decrypt',$search[$request->search3]) ) {
  265.                 $search3 = "AND ".$search[$request->search3]['decrypt']." = "._decrypt($request->ContentSearch3,'DieuXeCont')."";
  266.             }elseif ($request->search3 == "search_history" && $request->ContentSearch3 =='...') {
  267.                 $search3 = "AND (SELECT COUNT(ref_operating_id) FROM tbl_history_operating WHERE tbl_history_operating.ref_operating_id = T.operating_id) > 1";
  268.             }elseif ( ($request->search3 == "search_driver" || $request->search3 == "search_driver2" || $request->search3 == "search_assistant_driver" || $request->search3 == "search_container_serial" || $request->search3 == "search_clear_tank" || $request->search3 == "search_car" || $request->search3 == "search_trailer" || $request->search3 == "search_container_seal" || $request->search3 == "search_receipt" || $request->search3 == "search_delivery" || $request->search3 == "search_deposit") && $request->ContentSearch3 =='...' ) {
  269.                 $search3 = "AND ".$search[$request->search3]['default_column']." IS NOT NULL";
  270.             }elseif ($request->search3 == "search_transport_partner"){
  271.                 if($request->ContentSearch3 == '!!!'){
  272.                     $search3 = "AND ".$search[$request->search3]['default_column']." IS NOT NULL";
  273.                 }else{
  274.                     if($searchTransport==""){
  275.                         $searchTransport = "HAVING ".$search[$request->search3]['column']." LIKE '%$request->ContentSearch3%'";
  276.                     }else{
  277.                         $searchTransport .= " AND ".$search[$request->search3]['column']." LIKE '%$request->ContentSearch3%'";
  278.                     }
  279.                 }
  280.             }elseif ($request->search3 == "search_tool1") {
  281.                 $request->ContentSearch3 = $request->ContentSearch3=='...' ? '' : $request->ContentSearch3;
  282.                 if($searchTransport==""){
  283.                     $searchTransport = "HAVING ".$search[$request->search3]['column']." LIKE '%1::$request->ContentSearch3%'";
  284.                 }else{
  285.                     $searchTransport .= " AND ".$search[$request->search3]['column']." LIKE '%1::$request->ContentSearch3%'";
  286.                 }
  287.             }elseif ($request->search3 == "search_tool2") {
  288.                 $request->ContentSearch3 = $request->ContentSearch3=='...' ? '' : $request->ContentSearch3;
  289.                 if($searchTransport==""){
  290.                     $searchTransport = "HAVING ".$search[$request->search3]['column']." LIKE '%2::$request->ContentSearch3%'";
  291.                 }else{
  292.                     $searchTransport .= " AND ".$search[$request->search3]['column']." LIKE '%2::$request->ContentSearch3%'";
  293.                 }
  294.             }elseif ($request->search3 == "search_departure_time" && str_split($request->ContentSearch3, 1)[0] == '<') {
  295.                 if($searchTransport==""){
  296.                     $searchTransport = "HAVING CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) <= ".$value_search3_departure_time;
  297.                 }else{
  298.                     $searchTransport .= " AND CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) <= ".$value_search3_departure_time;
  299.                 }
  300.             }elseif ($request->search3 == "search_departure_time" && str_split($request->ContentSearch3, 1)[0] == '>') {
  301.                 if($searchTransport==""){
  302.                     $searchTransport = "HAVING CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) >= ".$value_search3_departure_time;
  303.                 }else{
  304.                     $searchTransport .= " AND CAST(REPLACE(LOWER(departure_time), 'đi', '') AS INTEGER) >= ".$value_search3_departure_time;
  305.                 }
  306.             }elseif ($request->search3 == "search_container_type" && ($request->ContentSearch3=="X" || $request->ContentSearch3=="N")) {
  307.                 if($request->ContentSearch3=="X"){$arrContainerType = '(3,4,6)';}
  308.                 if($request->ContentSearch3=="N"){$arrContainerType = '(1,2,5)';}
  309.                 $search3 = "AND ".$search[$request->search3]['column']." IN $arrContainerType";
  310.             }else{
  311.                 $search3 = "AND ".$search[$request->search3]['column']." LIKE '%$request->ContentSearch3%'";
  312.             }
  313.         }elseif ($request->search3!=null && $request->ContentSearch3==null && array_key_exists($request->search3,$search)) {
  314.             if(array_key_exists('value_not_0',$search[$request->search3])){
  315.                 $search3 = "AND ".$search[$request->search3]['default_column']." = '0'";
  316.             }elseif ($request->search3 == "search_history") {
  317.                 $search3 = "AND (SELECT COUNT(ref_operating_id) FROM tbl_history_operating WHERE tbl_history_operating.ref_operating_id = T.operating_id) = 1";
  318.             }elseif ($request->search3 == "search_tool1") {
  319.                 if($searchTransport==""){
  320.                     $searchTransport = "HAVING ".$search[$request->search3]['default_column']." NOT LIKE '%1::%' OR tool_name IS NULL";
  321.                 }else{
  322.                     $searchTransport .= " AND ".$search[$request->search3]['default_column']." NOT LIKE '%1::%' OR tool_name IS NULL";
  323.                 }
  324.             }elseif ($request->search3 == "search_tool2") {
  325.                 if($searchTransport==""){
  326.                     $searchTransport = "HAVING ".$search[$request->search3]['default_column']." NOT LIKE '%2::%' OR tool_name IS NULL";
  327.                 }else{
  328.                     $searchTransport .= " AND ".$search[$request->search3]['default_column']." NOT LIKE '%2::%' OR tool_name IS NULL";
  329.                 }
  330.             }else{
  331.                 $search3 = "AND ".$search[$request->search3]['default_column']." IS NULL";
  332.             }
  333.         }
  334.         //end
  335.         // dd($search1);
  336.         $checkCountAndGet = 1;
  337.         $sum = collect(OperatingContainer::countDataSearchOperatingContainer($searchDateStart,$searchDateEnd,$searchStatus,$searchTransport,$search1,$search2,$search3));
  338.         // $sumNoSearch = count(OperatingContainer::countDataSearchOperatingContainer());
  339.         // $allOperating = 1;
  340.         // if($sum->count() != $sumNoSearch)
  341.         //     $allOperating = _nonKeyEncrypt($sum->pluck('operating_id'),'DieuXeCont');
  342.         $allOperating = _nonKeyEncrypt($sum->pluck('operating_id'),'DieuXeCont');
  343.         $sum = $sum->count();
  344.  
  345.         $data = OperatingContainer::getListOperatingContainer($start,$perPage,$searchDateStart,$searchDateEnd,$searchStatus,$searchTransport,$search1,$search2,$search3);
  346.         for($countData = 0; $countData < count($data); $countData++){
  347.             $dataReturn = false;
  348.             $data[$countData]->operating_date ? $operating_date_data=date("Y-m-d",strtotime($data[$countData]->operating_date)) : $operating_date_data ="";
  349.             if($operating_date_data != ""){
  350.                 $dataReturn = checkLockEditDate::checkEditDate($data[$countData]->lock_edit_date,$operating_date_data,$data[$countData]->lock_edit_month);
  351.             };
  352.             $data[$countData]->lockedData = $dataReturn;
  353.         };
  354.         $data = _arrayEncrypt($data,['operating_id','user_id_driver','user_id_driver2','user_id_assistant'], 'DieuXeCont');
  355.         // dd($data);
  356.         $data = collect($data);
  357.         $operatingID = $data->pluck('operating_id');
  358.  
  359.         $table = new LengthAwarePaginator($data,$sum, $perPage);
  360.         $table->setPath(LengthAwarePaginator::resolveCurrentPath());
  361.         return view('OperatingContainer.index',compact('table','data','stt','operatingID','perPage','user_type','allOperating','org_id'));
  362.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!