Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function index()
- {
- extract(populateform());
- if(isset($monthly)){
- $data['var'] = "Monthly";
- $data['tgl'] = $this->modelmodel->showdata("select MONTH(tanggal) Tanggal from transaksi
- where outlet = '".$this->session->userdata('username')."' group by
- MONTH(tanggal)");
- $data['angka'] = $this->modelmodel->showdata_monthly("select Outlet, month(tanggal),
- sum(cash + cc + dc + flash + piutang + reject + disc50) total
- from transaksi
- where outlet = '".$this->session->userdata('username')."'
- group by Outlet, month(tanggal)");
- }else if(isset($date_search)){
- $data['var'] = "Range Date";
- $explode = explode('-',$date_search);
- $start_date = inggris_date($explode[0]);
- $end_date = inggris_date($explode[1]);
- $data['tgl'] = $this->modelmodel->showdata("select MONTH(tanggal) Tanggal from transaksi
- where (tanggal between '$start_date' and '$end_date')and
- outlet = '".$this->session->userdata('username')."' group by
- MONTH(tanggal)");
- $data['angka'] = $this->modelmodel->showdata("select TOP 12 (cash + cc + dc + flash + piutang + reject + disc50)
- total from transaksi where (tanggal between '$start_date' and '$end_date')and
- outlet = '".$this->session->userdata('username')."'");
- }else{
- $data['tgl'] = $this->modelmodel->showdata("SELECT TOP 12 Tanggal From transaksi where outlet = '".$this->session->userdata('username')."' group by Tanggal order by tanggal desc");
- $data['angka'] = $this->modelmodel->showdata("select TOP 12 (cash + cc + dc + flash + piutang + reject + disc50) total from transaksi where outlet = '".$this->session->userdata('username')."'");
- $data['var'] = "Daily";
- }
- $view = 'dummy';
- $this->go_to($view,$data);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement