/** * Retrieve all SMSs that were sent to a selected recipient. * Select recipient by ID. * @param int|string $recipientId * @param boolean $unseen Optional. If you want to retrieve only unseen SMSs. * @return array(SMS) */ public function get_all_recipient_SMSs($recipientId, $unseen = false) { $SMS = new ModelTemplate('SMS'); $SMSs = null; if ($unseen) { $SMSs = $SMS->get_all(array('recipient_id', 'is_seen', 'is_resolved'), array($recipientId, 'false', 'false')); } else { $SMSs = $SMS->get_all(array('recipient_id', 'is_resolved'), array($recipientId, 'false')); } if ($SMSs) { $truckDriverCtr = new TruckDriver_Controller(); $logisticianCtr = new Logistician_Controller(); // Retrieve SMSs' senders and recipients. foreach ($SMSs as $key => &$SMS) { if ($sender = $truckDriverCtr->get_truck_driver_by_id($SMS->sender_id)) { $SMS->sender_id = $sender; } if ($recipient = $logisticianCtr->get_logistician_by_id($SMS->recipient_id)) { $SMS->recipient_id = $recipient; } // If no sender and recipient delete SMS. if (!($sender && $recipient)) { unset($SMSs[$key]); } } } return $SMSs; }
/** * Retrieve all truck drivers. * @return array(TruckDriver) */ public function get_all_truck_drivers() { $truckDriver = new ModelTemplate('TruckDriver'); $truckDrivers = $truckDriver->get_all(); if ($truckDrivers) { // Add super class SMSUser fields to each TruckDriver instance. foreach ($truckDrivers as $key => &$td) { $smsUserCtr = new SMSUser_Controller(); // It should have super class fields, otherwise delete the instance. if ($smsUser = $smsUserCtr->get_smsuser_by_id($td->id)) { $td->add_field('telephone', $smsUser->telephone); } else { unset($truckDrivers[$key]); } } } return $truckDrivers; }
/** * Retrieve all trucks. * @return array(Truck) */ public function get_all_trucks() { $truck = new ModelTemplate('Truck'); return $truck->get_all(); }
public function get_all($where = null, $value = null) { $poi = new ModelTemplate('PointOfInterest'); return $poi->get_all($where, $value); }
$truck->age = 3; $lastInsertedId = $truck->submit_new(); echo '<p> Last Inserted ID: ' . $lastInsertedId . '</p>'; /* * GET SINGLE TEST. */ $truck2 = new ModelTemplate('Truck'); $truck2 = $truck2->get_single('id', $lastInsertedId); echo '<p> One element: '; var_dump($truck2); echo '</p>'; /* * GET ALL TEST. */ $truck3 = new ModelTemplate('Truck'); $trucks = $truck3->get_all(); echo '<p> All elements: '; var_dump($trucks); /* * SUBMIT CHANGES TEST. */ $truck4 = new ModelTemplate('Truck'); echo '<p> Before update: '; var_dump($truck4 = $truck4->get_single('id', $lastInsertedId)); echo '</p>'; $truck4->vehicle_capacity = 100; $truck4->brand = 'MAN'; $truck4->age = 10; $truck4->submit_changes(); echo '<p> After update: '; var_dump($truck4->get_single('id', $lastInsertedId));