Advertisement
jamboljack

Report_model

May 29th, 2014
368
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.46 KB | None | 0 0
  1. <?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');
  2.  
  3. class Report_model extends CI_Model {
  4.    
  5.     function __construct() {
  6.         parent::__construct(); 
  7.     }
  8.        
  9.     function preview_order($data) {    
  10.         $sql= 'SELECT o.*,c.* FROM orders o JOIN customer c ON o.id_customer=c.id_customer WHERE o.tgl_order>?
  11.         AND o.tgl_order<? AND o.id_rias=? AND o.status_order=?';
  12.        
  13.         $query = $this->db->query($sql, $data);
  14.         return $query->result();
  15.     }
  16. }
  17. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement