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 {