session_start();
//create handle for new PDF document
$pdf = PDF_new();
//open a file pdf_open_file
PDF_open_file($pdf, "");
//start a new page
PDF_begin_page($pdf, 595, 842);
//get and use a font object
$font = PDF_findfont($pdf, "Times-Roman", "host", 0);
PDF_setfont($pdf, $font, 12);
/*print text*/
// PULLING OF DATA AND OTHER PRINTING INFORMATION------------------------
include 'dbFunctions.php';
$consign_query = "SELECT \r\nSUM(rs.product_qty) AS product_qty, \r\nSUM(rs.sold_price) AS sold_final_price, \r\nSUM(rs.sales_price) AS sales_final_price,\r\ns.supplier_name,\r\ns.supplier_consignment,\r\ns.supplier_id \r\nFROM resolvesale rs, product p, category c, resolvecategory rc, supplier s \r\nWHERE time_of_sale BETWEEN '{$year1}-{$month1}-{$day1} 00:00:01' AND '{$year2}-{$month2}-{$day2} 23:59:59'\r\nAND rs.product_id = p.product_id\r\nAND p.category_id = c.category_id\r\nAND c.category_id = rc.category_id\r\nAND rc.supplier_id = s.supplier_id \r\nGROUP BY s.supplier_id";
// EXECUTE QUERY AND RETRIEVE ALL THE DATA I NEED -----------------------
$printconsign = executeSelectQuery($consign_query);
$generatedfrom = $_POST['generatedfrom'];
$selectedto = $_POST['selectedto'];
$supplier_name = $_POST['supplier_name'];
$supplier_consignment = $_POST['supplier_consignment'];
$product_qty = $_POST['product_qty'];
$sales_final_price = $_POST['sales_final_price'];
$sold_final_price = $_POST['sold_final_price'];
$payment_to_supplier = $_POST['payment_to_supplier'];
$total_consignment = $_POST['total_money'];
$images = PDF_load_image($pdf, 'jpeg', 'C:\\xampp\\htdocs\\pdf\\images\\dulce.jpeg', '');
$reportheader = " CONSIGNMENT REPORT ";
$timestamp = getdate();
$reference = "REF-";
$reportl1 = "REPORT GENERATED FROM: {$generatedfrom}";
$reportl2 = "TO: {$selectedto}";
if ($_SESSION['role'] == 'admin' || $_COOKIE['role'] == 'admin') {
$email_add = $_GET['email_add'];
include 'dbFunctions.php';
$sql = "(SELECT role FROM teacher WHERE email_add = '{$email_add}') UNION (SELECT role FROM registereduser WHERE email_add = '{$email_add}') ";
$result = mysqli_query($connect, $sql);
while ($runrows = mysqli_fetch_array($result)) {
$role = $runrows['role'];
}
if ($role == 'teacher') {
$teachersql = "SELECT * FROM teacher WHERE email_add = '{$email_add}'";
$teacherResult = mysqli_query($connect, $teachersql);
while ($runrows = mysqli_fetch_array($teacherResult)) {
$personID = $runrows['teacher_id'];
}
// to delete the image stored for teacher
$m = executeSelectQuery(" SELECT * FROM teacher WHERE teacher_id = '{$personID}' ");
$path = 'teacherimage/';
unlink($path . $m[0]['image']);
// delete comment with the teacher id & relation & video
mysqli_query($connect, "DELETE FROM `comment` WHERE teacher_id ='{$personID}' ") or die(mysqli_error());
mysqli_query($connect, "DELETE FROM `relation` WHERE teacher_id ='{$personID}' ") or die(mysqli_error());
mysqli_query($connect, "DELETE FROM `videos` WHERE teacher_id ='{$personID}' ") or die(mysqli_error());
mysqli_query($connect, "DELETE FROM `resolvecategory` WHERE teacher_id ='{$personID}' ") or die(mysqli_error());
// to delete the whole account.
mysqli_query($connect, "DELETE FROM `teacher` WHERE teacher_id ='{$personID}' ") or die(mysqli_error());
$deletesuccess = "The particular user have been deleted successfully.";
echo $deletesuccess;
}
if ($role == 'student') {
$studentsql = "SELECT * FROM registereduser WHERE email_add = '{$email_add}'";
$studentresult = mysqli_query($connect, $studentsql);
mysqli_query($connect, "UPDATE `teacher` SET `image` = '{$image}' WHERE email_add = '{$email_add2}' ") or die(mysql_error());
if (($_FILES["uploadedfile"]["type"] == "image/gif" || $_FILES["uploadedfile"]["type"] == "image/jpeg" || $_FILES["uploadedfile"]["type"] == "image/png" || $_FILES["uploadedfile"]["type"] == "image/pjpeg" || $_FILES["uploadedfile"]["type"] == "image/jpg") && $_FILES["uploadedfile"]["size"] < 50000000) {
if ($_FILES["file"]["error"] > 0) {
$errorimage = "Return Code: " . $_FILES["uploadedfile"]["error"] . "<br />";
} else {
if (file_exists("administrator/teacherimage/" . $_FILES["uploadedfile"]["name"])) {
$imageexist = "The image already exist. Not possible to enter another one.<br/><br/>";
$imagename = $_FILES["uploadedfile"]["name"] . " already exists. <br/>\r\n\t\t\t\t<input type=button value='Go Back!' onclick='history.back(-1)' /><br/>";
} else {
move_uploaded_file($_FILES["uploadedfile"]["tmp_name"], "administrator/teacherimage/" . $_FILES["uploadedfile"]["name"]);
$success = "You have sucessfully change your picture";
}
}
}
} else {
$m = executeSelectQuery("SELECT image FROM portalmanager WHERE email_add = '{$email_add2}' ");
$path = 'administrator/portalmanagerimage/';
unlink($path . $m[0]['image']);
mysqli_query($connect, "UPDATE `portalmanager` SET `image` = '{$image}' WHERE email_add = '{$email_add2}' ") or die(mysql_error());
if (($_FILES["uploadedfile"]["type"] == "image/gif" || $_FILES["uploadedfile"]["type"] == "image/jpeg" || $_FILES["uploadedfile"]["type"] == "image/png" || $_FILES["uploadedfile"]["type"] == "image/pjpeg" || $_FILES["uploadedfile"]["type"] == "image/jpg") && $_FILES["uploadedfile"]["size"] < 50000000) {
if ($_FILES["file"]["error"] > 0) {
$errorimage = "Return Code: " . $_FILES["uploadedfile"]["error"] . "<br />";
} else {
if (file_exists("administrator/portalmanagerimage/" . $_FILES["uploadedfile"]["name"])) {
$imageexist = "The image already exist. Not possible to enter another one.<br/><br/>";
$imagename = $_FILES["uploadedfile"]["name"] . " already exists. <br/>\r\n\t\t\t\t<input type=button value='Go Back!' onclick='history.back(-1)' /><br/>";
} else {
move_uploaded_file($_FILES["uploadedfile"]["tmp_name"], "administrator/portalmanagerimage/" . $_FILES["uploadedfile"]["name"]);
$success = "You have sucessfully change your picture";
}
}
$expenditure[$index] = $expenditure_report[0][0];
}
if ($sMonth + 1 == 13) {
$sMonth = 1;
$sYear++;
} else {
$sMonth++;
}
$index++;
}
for ($i = 0; $i < $year_difference; $i++) {
for ($j = 0; $j <= 11; $j++) {
$month = dates($sMonth, $sYear);
$expenditure_report = executeSelectQuery("SELECT sum(total_amount) FROM expenditure WHERE date BETWEEN '{$month['0']}' AND '{$month['1']}'");
$revenue_report = executeSelectQuery("SELECT sum(sold_price) FROM resolvesale WHERE DATE_FORMAT(time_of_sale,'%Y-%m-%d') BETWEEN '{$month['0']}' AND '{$month['1']}'");
$cogs_report = executeSelectQuery("SELECT sum(cost_price) FROM resolvesale WHERE DATE_FORMAT(time_of_sale,'%Y-%m-%d') BETWEEN '{$month['0']}' AND '{$month['1']}'");
if ($cogs_report[0][0] == null) {
$cogs[$index] = 0;
} else {
$cogs[$index] = $cogs_report[0][0];
}
if ($revenue_report[0][0] == null) {
$revenue[$index] = 0;
} else {
$revenue[$index] = $revenue_report[0][0];
}
if ($expenditure_report[0][0] == null) {
$expenditure[$index] = 0;
} else {
$expenditure[$index] = $expenditure_report[0][0];
}
session_start();
//create handle for new PDF document
$pdf = PDF_new();
//open a file pdf_open_file
PDF_open_file($pdf, "");
//start a new page
PDF_begin_page($pdf, 595, 842);
//get and use a font object
$font = PDF_findfont($pdf, "Times-Roman", "host", 0);
PDF_setfont($pdf, $font, 12);
/*print text*/
// PULLING OF DATA AND OTHER PRINTING INFORMATION------------------------
include 'dbFunctions.php';
$revenuequery = "SELECT \r\nSUM(rs.product_qty) AS product_qty, \r\nSUM(rs.sold_price) AS sold_final_price, \r\nSUM(rs.sales_price) AS sales_final_price,\r\np.product_name\r\nFROM resolvesale rs, product p, category c, resolvecategory rc, supplier s \r\nWHERE time_of_sale BETWEEN '{$year1}-{$month1}-{$day1} 00:00:01' AND '{$year2}-{$month2}-{$day2} 23:59:59'\r\nAND rs.product_id = p.product_id\r\nAND p.category_id = c.category_id\r\nAND c.category_id = rc.category_id\r\nAND rc.supplier_id = s.supplier_id \r\nGROUP BY rs.product_code\r\nORDER BY SUM(rs.product_qty) DESC";
// EXECUTE QUERY AND RETRIEVE ALL THE DATA I NEED -----------------------
$printrevenue = executeSelectQuery($revenuequery);
$generatedfrom = $_POST['generatedfrom'];
$selectedto = $_POST['selectedto'];
$product_name = $_POST['product_name'];
$product_qty = $_POST['product_qty'];
$sales_final_price = $_POST['sales_final_price'];
$sold_final_price = $_POST['sold_final_price'];
$total_qty_sold = $_POST['total_qty_sold'];
$total_amt_revenue = $_POST['total_amt_revenue'];
$images = PDF_load_image($pdf, 'jpeg', 'C:\\xampp\\htdocs\\pdf\\images\\dulce.jpeg', '');
$revpermonth = " REVENUE REPORT ";
$timestamp = getdate();
$reference = "REF-";
$reportl1 = "REPORT GENERATED FROM: {$generatedfrom} ";
$reportl2 = "TO: {$selectedto} ";
$productheader = "PRODUCT NAME";
PDF_begin_page($pdf, 595, 842);
//get and use a font object
$font = PDF_findfont($pdf, "Times-Roman", "host", 0);
PDF_setfont($pdf, $font, 12);
/*print text*/
include 'dbFunctions.php';
//GET STAFF'S NAME ------------------------------------------------------
if (isset($_SESSION['name'])) {
$name = $_SESSION['name'];
}
if (isset($_COOKIE['name'])) {
$name = $_COOKIE['name'];
}
//PULLING OF DATA AND OTHER PRINTING INFORMATION ------------------------
$query = "SELECT s.sales_id, s.time_of_sale, s.user_id, s.sales_type, s.vip_id, r.sales_price, r.sold_price, r.promotion_name, c.first_name FROM resolvesale r, sales s, customer c WHERE r.sales_id = '{$sales_id}' AND s.vip_id = c.vip_id ";
$receipt = executeSelectQuery($query);
$items = $_POST['productName'];
$price = $_POST['productPrice'];
$orgprice = $_POST['productOrgPrice'];
$discounts = $_POST['productDiscount'];
$quantitys = $_POST['productQty'];
$code = $_POST['productCode'];
$vipFirstName = $_POST['vipFirstName'];
$vipLastName = $_POST['vipLastName'];
$paymentmode = $_POST['paymentType'];
$gave = $_POST['paymentReceived'];
$amounts = $_POST['final_total_sold'];
$change = $_POST['change_money_to_customer'];
$sales_id = $_POST['sales_id'];
$final_discount_name = $_POST['final_discount_name'];
$total_original_price = $_POST['total_original_price'];
