Advertisement
Guest User

Untitled

a guest
Jul 4th, 2016
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.87 KB | None | 0 0
  1. public function index()
  2. {
  3. extract(populateform());
  4. if(isset($monthly)){
  5. $data['var'] = "Monthly";
  6. $data['tgl'] = $this->modelmodel->showdata("select MONTH(tanggal) Tanggal from transaksi
  7. where outlet = '".$this->session->userdata('username')."' group by
  8. MONTH(tanggal)");
  9. $data['angka'] = $this->modelmodel->showdata_monthly("select Outlet, month(tanggal),
  10. sum(cash + cc + dc + flash + piutang + reject + disc50) total
  11. from transaksi
  12. where outlet = '".$this->session->userdata('username')."'
  13. group by Outlet, month(tanggal)");
  14. }else if(isset($date_search)){
  15. $data['var'] = "Range Date";
  16. $explode = explode('-',$date_search);
  17. $start_date = inggris_date($explode[0]);
  18. $end_date = inggris_date($explode[1]);
  19. $data['tgl'] = $this->modelmodel->showdata("select MONTH(tanggal) Tanggal from transaksi
  20. where (tanggal between '$start_date' and '$end_date')and
  21. outlet = '".$this->session->userdata('username')."' group by
  22. MONTH(tanggal)");
  23. $data['angka'] = $this->modelmodel->showdata("select TOP 12 (cash + cc + dc + flash + piutang + reject + disc50)
  24. total from transaksi where (tanggal between '$start_date' and '$end_date')and
  25. outlet = '".$this->session->userdata('username')."'");
  26.  
  27. }else{
  28. $data['tgl'] = $this->modelmodel->showdata("SELECT TOP 12 Tanggal From transaksi where outlet = '".$this->session->userdata('username')."' group by Tanggal order by tanggal desc");
  29. $data['angka'] = $this->modelmodel->showdata("select TOP 12 (cash + cc + dc + flash + piutang + reject + disc50) total from transaksi where outlet = '".$this->session->userdata('username')."'");
  30. $data['var'] = "Daily";
  31. }
  32.  
  33. $view = 'dummy';
  34. $this->go_to($view,$data);
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement