public function handleClientDesign(Context $context)
{
$insertDate = explode('/', $_POST['insertdate']);
$mysqlFormattedDate = $insertDate[2] . "-" . $insertDate[1] . "-" . $insertDate[0];
$clientId = ClientDao::getClientByLogin(LoginDao::getLoginByUsername(SessionUtil::getUsername()))->getID();
$filename = $this->saveSampleImage($context, $_FILES['sampleimage'], $clientId);
if ($filename != "") {
InsertionOrderDao::createForClientWithImage(ClientDao::getClientByLogin(LoginDao::getLoginByUsername(SessionUtil::getUsername()))->getID(), $mysqlFormattedDate, $_POST['design'], $_POST['color'], $_POST['columns'], $_POST['height'], $_POST['inserts'], $_POST['placements'], $filename);
}
}
public static function getByID($ID)
{
$query = "SELECT * FROM " . Database::addPrefix('insertionorders') . " WHERE InsertId = '" . $ID . "'";
$result = Database::doQuery($query);
$row = mysql_fetch_assoc($result);
if ($row) {
return InsertionOrderDao::populateInsertionOrder($row);
} else {
return null;
}
}
public function generateClientHTML()
{
$adRep = new AdRep(1, "Andrew Melton", "*****@*****.**", "804-267-0327");
$status = new Status(1, "Design", "Your ad has been aproved and is being designed.");
$designStatus = new Status(1, "To Be Designed", "A designer is working on your ad.");
$billingStatus = new Status(1, "Paid", "");
$orders = InsertionOrderDao::getOrdersByClientID(ClientDao::getClientByLogin(LoginDao::getLoginByUsername(SessionUtil::getUsername()))->getID());
$ordersHTML = "";
foreach ($orders as $order) {
$ordersHTML = $ordersHTML . $order->generateDualRowHTML();
}
return "<br />\n\t\t\t\t<div id=\"insertsheader\">\n\t\t\t\t<table id=\"report2\" border=\"0\">\n\t\t\t\t\t<tr>\n\t\t\t\t\t\t\n\t\t\t\t\t\t<th class=\"adrep\">Your Ad Rep</th>\n\t\t\t\t\t\t<th class=\"created\">Created</th>\n\t\t\t\t\t\t<th class=\"updated\">Updated</th>\n\t\t\t\t\t\t<th class=\"issue\">Issue</th>\n\t\t\t\t\t\t<th class=\"status\">Status</th>\n\t\t\t\t\t\t<th class=\"designstatus\">Design-Status</th>\n\t\t\t\t\t\t<th class=\"billingstatus\">Billing</th>\n\t\t\t\t\t\t<!--<th class=\"arrow\"></th>-->\n\t\t\t\t\t\t\n\t\t\t\t\t</tr>\n\t\t\t\t</table>\n\t\t\t\t</div>\n\t\t\t\n\t\t\t\t<div id=\"contentdiv\" class=\"scroll\">\n\t\t\t\t\n\t\t\t\t\t<table id=\"report\" border=\"0\">\n\t\t\t\t\t\t\n\t\t\t\t\t\t" . $ordersHTML . "\n\t\t\t\t\t\n\t\t\t\t\t</table>\n\t\t\t\t\n\t\t\t\t</div>";
}
<?php
require_once './Config.php';
require_once './lib/DB/ClientDao.php';
require_once './lib/DB/Database.php';
require_once './lib/DB/InsertionOrderDao.php';
require_once './lib/Util/SessionUtil.php';
require_once './lib/Util/SimpleImage.php';
if (!SessionUtil::start()) {
echo "Error Starting Session";
}
Database::Open();
if (isset($_GET['insertId'])) {
$insert = InsertionOrderDao::getByID($_GET['insertId']);
if (!$insert) {
$image = new SimpleImage();
$image->load('./images/notfound.png');
header('Content-Type: image/jpeg');
echo $image->output();
exit;
}
$client = ClientDao::getClientByLogin(LoginDao::getLoginByUsername(SessionUtil::getUsername()));
if ($insert->getClient()->getID() == $client->getID() && file_exists($insert->getImageLoc())) {
$image = new SimpleImage();
$image->load($insert->getImageLoc());
$hratio = 150 / $image->getHeight();
$wratio = 150 / $image->getWidth();
$image->scale(min($hratio, $wratio) * 100);
header('Content-Type: image/jpeg');
echo $image->output();
} else {
