include "../includes/connection.php";
include "../includes/session.php";
//confirm user has logged in
Confirm_store_session();
$session_storeID = $_SESSION['store_id'];
if (isset($_GET['paymentID'])) {
$selectedPaymentID = mysql_prep($_GET['paymentID']);
} elseif (isset($_POST['update'])) {
$selectedPaymentID = mysql_prep($_POST['paymentID']);
if (isset($_POST['pickup'])) {
$pickup_status = $_POST['pickup'];
foreach ($_POST['pickup'] as $value) {
//form data
$form_data = array('delivery_status' => "checked");
//insert
dbRowUpdate('tblsales', $form_data, "WHERE sales_id = {$value}");
}
}
} else {
redirect_to("index.php");
}
require_once 'includes/template-top.php';
?>
<h1 class="title">Order Items</h1>
<p align="right"><input type="button" class="button-primary " value="Print" onclick="javascript:printDiv('print')" /></p>
<div id="print">
<h2 style=" font-size: 22px;font-weight: 600;padding: 10px 0px;color: #0483A0; line-height:1.2;">REF. No <span style="color:#222;">(<?php
$form_data = array('todo_status' => 'Done');
} else {
//not done
$form_data = array('todo_status' => 'Not Done');
}
dbRowUpdate('todo_list', $form_data, " WHERE id = {$id} ");
redirect_to("index.php");
} elseif (isset($_GET['deleteid'])) {
$id = mysql_prep($_GET['deleteid']);
dbRowDelete('todo_list', " WHERE id = {$id} ");
redirect_to("index.php");
} elseif (isset($_POST['edit_btn'])) {
$id = mysql_prep($_POST['id']);
$todo = mysql_prep($_POST['todo_edit']);
$form_data = array('todo_item' => $todo);
dbRowUpdate('todo_list', $form_data, " WHERE id = {$id} ");
redirect_to("index.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>ToDo</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/sticky-footer.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</head>
<body style="background-color: #03437B;">
$form_data = array('ref_no' => $ref_no, 'email' => $session_cus_email, 'transaction_code' => $code);
dbRowInsert('tblpayments', $form_data);
//get items from the cart
$query = "SELECT * FROM view_cart WHERE email = '{$session_cus_email}'";
$result = mysql_query($query, $connection);
confirm_query($result);
while ($row = mysql_fetch_array($result)) {
$cart_id = $row['cart_id'];
$grocery_id = $row['grocery_id'];
$grocery_qty = $row['grocery_qty'];
$cart_qty = $row['cart_qty'];
$sales_cost = $row['grocery_cost'];
//decrease stock
$grocery_qty = $grocery_qty - $cart_qty;
$form_data = array('grocery_qty' => $grocery_qty);
dbRowUpdate('tblgrocery', $form_data, " WHERE grocery_id = {$grocery_id}");
//$cal_comm = round(( $sales_cost ( 3 /100 ) ) * $cart_qty);
//insert into sales
$form_data = array('grocery_id' => $grocery_id, 'sales_qty' => $cart_qty, 'ref_no' => $ref_no, 'email' => $session_cus_email, 'sales_cost' => $sales_cost);
//inser
dbRowInsert('tblsales', $form_data);
//delete from the tblcart
dbRowDelete('tblcart', " WHERE cart_id = {$cart_id}");
}
redirect_to("account.php");
}
//
require_once 'includes/template-top.php';
?>
<!-- row -->
require_once '../includes/connection.php';
require_once '../includes/session.php';
//confirm user has logged in
Confirm_admin_session();
if (isset($_POST['pay_btn'])) {
$store_id = $_POST['storeid'];
$chequeno = $_POST['cheqno'];
$sql = "SELECT * FROM view_sales WHERE store_id = {$store_id} and paid_status ='no' and delivery_status = 'checked' ";
$res = mysql_query($sql, $connection);
$sum = 0;
$commission = 0;
while ($row = mysql_fetch_array($res)) {
$sale_id = $row['sales_id'];
$form_data = array('paid_status' => "yes", 'cheque_no' => $chequeno);
//update
dbRowUpdate('tblsales', $form_data, " WHERE sales_id = {$sale_id}");
}
}
//
require_once 'includes/template-top.php';
?>
<!-- row -->
<div class="row">
<h1 class="title">Stores</h1>
<table id="table1">
<thead>
<tr style="background:#000;">
<th>#</th>
<th>IMG</th>
$usernames = ucfirst(trim(mysql_prep($_POST['names'])));
$phone = mysql_prep($_POST['phone']);
//form data
$form_data = array('cus_names' => $usernames, 'cus_phone' => $phone);
//register customers
dbRowUpdate('tblcustomers', $form_data, " WHERE email = '{$session_cus_email}' ");
//update session name
$_SESSION['customerNames'] = $usernames;
//check password
$password = $_POST['password'];
if ($password != "") {
$password = md5($_POST['pass']);
//form data
$form_data = array('password' => $password);
//register customers
dbRowUpdate('tblcustomers', $form_data, " WHERE email = '{$session_cus_email}' ");
}
redirect_to("account.php");
}
//
//fetch
$query = "SELECT * FROM tblcustomers WHERE email = '{$session_cus_email}' LIMIT 1";
$result = mysql_query($query, $connection) or die("Query failed : " . mysql_error());
while ($row = mysql_fetch_array($result)) {
$fetch_cus_names = $row['cus_names'];
$fetch_cus_phone = $row['cus_phone'];
//set session
$_SESSION['customerNames'] = $row['cus_names'];
}
require_once 'includes/template-top.php';
?>
require_once '../includes/connection.php';
require_once '../includes/session.php';
//confirm user has logged in
Confirm_admin_session();
if (isset($_GET['paymentID'])) {
//
$selected_paymentID = $_GET['paymentID'];
$verify = $_GET['verify'];
if ($verify == "no") {
$update_verify = "verified";
} else {
$update_verify = "no";
}
$form_data = array('verified' => $update_verify);
//update
dbRowUpdate('tblpayments', $form_data, " WHERE payment_id = {$selected_paymentID}");
} elseif (isset($_GET['deleteID'])) {
$deleteId = $_GET['deleteID'];
//delete
dbRowDelete('tblpayments', " WHERE payment_id = {$deleteId}");
redirect_to("index.php");
}
require_once 'includes/template-top.php';
?>
<!-- row -->
<div class="row">
<h1 class="title">Customers' Payments</h1>
<?php
include 'header.php';
include 'functions.php';
include 'config.php';
$id = $_GET['id'];
$sql = "select * from contacts where id ='{$id}'";
$res = mysql_query($sql);
//$logo="uploads/".$_POST['uploader_0_name'];
$row = mysql_fetch_array($res);
print_r($row);
if (isset($_POST['submit'])) {
$form_data = array('Name' => $_POST['cname'], 'Mobile' => $_POST['cmobile'], 'Landline' => $_POST['clandline'], 'Email' => $_POST['cemail'], 'bussinesscardimage_path' => $_POST['cbussi'], 'Key_contact' => $_POST['ckeycon'], 'Supplier_id' => $_POST['csupplier'], 'Position' => $_POST['cposition'], 'Skype' => $_POST['cskype'], 'Wechat' => $_POST['cwechat'], 'QQ' => $_POST['cqq'], 'WhatsApp' => $_POST['cwhats']);
dbRowUpdate('contacts', $form_data, "WHERE id = '{$id}'");
header("Location: contacts.php");
}
?>
<div id="main" role="main">
<div id="content">
<section id="" class="">
<!-- START ROW -->
<div class="row">
<!-- NEW COL START -->
<article class="col-lg-12">
<?php
require_once 'includes/connection.php';
require_once 'includes/session.php';
confirm_logged_in();
//confirm whether the user logged in
if (isset($_POST['update_username_btn'])) {
$username = mysql_prep($_POST['username']);
$form_data = array('username' => $username);
dbRowUpdate('users', $form_data, " WHERE id = 1");
redirect_to("settings.php");
} elseif (isset($_POST['update_password_btn'])) {
$password = mysql_prep($_POST['pwd']);
$password = MD5($password);
$form_data = array('password' => $password);
dbRowUpdate('users', $form_data, " WHERE id = 1");
redirect_to("settings.php");
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<title>ToDo</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="css/sticky-footer.css">
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
</head>
<body style="background-color: #03437B;">
$temp = explode(".", $_FILES["file1"]["name"]);
$newfilename = uniqid() . '.' . end($temp);
$extension = end($temp);
if (($_FILES["file1"]["type"] == "image/gif" || $_FILES["file1"]["type"] == "image/jpeg" || $_FILES["file1"]["type"] == "image/JPEG" || $_FILES["file1"]["type"] == "image/jpg" || $_FILES["file1"]["type"] == "application/pdf" || $_FILES["file1"]["type"] == "image/pjpeg" || $_FILES["file1"]["type"] == "image/x-png" || $_FILES["file1"]["type"] == "image/png") && $_FILES["file1"]["size"] < 8000000 && in_array($extension, $allowedExts)) {
if ($_FILES["file1"]["error"] > 0) {
$error_msg = "Return Code: " . $_FILES["file1"]["error"] . "<br>";
} else {
if (file_exists("../images/stores/" . $newfilename)) {
$error_msg = $_FILES["file1"]["name"] . " already exists. ";
} else {
move_uploaded_file($_FILES["file1"]["tmp_name"], "../images/stores/" . $newfilename);
$img_dir = "images/stores/" . $newfilename;
//form data
$form_data = array('store_img' => $img_dir);
//update
dbRowUpdate('tblstore', $form_data, " WHERE `store_id` = {$session_storeID}");
}
}
}
}
//
//fetch
$query = "SELECT * FROM `tblstore` WHERE `store_id` = {$session_storeID} ";
$result = mysql_query($query, $connection);
confirm_query($result);
while ($row = mysql_fetch_array($result)) {
$store_image = $row['store_img'];
}
require_once 'includes/template-top.php';
?>
function editEmployer($data)
{
try {
$status = 'fail';
$id = $_POST["id"];
$tableName = "employer_personal_info";
$where_clause = "where id = {$id} ";
$result = dbRowUpdate($tableName, $_POST["formData"], $where_clause);
if ($result >= 1) {
$status = "ok";
}
} catch (Exception $ex) {
echo "<script>\n var msg = '<b>* Error Occured While Updating Employer ...</b>';\n showWarning(msg);\n </script>";
echo "fail";
}
echo $status;
}
$temp = explode(".", $_FILES["file1"]["name"]);
$newfilename = uniqid() . '.' . end($temp);
$extension = end($temp);
if (($_FILES["file1"]["type"] == "image/gif" || $_FILES["file1"]["type"] == "image/jpeg" || $_FILES["file1"]["type"] == "image/JPEG" || $_FILES["file1"]["type"] == "image/jpg" || $_FILES["file1"]["type"] == "application/pdf" || $_FILES["file1"]["type"] == "image/pjpeg" || $_FILES["file1"]["type"] == "image/x-png" || $_FILES["file1"]["type"] == "image/png") && $_FILES["file1"]["size"] < 8000000 && in_array($extension, $allowedExts)) {
if ($_FILES["file1"]["error"] > 0) {
$error_msg = "Return Code: " . $_FILES["file1"]["error"] . "<br>";
} else {
if (file_exists("../images/grocery/" . $newfilename)) {
$error_msg = $_FILES["file1"]["name"] . " already exists. ";
} else {
move_uploaded_file($_FILES["file1"]["tmp_name"], "../images/grocery/" . $newfilename);
$img_dir = "images/grocery/" . $newfilename;
//form data
$form_data = array('grocery_img' => $img_dir);
//update
dbRowUpdate('tblgrocery', $form_data, " WHERE grocery_id = {$selectedID}");
}
}
}
} elseif (isset($_GET['deleteID'])) {
$selectedID = $_GET['deleteID'];
$image_url = '../' . $_GET['image_url'];
//remove image
unlink("{$image_url}");
//delete grocerys
dbRowDelete('tblgrocery', " WHERE grocery_id = {$selectedID}");
redirect_to("groceries.php");
} else {
redirect_to("groceries.php");
}
//fetch
} elseif (isset($_POST['update_info'])) {
$selectedID = $_POST['editID'];
$storename = ucfirst(mysql_prep($_POST['store_name']));
$location = ucfirst(mysql_prep($_POST['location']));
$phone = mysql_prep($_POST['phone']);
//form data
$form_data = array('store_name' => $storename, 'store_location' => $location, 'store_phone' => $phone);
//update
dbRowUpdate('tblstore', $form_data, " WHERE store_id = {$selectedID} ");
} elseif (isset($_GET['resetID'])) {
$selectedID = $_GET['resetID'];
$password = md5("1234");
//form data
$form_data = array('store_password' => $password);
//update
dbRowUpdate('tblstore', $form_data, " WHERE store_id = {$selectedID} ");
} elseif (isset($_GET['deleteID'])) {
$selectedID = $_GET['deleteID'];
//delete
dbRowDelete('tblstore', " WHERE store_id = {$selectedID} ");
redirect_to("stores.php");
} else {
redirect_to("stores.php");
}
//fetch
$query = "SELECT * FROM tblstore WHERE store_id = {$selectedID} ";
$result = mysql_query($query, $connection);
confirm_query($result);
while ($row = mysql_fetch_array($result)) {
$storename = $row['store_name'];
$location = $row['store_location'];
