// document.getElementById("full-screen").addEventListener("click", function(e) {
// toggleFullScreen();
// }, false);
function toggleFullScreen() {
if (!document.fullscreenElement) {
document.documentElement.requestFullscreen();
} else {
if (document.exitFullscreen) {
document.exitFullscreen();
}
}
}
db->get('tabel_toko', 1, 0);
$toko = $query->row();
$namatoko = $toko->almt_toko;
?>
session->userdata('akses');
$user = $this->session->userdata('ses_nama');
$kdtoko=$this->session->userdata('kd_toko');
$bmasuk= $this->db->query("select a.nobukti,a.tgl from stokheader a
left join stokheadera b on a.nobukti=b.nobukti
where a.tgl=curdate() and b.nobukti is null and a.kdcabang='$kdtoko' and a.st='0';") ;
$masuk=$bmasuk->row_array();
if(isset($masuk)) {
$nomasuk=$masuk['nobukti'];
}
$menit=date("i");
$reportwa="T";
$hak = $this->session->userdata('akses');
$user = $this->session->userdata('ses_nama');
$kdtoko=$this->session->userdata('kd_toko');
$caripromo=$this->db->query("SELECT 'Promo Berlangsung saat ini ' as nama,GROUP_CONCAT(CONCAT('No.ID : ',idprogram,' - ',namapromo,' ')) promo FROM promoheader WHERE stat='1' and tglawal<=curdate() and tglakhir>=curdate();");
$promo=$caripromo->row_array();
if(isset($promo)) {
$npromo=$promo['promo'];
}
$bmasuk= $this->db->query("select a.nobukti,a.tgl from sjheader a
left join stokheadera b on a.nobukti=b.nobukti
where a.tgl=curdate() and b.nobukti is null and a.kdcabang='$kdtoko' and a.st='0';") ;
$masuk=$bmasuk->row_array();
if(isset($masuk)) {
$nomasuk=$masuk['nobukti'];
}
$query_bkad = $this->db->query("SELECT bkad,stat_do FROM tabel_toko WHERE kd_toko='$kdtoko'");
if ($query_bkad->num_rows() > 0) {
$row_bkad = $query_bkad->row_array();
$status_bkad = $row_bkad['bkad'];
$status_do = $row_bkad['stat_do'];
}
$yog01qty=0;
$yog01qtyta=0;
$yog01qtydi=0;
$yog01qtypr=0;
$yog01qtyky=0;
$yog01qtydo=0;
$yog01qtybo=0;
$yog01qtyoj=0;
$yog01qtymw=0;
$yog01qtyju=0;
$yog02qty=0;
$yog02qtyta=0;
$yog02qtydi=0;
$yog02qtypr=0;
$yog02qtyky=0;
$yog02qtydo=0;
$yog02qtybo=0;
$yog02qtyoj=0;
$yog02qtymw=0;
$yog02qtyju=0;
$yog03qty=0;
$yog03qtyta=0;
$yog03qtydi=0;
$yog03qtypr=0;
$yog03qtyky=0;
$yog03qtydo=0;
$yog03qtybo=0;
$yog03qtyoj=0;
$yog03qtymw=0;
$yog03qtyju=0;
$yog04qty=0;
$yog04qtyta=0;
$yog04qtydi=0;
$yog04qtypr=0;
$yog04qtyky=0;
$yog04qtydo=0;
$yog04qtybo=0;
$yog04qtymw=0;
$yog05qty=0;
$yog05qtyta=0;
$yog05qtydi=0;
$yog05qtypr=0;
$yog05qtyky=0;
$yog05qtydo=0;
$yog05qtybo=0;
$yog05qtymw=0;
$yog06qty=0;
$yog06qtyta=0;
$yog06qtydi=0;
$yog06qtypr=0;
$yog06qtyky=0;
$yog06qtydo=0;
$yog06qtybo=0;
$yog06qtyoj=0;
$yog06qtymw=0;
$yog07qty=0;
$yog07qtyta=0;
$yog07qtydi=0;
$yog07qtypr=0;
$yog07qtyky=0;
$yog07qtydo=0;
$yog07qtybo=0;
$yog07qtyoj=0;
$yog07qtymw=0;
$yog07qtyju=0;
$yog08qty=0;
$yog08qtyta=0;
$yog08qtydi=0;
$yog08qtypr=0;
$yog08qtyky=0;
$yog08qtydo=0;
$yog08qtybo=0;
$yog08qtyoj=0;
$yog08qtymw=0;
$njk02qty=0;
$njk02qtyta=0;
$njk02qtydi=0;
$njk02qtypr=0;
$njk03qty=0;
$njk03qtyta=0;
$njk03qtydi=0;
$njk03qtypr=0;
$jbg01qty=0;
$jbg01qtyta=0;
$jbg01qtydi=0;
$jbg01qtypr=0;
$jbg02qty=0;
$jbg02qtyta=0;
$jbg02qtydi=0;
$jbg02qtypr=0;
$mjk01qty=0;
$mjk01qtyta=0;
$mjk01qtydi=0;
$mjk01qtypr=0;
$mjk02qty=0;
$mjk02qtyta=0;
$mjk02qtydi=0;
$mjk02qtypr=0;
$mjk03qty=0;
$mjk03qtyta=0;
$mjk03qtydi=0;
$mjk03qtypr=0;
$mjk04qty=0;
$mjk04qtyta=0;
$mjk04qtydi=0;
$mjk04qtypr=0;
$mjk05qty=0;
$mjk05qtyta=0;
$mjk05qtydi=0;
$mjk05qtypr=0;
$mlg01qty=0;
$mlg01qtyta=0;
$mlg01qtydi=0;
$mlg01qtypr=0;
$yog01qtyst=0;
$yog02qtyst=0;
$yog03qtyst=0;
$yog04qtyst=0;
$yog05qtyst=0;
$yog06qtyst=0;
$yog07qtyst=0;
$yog08qtyst=0;
$njk02qtyst=0;
$njk03qtyst=0;
$jbg01qtyst=0;
$jbg02qtyst=0;
$mjk01qtyst=0;
$mjk02qtyst=0;
$mjk03qtyst=0;
$mjk04qtyst=0;
$mjk05qtyst=0;
$mlg01qtyst=0;
$report=$this->db->query("select * from reportwa where stat='0' and tgl=curdate();");
$statwa=$this->db->query("select strukwa,reportwa from system;")->row_array();
$jamstat='';
$statsawung = $statwa['strukwa'];
$appkey = $statwa['reportwa'];
$wa=$report->row_array();
if(isset($wa)) {
$reportwa="Y";
$jamstat=$wa['jam'];
$yog01=$this->db->query("SELECT *,sum(juice) jus,sum(mentai) mt from reporting where kdcabang='yog01' AND (jenis='1' or jenis='3') and tgl=curdate();");
$yog02=$this->db->query("SELECT *,sum(juice) jus,sum(mentai) mt from reporting where kdcabang='yog10' AND (jenis='1' or jenis='3') and tgl=curdate();");
$yog03=$this->db->query("SELECT *,sum(juice) jus,sum(mentai) mt from reporting where kdcabang='yog03' AND (jenis='1' or jenis='3') and tgl=curdate();");
$yog04=$this->db->query("SELECT * from reporting where kdcabang='yog04' AND jenis='1' and tgl=curdate();");
$yog05=$this->db->query("SELECT * from reporting where kdcabang='yog05' AND jenis='1' and tgl=curdate();");
$yog06=$this->db->query("SELECT * from reporting where kdcabang='yog06' AND jenis='1' and tgl=curdate();");
$yog07=$this->db->query("SELECT *,sum(juice) jus,sum(mentai) mt from reporting where kdcabang='yog07' AND (jenis='1' or jenis='3') and tgl=curdate();");
$yog08=$this->db->query("SELECT *,sum(juice) jus,sum(mentai) mt from reporting where kdcabang='yog08' AND (jenis='1' or jenis='3') and tgl=curdate();");
$njk02=$this->db->query("SELECT * from reporting where kdcabang='NJK02' AND jenis='1' and tgl=curdate();");
$njk03=$this->db->query("SELECT * from reporting where kdcabang='NJK03' AND jenis='1' and tgl=curdate();");
$jbg01=$this->db->query("SELECT * from reporting where kdcabang='JBG01' AND jenis='1' and tgl=curdate();");
$jbg02=$this->db->query("SELECT * from reporting where kdcabang='JBG03' AND jenis='1' and tgl=curdate();");
$mjk01=$this->db->query("SELECT * from reporting where kdcabang='MJK01' AND jenis='1' and tgl=curdate();");
$mjk02=$this->db->query("SELECT * from reporting where kdcabang='MJK02' AND jenis='1' and tgl=curdate();");
$mjk03=$this->db->query("SELECT * from reporting where kdcabang='MJK03' AND jenis='1' and tgl=curdate();");
$mjk04=$this->db->query("SELECT * from reporting where kdcabang='MJK04' AND jenis='1' and tgl=curdate();");
$mjk05=$this->db->query("SELECT * from reporting where kdcabang='MJK05' AND jenis='1' and tgl=curdate();");
$mlg01=$this->db->query("SELECT * from reporting where kdcabang='MLG01' AND jenis='1' and tgl=curdate();");
$jual1=$yog01->row_array();
$jual2=$yog02->row_array();
$jual3=$yog03->row_array();
$jual4=$yog04->row_array();
$jual5=$yog05->row_array();
$jual6=$yog06->row_array();
$jual7=$yog07->row_array();
$jual8=$yog08->row_array();
$jual9=$njk02->row_array();
$jual10=$njk03->row_array();
$jual11=$jbg01->row_array();
$jual12=$jbg02->row_array();
$jual13=$mjk01->row_array();
$jual14=$mjk02->row_array();
$jual15=$mjk03->row_array();
$jual16=$mjk04->row_array();
$jual17=$mjk05->row_array();
$jual18=$mlg01->row_array();
if(isset($jual1)) {
$yog01qty=$jual1['qty'];
$yog01qtyta=$jual1['qtyta'];
$yog01qtydi=$jual1['qtydi'];
$yog01qtypr=$jual1['qtypr'];
$yog01qtyky=$jual1['qtyky'];
$yog01qtydo=$jual1['jdo'];
// $yog01qtybo=$jual1['qtydo'];
$yog01qtybo=$jual1['qtybo'];
$yog01qtyoj=$jual1['qtyojol'];
$yog01qtymw=$jual1['qtymewah'];
$yog01qtymt=$jual1['mt'];
$yog01qtyju=$jual1['jus'];
}
if(isset($jual2)) {
$yog02qty=$jual2['qty'];
$yog02qtyta=$jual2['qtyta'];
$yog02qtydi=$jual2['qtydi'];
$yog02qtypr=$jual2['qtypr'];
$yog02qtyky=$jual2['qtyky'];
$yog02qtydo=$jual2['jdo'];
$yog02qtybo=$jual2['qtybo'];
$yog02qtyoj=$jual2['qtyojol'];
$yog02qtymw=$jual2['qtymewah'];
$yog02qtymt=$jual2['mt'];
$yog02qtyju=$jual2['jus'];
}
if(isset($jual3)) {
$yog03qty=$jual3['qty'];
$yog03qtyta=$jual3['qtyta'];
$yog03qtydi=$jual3['qtydi'];
$yog03qtypr=$jual3['qtypr'];
$yog03qtyky=$jual3['qtyky'];
$yog03qtydo=$jual3['jdo'];
$yog03qtybo=$jual3['qtybo'];
$yog03qtyoj=$jual3['qtyojol'];
$yog03qtymw=$jual3['qtymewah'];
$yog03qtyju=$jual3['jus'];
$yog03qtymt=$jual3['mt'];
}
if(isset($jual4)) {
$yog04qty=$jual4['qty'];
$yog04qtyta=$jual4['qtyta'];
$yog04qtydi=$jual4['qtydi'];
$yog04qtypr=$jual4['qtypr'];
$yog04qtypr=$jual4['qtypr'];
$yog04qtyky=$jual4['qtyky'];
$yog04qtydo=$jual4['jdo'];
$yog04qtybo=$jual4['qtybo'];
}
if(isset($jual5)) {
$yog05qty=$jual5['qty'];
$yog05qtyta=$jual5['qtyta'];
$yog05qtydi=$jual5['qtydi'];
$yog05qtypr=$jual5['qtypr'];
$yog05qtyky=$jual5['qtyky'];
$yog05qtydo=$jual5['jdo'];
$yog05qtybo=$jual5['qtybo'];
}
if(isset($jual6)) {
$yog06qty=$jual6['qty'];
$yog06qtyta=$jual6['qtyta'];
$yog06qtydi=$jual6['qtydi'];
$yog06qtypr=$jual6['qtypr'];
$yog06qtyky=$jual6['qtyky'];
$yog06qtydo=$jual6['jdo'];
$yog06qtybo=$jual6['qtybo'];
$yog06qtyoj=$jual6['qtyojol'];
$yog06qtymw=$jual6['qtymewah'];
}
if(isset($jual7)) {
$yog07qty=$jual7['qty'];
$yog07qtyta=$jual7['qtyta'];
$yog07qtydi=$jual7['qtydi'];
$yog07qtypr=$jual7['qtypr'];
$yog07qtyky=$jual7['qtyky'];
$yog07qtydo=$jual7['jdo'];
$yog07qtybo=$jual7['qtybo'];
$yog07qtyoj=$jual7['qtyojol'];
$yog07qtymw=$jual7['qtymewah'];
$yog07qtyju=$jual7['jus'];
$yog07qtymt=$jual7['mt'];
}
if(isset($jual8)) {
$yog08qty=$jual8['qty'];
$yog08qtyta=$jual8['qtyta'];
$yog08qtydi=$jual8['qtydi'];
$yog08qtypr=$jual8['qtypr'];
$yog08qtyky=$jual8['qtyky'];
$yog08qtydo=$jual8['jdo'];
$yog08qtybo=$jual8['qtybo'];
$yog08qtyoj=$jual8['qtyojol'];
$yog08qtymw=$jual8['qtymewah'];
$yog08qtymt=$jual8['mt'];
}
if(isset($jual9)) {
$njk02qty=$jual9['qty'];
$njk02qtyta=$jual9['qtyta'];
$njk02qtydi=$jual9['qtydi'];
$njk02qtypr=$jual9['qtypr'];
}
if(isset($jual10)) {
$njk03qty=$jual10['qty'];
$njk03qtyta=$jual10['qtyta'];
$njk03qtydi=$jual10['qtydi'];
$njk03qtypr=$jual10['qtypr'];
}
if(isset($jual11)) {
$jbg01qty=$jual11['qty'];
$jbg01qtyta=$jual11['qtyta'];
$jbg01qtydi=$jual11['qtydi'];
$jbg01qtypr=$jual11['qtypr'];
}
if(isset($jual12)) {
$jbg02qty=$jual12['qty'];
$jbg02qtyta=$jual12['qtyta'];
$jbg02qtydi=$jual12['qtydi'];
$jbg02qtypr=$jual12['qtypr'];
}
if(isset($jual13)) {
$mjk01qty=$jual13['qty'];
$mjk01qtyta=$jual13['qtyta'];
$mjk01qtydi=$jual13['qtydi'];
$mjk01qtypr=$jual13['qtypr'];
}
if(isset($jual14)) {
$mjk02qty=$jual14['qty'];
$mjk02qtyta=$jual14['qtyta'];
$mjk02qtydi=$jual14['qtydi'];
$mjk02qtypr=$jual14['qtypr'];
}
if(isset($jual15)) {
$mjk03qty=$jual15['qty'];
$mjk03qtyta=$jual15['qtyta'];
$mjk03qtydi=$jual15['qtydi'];
$mjk03qtypr=$jual15['qtypr'];
}
if(isset($jual16)) {
$mjk04qty=$jual16['qty'];
$mjk04qtyta=$jual16['qtyta'];
$mjk04qtydi=$jual16['qtydi'];
$mjk04qtypr=$jual16['qtypr'];
}
if(isset($jual17)) {
$mjk05qty=$jual17['qty'];
$mjk05qtyta=$jual17['qtyta'];
$mjk05qtydi=$jual17['qtydi'];
$mjk05qtypr=$jual17['qtypr'];
}
if(isset($jual18)) {
$mlg01qty=$jual18['qty'];
$mlg01qtyta=$jual18['qtyta'];
$mlg01qtydi=$jual18['qtydi'];
$mlg01qtypr=$jual18['qtypr'];
}
$syog01=$this->db->query("SELECT * from reporting where kdcabang='yog01' AND jenis='2' and tgl=curdate();");
$syog02=$this->db->query("SELECT * from reporting where kdcabang='yog10' AND jenis='2' and tgl=curdate();");
$syog03=$this->db->query("SELECT * from reporting where kdcabang='yog03' AND jenis='2' and tgl=curdate();");
$syog04=$this->db->query("SELECT * from reporting where kdcabang='yog04' AND jenis='2' and tgl=curdate();");
$syog05=$this->db->query("SELECT * from reporting where kdcabang='yog05' AND jenis='2' and tgl=curdate();");
$syog06=$this->db->query("SELECT * from reporting where kdcabang='yog06' AND jenis='2' and tgl=curdate();");
$syog07=$this->db->query("SELECT * from reporting where kdcabang='yog07' AND jenis='2' and tgl=curdate();");
$syog08=$this->db->query("SELECT * from reporting where kdcabang='yog08' AND jenis='2' and tgl=curdate();");
$snjk02=$this->db->query("SELECT * from reporting where kdcabang='NJK02' AND jenis='2' and tgl=curdate();");
$snjk03=$this->db->query("SELECT * from reporting where kdcabang='NJK03' AND jenis='2' and tgl=curdate();");
$sjbg01=$this->db->query("SELECT * from reporting where kdcabang='JBG01' AND jenis='2' and tgl=curdate();");
$sjbg02=$this->db->query("SELECT * from reporting where kdcabang='JBG03' AND jenis='2' and tgl=curdate();");
$smjk01=$this->db->query("SELECT * from reporting where kdcabang='MJK01' AND jenis='2' and tgl=curdate();");
$smjk02=$this->db->query("SELECT * from reporting where kdcabang='MJK02' AND jenis='2' and tgl=curdate();");
$smjk03=$this->db->query("SELECT * from reporting where kdcabang='MJK03' AND jenis='2' and tgl=curdate();");
$smjk04=$this->db->query("SELECT * from reporting where kdcabang='MJK04' AND jenis='2' and tgl=curdate();");
$smjk05=$this->db->query("SELECT * from reporting where kdcabang='MJK05' AND jenis='2' and tgl=curdate();");
$smlg01=$this->db->query("SELECT * from reporting where kdcabang='MLG01' AND jenis='2' and tgl=curdate();");
$stokan1=$syog01->row_array();
$stokan2=$syog02->row_array();
$stokan3=$syog03->row_array();
$stokan4=$syog04->row_array();
$stokan5=$syog05->row_array();
$stokan6=$syog06->row_array();
$stokan7=$syog07->row_array();
$stokan8=$syog08->row_array();
$stokan9=$snjk02->row_array();
$stokan10=$snjk03->row_array();
$stokan11=$sjbg01->row_array();
$stokan12=$sjbg02->row_array();
$stokan13=$smjk01->row_array();
$stokan14=$smjk02->row_array();
$stokan15=$smjk03->row_array();
$stokan16=$smjk04->row_array();
$stokan17=$smjk05->row_array();
$stokan18=$smlg01->row_array();
if(isset($stokan1)) { $yog01qtyst=$stokan1['qty']; }
if(isset($stokan2)) { $yog02qtyst=$stokan2['qty'];}
if(isset($stokan3)) {$yog03qtyst=$stokan3['qty'];}
if(isset($stokan4)) {$yog04qtyst=$stokan4['qty'];}
if(isset($stokan5)) {$yog05qtyst=$stokan5['qty'];}
if(isset($stokan6)) {$yog06qtyst=$stokan6['qty'];}
if(isset($stokan7)) {$yog07qtyst=$stokan7['qty'];}
if(isset($stokan8)) {$yog08qtyst=$stokan8['qty'];}
if(isset($stokan9)) {$njk02qtyst=$stokan9['qty'];}
if(isset($stokan10)) {$njk03qtyst=$stokan10['qty'];}
if(isset($stokan11)) {$jbg01qtyst=$stokan11['qty'];}
if(isset($stokan12)) {$jbg02qtyst=$stokan12['qty'];}
if(isset($stokan13)) {$mjk01qtyst=$stokan13['qty'];}
if(isset($stokan14)) {$mjk02qtyst=$stokan14['qty'];}
if(isset($stokan15)) {$mjk03qtyst=$stokan15['qty'];}
if(isset($stokan16)) {$mjk04qtyst=$stokan16['qty'];}
if(isset($stokan17)) {$mjk05qtyst=$stokan17['qty'];}
if(isset($stokan18)) {$mlg01qtyst=$stokan18['qty'];}
$kdrta=$yog01qtyta+$yog02qtyta+$yog03qtyta+$yog07qtyta+$yog08qtyta;
$kdrdi=$yog01qtydi+$yog02qtydi+$yog03qtydi+$yog07qtydi+$yog08qtydi;
$kdrpr=$yog01qtypr+$yog02qtypr+$yog03qtypr+$yog07qtypr+$yog08qtypr;
$kdrky=$yog01qtyky+$yog02qtyky+$yog03qtyky+$yog07qtyky+$yog08qtyky;
$kdr=$yog01qty+$yog02qty+$yog03qty+$yog07qty+$yog08qty;
$kdrst=$yog01qtyst+$yog02qtyst+$yog03qtyst+$yog07qtyst+$yog08qtyst;
$kdrdo=$yog01qtydo+$yog02qtydo+$yog03qtydo+$yog07qtydo+$yog08qtydo;
$kdrbo=$yog01qtydo+$yog02qtybo+$yog03qtybo+$yog07qtybo+$yog08qtybo;
$kdroj=$yog01qtyoj+$yog02qtyoj+$yog03qtyoj+$yog07qtyoj+$yog08qtyoj;
$kdrmw=$yog01qtymw+$yog02qtymw+$yog03qtymw+$yog07qtymw+$yog08qtymw;
$kdrju=$yog03qtyju+$yog07qtyju+$yog01qtyju+$yog02qtyju+$yog08qtyju;
$kdrmt=$yog01qtymt+$yog02qtymt+$yog03qtymt+$yog07qtymt+$yog08qtymt;
$timta=$mjk01qtyta+$mjk02qtyta+$mjk03qtyta+$mjk04qtyta+$mjk05qtyta+$jbg01qtyta+$jbg02qtyta;
$timdi=$mjk01qtydi+$mjk02qtydi+$mjk03qtydi+$mjk04qtydi+$mjk05qtydi+$jbg01qtydi+$jbg02qtydi;
$timpr=$mjk01qtypr+$mjk02qtypr+$mjk03qtypr+$mjk04qtypr+$mjk05qtypr+$jbg01qtypr+$jbg02qtypr;
$tim=$mjk01qty+$mjk02qty+$mjk03qty+$mjk04qty+$mjk05qty+$jbg01qty+$jbg02qty;
$timst=$mjk01qtyst+$mjk02qtyst+$mjk03qtyst+$mjk04qtyst+$mjk05qtyst+$jbg01qtyst+$jbg02qtyst;
$jamskr=date('d-m-Y - H:i');
}
?>