/**
* 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));
