//get data tenant from tipe utilitas
$tenant = $this->standmeter_model->get_data_meter($idunit, $bulk_tenant, $kode_ruang);
//$total = $this->standmeter_model->count_get_data_meter($idunit, $bulk_tenant, $kode_ruang);
$data_save = array();
foreach ($tenant as $row => $value)
{
if($this->master_model->cek_yes_or_no('tr_meter_listrik', array('idunit'=>$idunit, 'idruang'=>$value['idruang'], 'substr(periode,1,7)'=>substr($periode,0,7))) === FALSE)
{
//get last standmeter
$data_meter = $this->master_model->get_by_id_select_where_array('tr_meter_listrik', 'meter_akhir', array('idunit'=>$idunit,'idruang'=>$value['idruang'], 'periode' => $periode_sebelumnya))->row_array();
//get data from ruang
if(empty($data_meter['meter_akhir']))
{
$ruang = $this->master_model->get_by_id_select_where_array('ms_ruang', 'meteran_'.$label.'_akhir', array('idruang'=>$value['idruang'], 'idunit'=>$idunit))->row_array();
$meter_akhir = $ruang['meteran_'.$label.'_akhir'];
}
else
{
$meter_akhir = $data_meter['meter_akhir'];
}
$data_save[] = array(
'id_meter' => 'EL'.$row.'_'.$idunit.'_'.now(),
'idtenant' => $value['idtenant'],
'idruang' => $value['idruang'],
'idunit' => $idunit,
'kode_ruang' => $value['kode_ruang'],
'periode' => $periode,
'tgl_awal' => $tgl_awal,
'tgl_akhir' => $tgl_akhir,
'meter_awal' => $data_meter,
'faktor_meter' => '1',
'created_at' => date('Y-m-d H:i:s')
);
}
}
$this->db->insert_batch('tr_meter_listrik', $data_save);