public function getSerialList()
{
if ($this->serialList == null) {
$this->serialList = Serials::query()->where('tvSerial_id = :id:', ['id' => $this->id])->orderBy('serial_num')->execute();
}
return $this->serialList;
}
function getUniqueSerialNumber($serial_number = null)
{
if (!$serial_number) {
$serial_number = mt_rand(2, 268435455);
}
$serial = new Serials();
$serial->serial_id = $serial_number;
$temp = $serial->findAll();
if ($temp) {
//serial number exists
/* if temp is more than 8 hours old */
if (abs(compareTimes($temp->updated_at)) > 1440) {
$temp->ip_address = Request::getClientIp();
$temp->welcomed = 0;
$temp->save();
Session::put('unique_serial', $temp->serial_id);
Session::put('serial_id', $temp->id);
if (Auth::check()) {
Auth::user()->serial_id = $temp->id;
Auth::user()->disconnecting = 0;
Auth::user()->online = 1;
Auth::user()->save();
$node = new NodeAuth();
$node->serial = $serial->serial_id;
$node->sid = Session::getId();
$node->authorized = 1;
if ($node->findAll()) {
$node = $node->findAll();
}
$node->user_id = Auth::user()->id;
$node->user = Auth::user()->name;
$node->serial_id = $serial->id;
$node->save();
}
return true;
}
$serial_number = mt_rand(0, 16777215);
return getUniqueSerialNumber($serial_number);
}
$serial->ip_address = Request::getClientIp();
$serial->welcomed = 0;
$serial->save();
Session::put('unique_serial', $serial->serial_id);
Session::put('serial_id', $serial->id);
if (Auth::check()) {
Auth::user()->serial_id = $serial->id;
Auth::user()->disconnecting = 0;
Auth::user()->online = 1;
Auth::user()->save();
$node = new NodeAuth();
$node->serial = $serial->serial_id;
$node->sid = Session::getId();
$node->authorized = 1;
if ($node->findAll()) {
$node = $node->findAll();
}
$node->user_id = Auth::user()->id;
$node->user = Auth::user()->name;
$node->serial_id = $serial->id;
$node->save();
}
return true;
}
/**
* @return Serials
*/
public function getSerial()
{
if (null == $this->serial) {
$this->serial = Serials::findFirst('id = "' . $this->serial_id . '"');
}
return $this->serial;
}
public function deleteSerial()
{
$serial = Serials::query()->where('movie_id = :id:', ['id' => $this->id])->execute()->getFirst();
if ($serial) {
$serial->delete();
}
return $this;
}
public function editSerialAction(Movies $movie, Serials $serial)
{
if ($this->request->isPost()) {
$serial->update($this->request->getPost());
$tvserial = $serial->getTVSerial();
return $this->redirectByRoute(['for' => 'tvserials.show', 'tvserial' => $tvserial->id]);
}
$this->view->serial = $serial;
$this->view->form = myForm::buildFormFromModel($serial);
$this->view->movie = $movie;
}
<?php
require_once "connection.php";
require_once "manufacturer.php";
require_once "manufacturerDao.php";
require_once "Serials.php";
$con = new connection();
$connection = $con->getConnection();
if (isset($_POST["submit"])) {
$manufacturerId = $_POST["selected"];
$numofSerials = $_POST["numofSerials"];
$serialObject = new Serials($connection);
$serialObject->getSerial($manufacturerId, $numofSerials);
header("location:index.php");
}
if (isset($_POST["create"])) {
$name = $_POST["name"];
$manufacturer = new manufacturer($name);
$manufacturerDao = new manufacturerDao($connection);
$manufacturerDao->create($manufacturer);
header("location:index.php");
}
/* //generates random strings of characters based on the given length
function randGenerator($length) {
mt_srand((double)microtime() * 1000000);
$possible = 'abcdefghijklmnopqrstuvwxyz0123456789' . 'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';
$randompass ="";
while(strlen($randompass) < $length) {
$randompass .= substr($possible, mt_rand(0, strlen($possible) -1), 1);
}
return($randompass);
