public function getdetailorder_get()
        {
            $val=$this->M_login->validate_session();
            if ($val) {
                $token        = $this->input->get_request_header('token', TRUE);
                $session      = $this->M_login->getclient('token',$token);

                $id_order = $this->get('id_order');
                $id_dacen = $this->get('id_dacen');

                if ($id_order != null) {
                    $sql12 = "SELECT * FROM t_checklist a
                    LEFT JOIN t_order o ON a.id_checklist = o.id_checklist
                    LEFT JOIN p_mapping_asset h ON a.id_mapping_asset = h.id_mapping_asset
                    LEFT JOIN p_floor i ON h.id_floor = i.id_floor
                    LEFT JOIN p_sector j ON i.id_sector = j.id_sector
                    LEFT JOIN p_dacen b ON j.id_dacen = b.id_dacen
                    LEFT JOIN p_checkperiode c ON a.id_checkperiode = c.id_checkperiode
                    LEFT JOIN p_shift_sch k ON a.id_shift_sch = k.id_shift_sch
                    LEFT JOIN p_shift d ON k.id_shift = d.id_shift
                    LEFT JOIN p_emp e ON k.id_emp = e.id_emp
                    LEFT JOIN p_checktype f ON a.id_checktype = f.id_checktype
                    LEFT JOIN p_checkstatus g ON a.id_checkstatus = g.id_checkstatus
                    LEFT JOIN p_orderstatus op on op.id_orderstatus = o.id_orderstatus
                    WHERE  o.`id_order`='".$id_order."'
                    GROUP BY `id_order`";
                    $hasil = $this->db->query($sql12);
                    $hasil2['hasil2'] = $hasil->result_array();

                    $cekfloor = "SELECT DISTINCT(i.`id_floor`), i.*, j.*, k.* FROM t_checklist a
                    LEFT JOIN t_order o ON a.id_checklist = o.id_checklist
                    LEFT JOIN p_mapping_asset h ON a.id_mapping_asset = h.id_mapping_asset
                    LEFT JOIN p_floor i ON h.id_floor = i.id_floor
                    LEFT JOIN `p_floorcategory` k ON k.`id_floorcategory` = i.`id_floorcategory`
                    LEFT JOIN p_sector j ON i.id_sector = j.id_sector
                    LEFT JOIN p_dacen b ON j.id_dacen = b.id_dacen
                    WHERE  o.`id_order`='".$id_order."' and i.is_active = '1'";
                    $hasilfloor = $this->db->query($cekfloor);
                    $cf = $hasilfloor->result_array();

                    // $sql = $this->db->query("SELECT * FROM p_floorcategory
                    //  left joi");
                    $sql = $this->db->query("
                        SELECT
  *
                        FROM
                        p_floorcategory
                        LEFT JOIN `p_floor` ON `p_floor`.`id_floorcategory` = `p_floorcategory`.`id_floorcategory`
                        LEFT JOIN `p_mapping_asset` ON `p_mapping_asset`.`id_floor` = `p_floor`.`id_floor`
                        LEFT JOIN `t_checklist` ON `t_checklist`.`id_mapping_asset` = `p_mapping_asset`.`id_mapping_asset`
                        LEFT JOIN `t_order` ON `t_order`.`id_checklist` = `t_checklist`.`id_checklist`
                        WHERE `p_mapping_asset`.`is_active` = 1 AND `p_floor`.`is_active` = 1 AND `id_order` = '".$id_order."'
                        GROUP BY `p_floorcategory`.`id_floorcategory`");
                    $data1['floor_category'] = $sql->result_array();
                    $total = $sql->num_rows();

                    for($i=0;$i<count($data1['floor_category']);$i++){
                        $id_floorcategory = $data1['floor_category'][$i]['id_floorcategory'];
                        $floorcategory = $data1['floor_category'][$i]['floorcategory'];

                        // print_r($hasil2['hasil2']);

                        $sql2 = "SELECT * FROM p_floor f
                        LEFT JOIN p_sector s ON f.`id_sector` = s.`id_sector`
                        LEFT JOIN p_floorcategory fc ON f.`id_floorcategory` = fc.`id_floorcategory`
                        LEFT JOIN p_dacen d ON s.`id_dacen` = d.`id_dacen`
                        LEFT JOIN `p_mapping_asset`
                        ON `p_mapping_asset`.`id_floor` = f.`id_floor`
                        LEFT JOIN `t_checklist`
                        ON `t_checklist`.`id_mapping_asset` = `p_mapping_asset`.`id_mapping_asset`
                        LEFT JOIN `t_order`
                        ON `t_order`.`id_checklist` = `t_checklist`.`id_checklist`
                        WHERE f.`id_floorcategory`='".$id_floorcategory."' AND s.`id_dacen`='".$id_dacen."'
                        AND id_order = '".$id_order."'
                        AND `p_mapping_asset`.`is_active` = 1
                        AND f.`is_active` = 1
                        GROUP BY f.`id_floor` ";
                        $query = $this->db->query($sql2);
                        $data2['data2']= $query->result_array();

                        for($a=0;$a<count($data2['data2']);$a++){
                            $id_floor = $data2['data2'][$a]['id_floor'];
                            $floor_name = $data2['data2'][$a]['floor_name'];
                            $sectorsid = $data2['data2'][$a]['id_sector'];
                            $sectors = $data2['data2'][$a]['sectorname'];
                            $id_dacen = $data2['data2'][$a]['id_dacen'];

                            $sql3 = "SELECT `id_mapping_asset`,`p_asset`.*, p_floorcategory.* FROM `p_mapping_asset`
                            LEFT JOIN `p_asset` ON `p_asset`.`id_asset` = `p_mapping_asset`.`id_asset`
                            LEFT JOIN p_floor on p_floor.id_floor = p_mapping_asset.id_floor
                            LEFT JOIN p_floorcategory on p_floorcategory.id_floorcategory = p_floor.id_floorcategory
                            WHERE p_mapping_asset.`id_floor` = '".$id_floor."' AND `p_mapping_asset`.`is_active` = '1' and p_asset.is_active = '1' and p_floor.is_active = 1";
                            $query2 = $this->db->query($sql3);
                            $data3['data3']= $query2->result_array();

                            for ($b=0; $b < count($data3['data3']) ; $b++) {
                                $id_mapping_asset = $data3['data3'][$b]['id_mapping_asset'];
                                $id_asset = $data3['data3'][$b]['id_asset'];
                                $id_assettype = $data3['data3'][$b]['id_assettype'];
                                $asset_name = $data3['data3'][$b]['asset_name'];
                                $asset_sn = $data3['data3'][$b]['asset_sn'];
                                $production_year = $data3['data3'][$b]['production_year'];
                                $description = $data3['data3'][$b]['description'];
                                $id_vendor = $data3['data3'][$b]['id_vendor'];
                                $id_floorcategory = $data3['data3'][$b]['id_floorcategory'];

                                $assets[$b] = array(
                                    $data3['data3']

                                );


                            }

                            $sector[$a] = array(
                                "id_floor"      => $id_floor,
                                "floor_name"   => $floor_name,
                                "id_sector"     => $sectorsid,
                                "sector_name"   => $sectors,
                                "id_dacen"      => $id_dacen,
                                "assets"        => $data3['data3']
                            );


                        }


                        $detail[] = array(
                            "floor_category" => $floorcategory,
                            "floor" => $sector);

                        $asd['code']= 200;
                        $asd['message']= 'ok';
                        $asd['data'] = array( 'myorder' => $hasil->result_array(),
                            'floor' =>$detail);

                    }

                    if ($asd['data'] == null) {
                            $data['code']=200;
                            $data['message']='no data';
                            $data['data']=null;
                            $this->response($data, 200);
                    }else{
                        $this->response($asd, 200);
                    }



                }
            }
        }