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'); } ?>