View difference between Paste ID: STnFrd8T and WKB31UX7

 <?php
  public function get_query_p3kp($id)
     {
       $this->db->select('b.nama_kota, a.id_unit_usaha, a.nilai_aset, a.sewa, SUM(c.biaya_produksi) AS biaya, a.nama_unit, ((a.kuli_dn_t_l)+(a.kuli_dn_t_p)) AS pekerja, SUM(c.hasil_produksi_rp) AS rp, SUM(c.hasil_produksi_kg) AS kg, d.*' );
       //$this->db->select('a.nama_unit');
       $this->db->from('unit_usaha as a');
       //$this->db->join('unit_usaha_bangunan as e', 'e.id_unit_usaha = a.id_unit  _usaha');
      // $this->db->join('unit_usaha_lahan as f', 'f.id_unit_usaha = a.id_unit_usaha');
 
       $this->db->join('kota as b', 'b.kode_kota = a.kota_unit');
       $this->db->join('unit_usaha_produk as c', 'c.id_unit_usaha = a.id_unit_usaha');
       $this->db->join('master_kbli as d', 'd.kode_kbli = c.kode_kbli');
       //$this->db->where('a.kota_unit', '3522');
 
        //$kota = $id['kota_unit'];
       /*if($id['kota_unit']){
           //$explodekota = explode(" ", $kota);
           foreach ($id['kota_unit'] as $ekota) {
               $this->db->or_where('a.kota_unit', $ekota);
              // $this->db->like('a.kota_unit', $ekota);
           }
             //$this->db->where($explodekota, $id['kota_unit']);
           $this->db->order_by('a.nama_unit', 'asc');
       }
       else{
          $this->db->order_by('b.nama_kota', 'asc');
       }
 
       if($id['jenis_kegiatan']){
           //$explodekota = explode(" ", $kota);
           foreach ($id['jenis_kegiatan'] as $jenis_kegiatan) {
               $this->db->or_where('d.kegiatan_usaha', $jenis_kegiatan);
              // $this->db->like('a.kota_unit', $ekota);
           }
             //$this->db->where($explodekota, $id['kota_unit']);
           $this->db->order_by('d.kegiatan_usaha', 'asc');
       }
       else{
          $this->db->order_by('d.kegiatan_usaha', 'asc');
-      if($id['kota_unit'] || $id['jenis_kegiatan'] || $id['skala_usaha'])
+
 
 
       //if($id['kota_unit'] || $id['jenis_kegiatan'] || $id['skala_usaha'])
-          $impjeniskegiatan = "";
+
           //$explodekota = explode(" ", $kota);
           $impkota = "";
           $impjeniskegiatan = NULL;
           $impeskalausaha = "";
           $ejeniskegiatan = '';
           $ekota = "";
-          if(is_array($id['kota_unit']))
+
           $kegiatankosong = array();
           $skalausahakosong =array();
           if(isset($id['kota_unit'])&& is_array($id['kota_unit']))
           {
               foreach ($id['kota_unit']  as $ekota)
               {
 
                   $kotakosong[] = "a.kota_unit = ".$ekota;
               }
               $impkota = implode(" OR ", $kotakosong);
-          if(is_array($id['jenis_kegiatan']))
+
 
 
           if(isset($id['jenis_kegiatan'])&& is_array($id['jenis_kegiatan']))
           {
               foreach ($id['jenis_kegiatan'] as $ejeniskegiatan)
               {
                   $kegiatankosong[] = "d.kegiatan_usaha ='".$ejeniskegiatan."'";
               }
-          if(is_array($id['skala_usaha']))
+
           }
 
           if(isset($id['skala_usaha'])&&is_array($id['skala_usaha']))
           {
               foreach ($id['skala_usaha'] as $eskalausaha)
               {
                   if($eskalausaha == 1)
                   {
                   $skalausahakosong[] = "c.biaya_produksi > 0 AND c.biaya_produksi <= 300000000";
                   }
                   if($eskalausaha == 2)
                   {
                   $skalausahakosong[] = "c.biaya_produksi > 300000000 AND c.biaya_produksi <= 2500000000";
                   }
                   if($eskalausaha == 3)
                   {
                   $skalausahakosong[] = "c.biaya_produksi > 2500000000 AND c.biaya_produksi <= 50000000000";
                   }
                   if($eskalausaha == 4)
                   {
                   $skalausahakosong[] = "c.biaya_produksi > 50000000000";
                   }
 
               }
               $impeskalausaha = implode(" OR ", $skalausahakosong);
-          if( $impjeniskegiatan == NULL || $impjeniskegiatan == '0' && $impkota == NULL || $impkota == '0' ) {
+
 
 
-          else if( $impkota == NULL || $impkota == '0' && $impeskalausaha == NULL || $impeskalausaha == '0' ){
+          if( $impjeniskegiatan == NULL   && $impkota == NULL ) {
               $gabung = "".$impeskalausaha."";
           }
-          else if(isset() == '0') {
+          else if( $impkota == NULL  && $impeskalausaha == NULL  ){
               $gabung = "".$impjeniskegiatan."";
 			  /*
           else {
               $gabung = "".$impkota."";
           }
 
 		*/
           }
 
           else {
               $gabung = "(".$impkota.") and (".$impjeniskegiatan.")";
           }
-      }
+
 
           $this->db->where($gabung);
             //$this->db->where($explodekota, $id['kota_unit']);
           $this->db->order_by('a.nama_unit', 'asc');
       }
-/*
+/*
-      if($id['skala_usaha']){
+
-          foreach ($id['skala_usaha'] as $eskalausaha) {
+
-                 if ($eskalausaha == 1)
+
-                  {
+
-              $this->db->or_where('c.biaya_produksi >', 0);
+
-              $this->db->where('c.biaya_produksi <=', 300000000);
+
-                   }
+       if(isset($id['jenis_kegiatan']))
-                  if ($eskalausaha == 2)
+	   {
-                  {
+             if ($id['jenis_kegiatan'] != NULL ){
-              $this->db->or_where('c.biaya_produksi >',300000000);
+				if(is_array($id['jenis_kegiatan']){
-              $this->db->where('c.biaya_produksi <=',2500000000);
+					foreach ($id['jenis_kegiatan'] as $ejeniskegiatan)
 					{
-                  if ($eskalausaha == 3)
+					  $kegiatankosong[] = "d.kegiatan_usaha ='".$ejeniskegiatan."'";
-                  {
+					  $this->db->or_where('d.kegiatan_usaha', $ejeniskegiatan );
-              $this->db->or_where('c.biaya_produksi >',2500000000);
+					}
-              $this->db->where('c.biaya_produksi <=',50000000000);
+					//$impjeniskegiatan = implode(" OR ", $kegiatankosong);
 
-                  if ($eskalausaha == 4)
+				}else{
-                  {
+					$this->db->where('d.kegiatan_usaha', $id['jenis_kegiatan']);
-              $this->db->or_where('c.biaya_produksi >',50000000000);
+				}
 			 }else{
 				echo "TIDAK ADA KEGIATAN";	//hapus kalau udah ketauan
-          $this->db->order_by('c.biaya_produksi', 'asc');
+			}
         }
       //$this->db->group_by('d.kegiatan_usaha');
-         $this->db->order_by('c.biaya_produksi', 'asc');
+
       $this->db->group_by(array("d.kegiatan_usaha", "a.nama_unit"));
 
      $query = $this->db->get();
-      /*if($id['skala_usaha']){
+
     }