perbaikan 101b

<?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'])
      {
          //$explodekota = explode(" ", $kota);
          $impkota = "";
          $impjeniskegiatan = NULL;
          $impeskalausaha = "";
          $ejeniskegiatan = '';
          $ekota = "";
          $kotakosong = array();
          $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(isset($id['jenis_kegiatan'])&& is_array($id['jenis_kegiatan']))
          {
              foreach ($id['jenis_kegiatan'] as $ejeniskegiatan)
              {
                  $kegiatankosong[] = "d.kegiatan_usaha ='".$ejeniskegiatan."'";
              }
              $impjeniskegiatan = implode(" OR ", $kegiatankosong);
          }

          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   && $impkota == NULL ) {
              $gabung = "".$impeskalausaha."";
          }
          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');
      }
/*
      else
      {
          $this->db->order_by('b.nama_kota', 'asc');
      }
*/

       if(isset($id['jenis_kegiatan']))
       {
             if ($id['jenis_kegiatan'] != NULL ){
                if(is_array($id['jenis_kegiatan']){
                    foreach ($id['jenis_kegiatan'] as $ejeniskegiatan)
                    {
                      $kegiatankosong[] = "d.kegiatan_usaha ='".$ejeniskegiatan."'";
                      $this->db->or_where('d.kegiatan_usaha', $ejeniskegiatan );
                    }
                    //$impjeniskegiatan = implode(" OR ", $kegiatankosong);

                }else{
                    $this->db->where('d.kegiatan_usaha', $id['jenis_kegiatan']);
                }
             }else{
                echo "TIDAK ADA KEGIATAN";  //hapus kalau udah ketauan
            }
        }
      //$this->db->group_by('d.kegiatan_usaha');
      //$this->db->group_by('a.kota_unit');*/
      $this->db->group_by(array("d.kegiatan_usaha", "a.nama_unit"));

     $query = $this->db->get();
     return $query;
    }