daily pastebin goal
66%
SHARE
TWEET

Untitled

a guest Feb 13th, 2018 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2.  
  3.     class Scope_model extends CI_Model {
  4.         public function get_dsg_numbers_for_the_receiving_invoice_charges() {
  5.             $this->db->where('start_date', $start_date); //this is the Monday of the previous week so does the date_in fall between start date and end date
  6.             $this->db->where('end_date', $end_date); //this is the Sunday of the previous week
  7.             $this->db->where_not_in('customer_id', 100000);//where customer name/id is not unknown
  8.             $this->db->or_where('customer_finally_claimed_the_items', 1);//this grabs items outside of the date parameter where the dsg number was previously assigned to unknown, but during the previous week it was claimed
  9.             $query = $this->db->get('dsg_number');
  10.             return $query->result();
  11.         }
  12.  
  13.  
  14.  
  15.  
  16.         public function get_completed_delivery_tickets_and_field_transfers_for_invoice_charges() {
  17.             $this->db->where('start_date', $start_date); //this is the Monday of the previous week
  18.             $this->db->where('end_date', $end_date); //this is the Sunday of the previous week
  19.             $this->db->where('completed', 1);
  20.             $query = $this->db->get('logitics');
  21.             return $query->result();
  22.         }
  23.        
  24.  
  25.  
  26.         public function get_storage_charges_for_the_week() {
  27.             $this->db->where('date_in', $date_in); //range is previous Monday thru Sunday
  28.  
  29.             //checked in two+ weeks ago:
  30.             //  charged the previous Monday thru Sunday
  31.  
  32.             // checked in that week (wedndesday)
  33.             //  charged the previous wednesday thru Sunday
  34.  
  35.             // checked in two+ weeks ago and check out/delivered on wednesday of the previous week
  36.             //  charged Monday - Wednesday
  37.         }
  38.     }  
  39. ?>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top