Find this useful? Enter your email to receive occasional updates for securing PHP code.
Signing you up...
Thank you for signing up!
PHP Decode
<?php require_once 'php_action/db_connect.php'; require_once 'includes/header.php'; ..
Decoded Output download
<?php
require_once 'php_action/db_connect.php';
require_once 'includes/header.php';
if($_GET['o'] == 'add') {
// add order
echo "<div class='div-request div-hide' style='display:none'>add</div>";
} else if($_GET['o'] == 'manord') {
echo "<div class='div-request div-hide' style='display:none'>manord</div>";
} else if($_GET['o'] == 'editOrd') {
echo "<div class='div-request div-hide' style='display:none'>editOrd</div>";
} // /else manage order
?>
<div class="row">
<div class="col-md-12">
<ol class="breadcrumb">
<li><a href="dashboard.php">Accueil</a></li>
<li>Devis</li>
<li class="active">
<?php if($_GET['o'] == 'add') { ?>
Ajouter une Devis
<?php } else if($_GET['o'] == 'manord') { ?>
Grer la Devis
<?php } // /else manage order ?>
</li>
</ol>
<div class="panel panel-default">
<div class="panel-heading">
<?php if($_GET['o'] == 'add') { ?>
<i class="glyphicon glyphicon-plus-sign"></i> Ajouter une Devis
<?php } else if($_GET['o'] == 'manord') { ?>
<i class="glyphicon glyphicon-edit"></i> Grer les Devis
<?php } else if($_GET['o'] == 'editOrd') { ?>
<i class="glyphicon glyphicon-edit"></i> Modifier le Devis
<?php } ?>
</div> <!--/panel-->
<div class="panel-body">
<?php if($_GET['o'] == 'add') {
// add order
?>
<div class="success-messages"></div> <!--/success-messages-->
<form class="form-horizontal" method="POST" action="php_action/createOrder.php" id="createOrderForm">
<div class="form-group">
<label for="orderDate" class="col-sm-2 control-label">Date de Devis</label>
<div class="col-sm-10">
<input type="date" class="form-control" id="orderDate" name="orderDate" autocomplete="off" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="nom" class="col-sm-2 control-label">Nom du client</label>
<div class="col-sm-10">
<select class="form-control" name="nom" id="nom" >
<option value="">~~SELECT~~</option>
<?php
$productSql1 = "SELECT * FROM brands WHERE brand_status = 1 ";
$productData1 = $connect->query($productSql1);
while($row = $productData1->fetch_array()) {
$selected1 = "";
if($row['brand_id'] == $orderItemData['brand_id']) {
$selected1 = "selected1";
} else {
$selected1 = "";
}
echo "<option value='".$row['brand_id']."' id='".$row['brand_id']."' ".$selected1." >".$row['nom']."</option>";
} // /while
?>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-2 control-label">Objet</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="objet" name="objet" placeholder="Objet" autocomplete="off" />
</div>
</div> <!--/form-group-->
<table class="table" id="productTable">
<thead>
<tr>
<th style="width:40%;">service</th>
<th style="width:20%;">prix</th>
<th style="width:15%;">Quantity</th>
<th style="width:15%;">Total</th>
<th style="width:10%;">Unit</th>
</tr>
</thead>
<tbody>
<?php
$arrayNumber = 0;
for($x = 1; $x < 4; $x++) { ?>
<tr id="row<?php echo $x; ?>" class="<?php echo $arrayNumber; ?>">
<td style="margin-left:20px;">
<div class="form-group">
<textarea class="form-control" name="productName[]" id="productName<?php echo $x; ?>" onchange="getProductData(<?php echo $x; ?>)"/></textarea></div>
</td>
<td style="padding-left:20px;">
<input type="text" name="prix[]" id="prix<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" />
<input type="hidden" name="prixValue[]" id="prixValue<?php echo $x; ?>" autocomplete="off" class="form-control" />
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="number" name="quantity[]" id="quantity<?php echo $x; ?>" onchange="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" min="1" />
</div>
</td>
<td style="padding-left:20px;">
<input type="text" name="total[]" id="total<?php echo $x; ?>" autocomplete="off" class="form-control" disabled="true" />
<input type="hidden" name="totalValue[]" id="totalValue<?php echo $x; ?>" autocomplete="off" class="form-control" />
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="text" name="unite[]" id="unite<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" />
</div>
</td>
<td>
<button class="btn btn-default removeProductRowBtn" type="button" id="removeProductRowBtn" onclick="removeProductRow(<?php echo $x; ?>)"><i class="glyphicon glyphicon-trash"></i></button>
</td>
</tr>
<?php
$arrayNumber++;
} // /for
?>
</tbody>
</table>
<div class="col-md-6">
<div class="form-group">
<label for="subTotal" class="col-sm-3 control-label">Sous-total</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="subTotal" name="subTotal" disabled="true" />
<input type="hidden" class="form-control" id="subTotalValue" name="subTotalValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="vat" class="col-sm-3 control-label">T.V.A.20%</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="vat" name="vat" disabled="true" />
<input type="hidden" class="form-control" id="vatValue" name="vatValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="totalAmount" class="col-sm-3 control-label">Montant total</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="totalAmount" name="totalAmount" disabled="true"/>
<input type="hidden" class="form-control" id="totalAmountValue" name="totalAmountValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="discount" class="col-sm-3 control-label">Remise</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="discount" name="discount" onkeyup="discountFunc()" autocomplete="off" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="grandTotal" class="col-sm-3 control-label">somme finale</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="grandTotal" name="grandTotal" disabled="true" />
<input type="hidden" class="form-control" id="grandTotalValue" name="grandTotalValue" />
</div>
</div> <!--/form-group-->
</div> <!--/col-md-6-->
<div class="col-md-6">
<div class="form-group">
<label for="paid" class="col-sm-3 control-label">Montant pay</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="paid" name="paid" autocomplete="off" onkeyup="paidAmount()" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="due" class="col-sm-3 control-label">Due Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="due" name="due" disabled="true" />
<input type="hidden" class="form-control" id="dueValue" name="dueValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-3 control-label">Type de paiement</label>
<div class="col-sm-9">
<select class="form-control" name="paymentType" onchange="ChequeInput()" id="paymentType">
<option value="">~~SELECT~~</option>
<option value="1">Chque</option>
<option value="2">Cash</option>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group" id="inpcheque" style="display: none;">
<label for="imgCheque" class="col-sm-3 control-label">Image Cheque</label>
<div class="col-sm-9">
<input type="file" class="form-control-file " id="imgCheque" name="imgCheque" />
</div>
</div>
</div> <!--/col-md-6-->
<div class="form-group submitButtonFooter">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" id="createOrderBtn" data-loading-text="Loading..." class="btn btn-success"><i class="glyphicon glyphicon-ok-sign"></i> Ajoute devis de Fornisseure</button>
<button type="reset" class="btn btn-default" onclick="resetOrderForm()"><i class="glyphicon glyphicon-erase"></i> Rinitialiser</button>
</div>
</div>
</form>
<?php } else if($_GET['o'] == 'manord') {
// manage order
?>
<div id="success-messages"></div>
<table class="table" id="manageOrderTable">
<thead>
<tr>
<th>#</th>
<th>Date de Devis</th>
<th>Nom du client</th>
<th>Objet</th>
<th>Total de Devis</th>
<th>Option</th>
</tr>
</thead>
</table>
<?php
// /else manage order
} else if($_GET['o'] == 'editOrd') {
// get order
?>
<div class="success-messages"></div> <!--/success-messages-->
<form class="form-horizontal" method="POST" action="php_action/editOrder.php" id="editOrderForm">
<?php $orderId = $_GET['i'];
$sql = "SELECT orders.order_id, orders.order_date, orders.nom, orders.objet, orders.sub_total, orders.vat, orders.total_amount, orders.discount, orders.grand_total, orders.paid, orders.due, orders.payment_type, orders.payment_status, orders.id_payment FROM orders
WHERE orders.order_id = {$orderId}";
$result = $connect->query($sql);
$data = $result->fetch_row();
?>
<div class="form-group">
<label for="orderDate" class="col-sm-2 control-label">Date de Devis</label>
<div class="col-sm-10">
<input type="date" class="form-control" id="orderDate" name="orderDate" autocomplete="off" value="<?php echo $data[1] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="nom" class="col-sm-2 control-label">Client Name</label>
<div class="col-sm-10">
<select class="form-control" name="nom" id="nom" value="<?php echo $data[2] ?>">
<option value="">~~SELECT~~</option>
<?php
$productSql1 = "SELECT * FROM brands WHERE brand_status = 1 ";
$orderItemData = $connect->query("SELECT nom FROM orders WHERE order_status = 1 AND order_id = $orderId");
$productData1 = $connect->query($productSql1);
while($row2 = $orderItemData->fetch_array()) {
$id = $row2['nom'];
}
while($row = $productData1->fetch_array()) {
$selected1 = "";
if($row['brand_id'] == $id) {
$selected1 = "selected";
} else {
$selected1 = "";
}
echo "<option value='".$row['brand_id']."' id='changeProduct".$row['brand_id']."' ".$selected1." >".$row['nom']."</option>";
} // /while
?>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-2 control-label">Objet</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="objet" name="objet" placeholder="Objet" autocomplete="off" value="<?php echo $data[3] ?>" />
</div>
</div> <!--/form-group-->
<table class="table" id="productTable">
<thead>
<tr>
<th style="width:40%;">service</th>
<th style="width:20%;">prix</th>
<th style="width:15%;">Quantity</th>
<th style="width:15%;">Total</th>
<th style="width:10%;">Unit</th>
</tr>
</thead>
<tbody>
<?php
$orderItemSql = "SELECT order_item.order_item_id, order_item.order_id, order_item.product_name, order_item.quantity,order_item.unite, order_item.prix, order_item.total
, order_item.order_item_status FROM order_item WHERE order_item.order_id = {$orderId}";
$orderItemResult = $connect->query($orderItemSql);
// $orderItemData = $orderItemResult->fetch_all();
// print_r($orderItemData);
$arrayNumber = 0;
// for($x = 1; $x <= count($orderItemData); $x++) {
$x = 1;
while($orderItemData = $orderItemResult->fetch_array()) {
// print_r($orderItemData); ?>
<tr id="row<?php echo $x; ?>" class="<?php echo $arrayNumber; ?>">
<td style="margin-left:20px;">
<div class="form-group">
<textarea class="form-control" name="productName[]" id="productName<?php echo $x; ?>" onchange="getProductData(<?php echo $x; ?>)"/><?php echo $orderItemData['product_name']; ?>
</textarea>
</div>
</td>
<td style="padding-left:20px;">
<input type="text" name="prix[]" id="prix<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['prix']; ?>" />
<input type="hidden" name="prixValue[]" id="prixValue<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['prix']; ?>" />
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="number" name="quantity[]" id="quantity<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" min="1" value="<?php echo $orderItemData['quantity']; ?>" />
</div>
</td>
<td style="padding-left:20px;">
<input type="text" name="total[]" id="total<?php echo $x; ?>" autocomplete="off" class="form-control" disabled="true" value="<?php echo $orderItemData['total']; ?>"/>
<input type="hidden" name="totalValue[]" id="totalValue<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['total']; ?>"/>
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="text" name="unite[]" id="unite<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" value="<?php echo $orderItemData['unite']; ?>" />
</div>
</td>
<td>
<button class="btn btn-default removeProductRowBtn" type="button" id="removeProductRowBtn" onclick="removeProductRow(<?php echo $x; ?>)"><i class="glyphicon glyphicon-trash"></i></button>
</td>
</tr>
<?php
$arrayNumber++;
$x++;
} // /for
?>
</tbody>
</table>
<div class="col-md-6">
<div class="form-group">
<label for="subTotal" class="col-sm-3 control-label">Sub Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="subTotal" name="subTotal" disabled="true" value="<?php echo $data[4] ?>" />
<input type="hidden" class="form-control" id="subTotalValue" name="subTotalValue" value="<?php echo $data[4] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="vat" class="col-sm-3 control-label">T.V.A 20%</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="vat" name="vat" disabled="true" value="<?php echo $data[5] ?>" />
<input type="hidden" class="form-control" id="vatValue" name="vatValue" value="<?php echo $data[5] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="totalAmount" class="col-sm-3 control-label">Total Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="totalAmount" name="totalAmount" disabled="true" value="<?php echo $data[6] ?>" />
<input type="hidden" class="form-control" id="totalAmountValue" name="totalAmountValue" value="<?php echo $data[6] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="discount" class="col-sm-3 control-label">Discount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="discount" name="discount" onkeyup="discountFunc()" autocomplete="off" value="<?php echo $data[7] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="grandTotal" class="col-sm-3 control-label">Grand Total</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="grandTotal" name="grandTotal" disabled="true" value="<?php echo $data[8] ?>" />
<input type="hidden" class="form-control" id="grandTotalValue" name="grandTotalValue" value="<?php echo $data[8] ?>" />
</div>
</div> <!--/form-group-->
</div> <!--/col-md-6-->
<div class="col-md-6">
<div class="form-group">
<label for="paid" class="col-sm-3 control-label">Paid Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="paid" name="paid" autocomplete="off" onkeyup="paidAmount()" value="<?php echo $data[9] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="due" class="col-sm-3 control-label">Due Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="due" name="due" disabled="true" value="<?php echo $data[10] ?>" />
<input type="hidden" class="form-control" id="dueValue" name="dueValue" value="<?php echo $data[10] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-3 control-label">Payment Type</label>
<div class="col-sm-9">
<select class="form-control" name="paymentType" onchange="ChequeInput()" id="paymentType" >
<option value="">~~SELECT~~</option>
<option value="1" <?php if($data[11] == 1) {
echo "selected";
$display = 'block';
} ?> >Cheque</option>
<option value="2" <?php if($data[11] == 2) {
$display = 'none';
echo "selected";
} ?> >Cash</option>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group" id="inpcheque" style="display: <?php echo $display ?>;">
<label for="imgCheque" class="col-sm-3 control-label">Image Cheque</label>
<div class="col-sm-9">
<input type="file" class="form-control-file " id="imgCheque" name="imgCheque" />
</div>
</div>
</div> <!--/col-md-6-->
<div class="form-group editButtonFooter">
<div class="col-sm-offset-2 col-sm-10">
<button type="button" class="btn btn-default" onclick="addRow()" id="addRowBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-plus-sign"></i> Ajouter une range </button>
<input type="hidden" name="orderId" id="orderId" value="<?php echo $_GET['i']; ?>" />
<button type="submit" id="editOrderBtn" data-loading-text="Loading..." class="btn btn-success"><i class="glyphicon glyphicon-ok-sign"></i> Sauvegarder les modifications</button>
</div>
</div>
</form>
<?php
} // /get order else ?>
</div> <!--/panel-->
</div> <!--/panel-->
<!-- edit order -->
<div class="modal fade" tabindex="-1" role="dialog" id="paymentOrderModal">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-edit"></i> Modifier le paiement
</h4>
</div>
<div class="modal-body form-horizontal" style="max-height:500px; overflow:auto;" >
<div class="paymentOrderMessages"></div>
<div class="form-group">
<label for="due" class="col-sm-3 control-label">Due Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="due" name="due" disabled="true" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="payAmount" class="col-sm-3 control-label">Montant de la paye</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="payAmount" name="payAmount"/>
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-3 control-label">Type de paiement</label>
<div class="col-sm-9">
<select class="form-control" name="paymentType" id="paymentType" >
<option value="">~~SELECT~~</option>
<option value="1">Cheque</option>
<option value="2">En espces</option>
</select>
</div>
</div> <!--/form-group-->
</div> <!--/modal-body-->
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button>
<button type="button" class="btn btn-primary" id="updatePaymentOrderBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Sauvegarder les modifications
</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<!-- /edit order-->
<!-- Afficher image Devis -->
<div class="modal fade" tabindex="-1" role="dialog" id="affichImgModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-eye-open"></i> Image de Chque</h4>
</div>
<div class="modal-body">
<div class="ImgMessages"></div>
<img src="" id="Img" width="100%">
</div>
<div class="modal-footer removeProductFooter">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Annuler</button>
<a href="" id="downloadImg" download=""><button type="button" class="btn btn-primary" id="ImgBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-download-alt"></i> Telecharger Image</button></a>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<!-- /Afficher image Devis-->
<!-- remove order -->
<div class="modal fade" tabindex="-1" role="dialog" id="removeOrderModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-trash"></i> Supprimer le Devis</h4>
</div>
<div class="modal-body">
<div class="removeOrderMessages"></div>
<p>Voulez-vous vraiment supprimer?</p>
</div>
<div class="modal-footer removeProductFooter">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Annuler</button>
<button type="button" class="btn btn-primary" id="removeOrderBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Sauvegarder les modifications</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<!-- /remove order-->
<script src="custom/js/order.js"></script>
<?php require_once 'includes/footer.php'; ?>
Did this file decode correctly?
Original Code
<?php
require_once 'php_action/db_connect.php';
require_once 'includes/header.php';
if($_GET['o'] == 'add') {
// add order
echo "<div class='div-request div-hide' style='display:none'>add</div>";
} else if($_GET['o'] == 'manord') {
echo "<div class='div-request div-hide' style='display:none'>manord</div>";
} else if($_GET['o'] == 'editOrd') {
echo "<div class='div-request div-hide' style='display:none'>editOrd</div>";
} // /else manage order
?>
<div class="row">
<div class="col-md-12">
<ol class="breadcrumb">
<li><a href="dashboard.php">Accueil</a></li>
<li>Devis</li>
<li class="active">
<?php if($_GET['o'] == 'add') { ?>
Ajouter une Devis
<?php } else if($_GET['o'] == 'manord') { ?>
Grer la Devis
<?php } // /else manage order ?>
</li>
</ol>
<div class="panel panel-default">
<div class="panel-heading">
<?php if($_GET['o'] == 'add') { ?>
<i class="glyphicon glyphicon-plus-sign"></i> Ajouter une Devis
<?php } else if($_GET['o'] == 'manord') { ?>
<i class="glyphicon glyphicon-edit"></i> Grer les Devis
<?php } else if($_GET['o'] == 'editOrd') { ?>
<i class="glyphicon glyphicon-edit"></i> Modifier le Devis
<?php } ?>
</div> <!--/panel-->
<div class="panel-body">
<?php if($_GET['o'] == 'add') {
// add order
?>
<div class="success-messages"></div> <!--/success-messages-->
<form class="form-horizontal" method="POST" action="php_action/createOrder.php" id="createOrderForm">
<div class="form-group">
<label for="orderDate" class="col-sm-2 control-label">Date de Devis</label>
<div class="col-sm-10">
<input type="date" class="form-control" id="orderDate" name="orderDate" autocomplete="off" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="nom" class="col-sm-2 control-label">Nom du client</label>
<div class="col-sm-10">
<select class="form-control" name="nom" id="nom" >
<option value="">~~SELECT~~</option>
<?php
$productSql1 = "SELECT * FROM brands WHERE brand_status = 1 ";
$productData1 = $connect->query($productSql1);
while($row = $productData1->fetch_array()) {
$selected1 = "";
if($row['brand_id'] == $orderItemData['brand_id']) {
$selected1 = "selected1";
} else {
$selected1 = "";
}
echo "<option value='".$row['brand_id']."' id='".$row['brand_id']."' ".$selected1." >".$row['nom']."</option>";
} // /while
?>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-2 control-label">Objet</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="objet" name="objet" placeholder="Objet" autocomplete="off" />
</div>
</div> <!--/form-group-->
<table class="table" id="productTable">
<thead>
<tr>
<th style="width:40%;">service</th>
<th style="width:20%;">prix</th>
<th style="width:15%;">Quantity</th>
<th style="width:15%;">Total</th>
<th style="width:10%;">Unit</th>
</tr>
</thead>
<tbody>
<?php
$arrayNumber = 0;
for($x = 1; $x < 4; $x++) { ?>
<tr id="row<?php echo $x; ?>" class="<?php echo $arrayNumber; ?>">
<td style="margin-left:20px;">
<div class="form-group">
<textarea class="form-control" name="productName[]" id="productName<?php echo $x; ?>" onchange="getProductData(<?php echo $x; ?>)"/></textarea></div>
</td>
<td style="padding-left:20px;">
<input type="text" name="prix[]" id="prix<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" />
<input type="hidden" name="prixValue[]" id="prixValue<?php echo $x; ?>" autocomplete="off" class="form-control" />
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="number" name="quantity[]" id="quantity<?php echo $x; ?>" onchange="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" min="1" />
</div>
</td>
<td style="padding-left:20px;">
<input type="text" name="total[]" id="total<?php echo $x; ?>" autocomplete="off" class="form-control" disabled="true" />
<input type="hidden" name="totalValue[]" id="totalValue<?php echo $x; ?>" autocomplete="off" class="form-control" />
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="text" name="unite[]" id="unite<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" />
</div>
</td>
<td>
<button class="btn btn-default removeProductRowBtn" type="button" id="removeProductRowBtn" onclick="removeProductRow(<?php echo $x; ?>)"><i class="glyphicon glyphicon-trash"></i></button>
</td>
</tr>
<?php
$arrayNumber++;
} // /for
?>
</tbody>
</table>
<div class="col-md-6">
<div class="form-group">
<label for="subTotal" class="col-sm-3 control-label">Sous-total</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="subTotal" name="subTotal" disabled="true" />
<input type="hidden" class="form-control" id="subTotalValue" name="subTotalValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="vat" class="col-sm-3 control-label">T.V.A.20%</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="vat" name="vat" disabled="true" />
<input type="hidden" class="form-control" id="vatValue" name="vatValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="totalAmount" class="col-sm-3 control-label">Montant total</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="totalAmount" name="totalAmount" disabled="true"/>
<input type="hidden" class="form-control" id="totalAmountValue" name="totalAmountValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="discount" class="col-sm-3 control-label">Remise</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="discount" name="discount" onkeyup="discountFunc()" autocomplete="off" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="grandTotal" class="col-sm-3 control-label">somme finale</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="grandTotal" name="grandTotal" disabled="true" />
<input type="hidden" class="form-control" id="grandTotalValue" name="grandTotalValue" />
</div>
</div> <!--/form-group-->
</div> <!--/col-md-6-->
<div class="col-md-6">
<div class="form-group">
<label for="paid" class="col-sm-3 control-label">Montant pay</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="paid" name="paid" autocomplete="off" onkeyup="paidAmount()" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="due" class="col-sm-3 control-label">Due Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="due" name="due" disabled="true" />
<input type="hidden" class="form-control" id="dueValue" name="dueValue" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-3 control-label">Type de paiement</label>
<div class="col-sm-9">
<select class="form-control" name="paymentType" onchange="ChequeInput()" id="paymentType">
<option value="">~~SELECT~~</option>
<option value="1">Chque</option>
<option value="2">Cash</option>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group" id="inpcheque" style="display: none;">
<label for="imgCheque" class="col-sm-3 control-label">Image Cheque</label>
<div class="col-sm-9">
<input type="file" class="form-control-file " id="imgCheque" name="imgCheque" />
</div>
</div>
</div> <!--/col-md-6-->
<div class="form-group submitButtonFooter">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" id="createOrderBtn" data-loading-text="Loading..." class="btn btn-success"><i class="glyphicon glyphicon-ok-sign"></i> Ajoute devis de Fornisseure</button>
<button type="reset" class="btn btn-default" onclick="resetOrderForm()"><i class="glyphicon glyphicon-erase"></i> Rinitialiser</button>
</div>
</div>
</form>
<?php } else if($_GET['o'] == 'manord') {
// manage order
?>
<div id="success-messages"></div>
<table class="table" id="manageOrderTable">
<thead>
<tr>
<th>#</th>
<th>Date de Devis</th>
<th>Nom du client</th>
<th>Objet</th>
<th>Total de Devis</th>
<th>Option</th>
</tr>
</thead>
</table>
<?php
// /else manage order
} else if($_GET['o'] == 'editOrd') {
// get order
?>
<div class="success-messages"></div> <!--/success-messages-->
<form class="form-horizontal" method="POST" action="php_action/editOrder.php" id="editOrderForm">
<?php $orderId = $_GET['i'];
$sql = "SELECT orders.order_id, orders.order_date, orders.nom, orders.objet, orders.sub_total, orders.vat, orders.total_amount, orders.discount, orders.grand_total, orders.paid, orders.due, orders.payment_type, orders.payment_status, orders.id_payment FROM orders
WHERE orders.order_id = {$orderId}";
$result = $connect->query($sql);
$data = $result->fetch_row();
?>
<div class="form-group">
<label for="orderDate" class="col-sm-2 control-label">Date de Devis</label>
<div class="col-sm-10">
<input type="date" class="form-control" id="orderDate" name="orderDate" autocomplete="off" value="<?php echo $data[1] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="nom" class="col-sm-2 control-label">Client Name</label>
<div class="col-sm-10">
<select class="form-control" name="nom" id="nom" value="<?php echo $data[2] ?>">
<option value="">~~SELECT~~</option>
<?php
$productSql1 = "SELECT * FROM brands WHERE brand_status = 1 ";
$orderItemData = $connect->query("SELECT nom FROM orders WHERE order_status = 1 AND order_id = $orderId");
$productData1 = $connect->query($productSql1);
while($row2 = $orderItemData->fetch_array()) {
$id = $row2['nom'];
}
while($row = $productData1->fetch_array()) {
$selected1 = "";
if($row['brand_id'] == $id) {
$selected1 = "selected";
} else {
$selected1 = "";
}
echo "<option value='".$row['brand_id']."' id='changeProduct".$row['brand_id']."' ".$selected1." >".$row['nom']."</option>";
} // /while
?>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-2 control-label">Objet</label>
<div class="col-sm-10">
<input type="text" class="form-control" id="objet" name="objet" placeholder="Objet" autocomplete="off" value="<?php echo $data[3] ?>" />
</div>
</div> <!--/form-group-->
<table class="table" id="productTable">
<thead>
<tr>
<th style="width:40%;">service</th>
<th style="width:20%;">prix</th>
<th style="width:15%;">Quantity</th>
<th style="width:15%;">Total</th>
<th style="width:10%;">Unit</th>
</tr>
</thead>
<tbody>
<?php
$orderItemSql = "SELECT order_item.order_item_id, order_item.order_id, order_item.product_name, order_item.quantity,order_item.unite, order_item.prix, order_item.total
, order_item.order_item_status FROM order_item WHERE order_item.order_id = {$orderId}";
$orderItemResult = $connect->query($orderItemSql);
// $orderItemData = $orderItemResult->fetch_all();
// print_r($orderItemData);
$arrayNumber = 0;
// for($x = 1; $x <= count($orderItemData); $x++) {
$x = 1;
while($orderItemData = $orderItemResult->fetch_array()) {
// print_r($orderItemData); ?>
<tr id="row<?php echo $x; ?>" class="<?php echo $arrayNumber; ?>">
<td style="margin-left:20px;">
<div class="form-group">
<textarea class="form-control" name="productName[]" id="productName<?php echo $x; ?>" onchange="getProductData(<?php echo $x; ?>)"/><?php echo $orderItemData['product_name']; ?>
</textarea>
</div>
</td>
<td style="padding-left:20px;">
<input type="text" name="prix[]" id="prix<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['prix']; ?>" />
<input type="hidden" name="prixValue[]" id="prixValue<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['prix']; ?>" />
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="number" name="quantity[]" id="quantity<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" min="1" value="<?php echo $orderItemData['quantity']; ?>" />
</div>
</td>
<td style="padding-left:20px;">
<input type="text" name="total[]" id="total<?php echo $x; ?>" autocomplete="off" class="form-control" disabled="true" value="<?php echo $orderItemData['total']; ?>"/>
<input type="hidden" name="totalValue[]" id="totalValue<?php echo $x; ?>" autocomplete="off" class="form-control" value="<?php echo $orderItemData['total']; ?>"/>
</td>
<td style="padding-left:20px;">
<div class="form-group">
<input type="text" name="unite[]" id="unite<?php echo $x; ?>" onkeyup="getTotal(<?php echo $x ?>)" autocomplete="off" class="form-control" value="<?php echo $orderItemData['unite']; ?>" />
</div>
</td>
<td>
<button class="btn btn-default removeProductRowBtn" type="button" id="removeProductRowBtn" onclick="removeProductRow(<?php echo $x; ?>)"><i class="glyphicon glyphicon-trash"></i></button>
</td>
</tr>
<?php
$arrayNumber++;
$x++;
} // /for
?>
</tbody>
</table>
<div class="col-md-6">
<div class="form-group">
<label for="subTotal" class="col-sm-3 control-label">Sub Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="subTotal" name="subTotal" disabled="true" value="<?php echo $data[4] ?>" />
<input type="hidden" class="form-control" id="subTotalValue" name="subTotalValue" value="<?php echo $data[4] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="vat" class="col-sm-3 control-label">T.V.A 20%</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="vat" name="vat" disabled="true" value="<?php echo $data[5] ?>" />
<input type="hidden" class="form-control" id="vatValue" name="vatValue" value="<?php echo $data[5] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="totalAmount" class="col-sm-3 control-label">Total Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="totalAmount" name="totalAmount" disabled="true" value="<?php echo $data[6] ?>" />
<input type="hidden" class="form-control" id="totalAmountValue" name="totalAmountValue" value="<?php echo $data[6] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="discount" class="col-sm-3 control-label">Discount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="discount" name="discount" onkeyup="discountFunc()" autocomplete="off" value="<?php echo $data[7] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="grandTotal" class="col-sm-3 control-label">Grand Total</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="grandTotal" name="grandTotal" disabled="true" value="<?php echo $data[8] ?>" />
<input type="hidden" class="form-control" id="grandTotalValue" name="grandTotalValue" value="<?php echo $data[8] ?>" />
</div>
</div> <!--/form-group-->
</div> <!--/col-md-6-->
<div class="col-md-6">
<div class="form-group">
<label for="paid" class="col-sm-3 control-label">Paid Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="paid" name="paid" autocomplete="off" onkeyup="paidAmount()" value="<?php echo $data[9] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="due" class="col-sm-3 control-label">Due Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="due" name="due" disabled="true" value="<?php echo $data[10] ?>" />
<input type="hidden" class="form-control" id="dueValue" name="dueValue" value="<?php echo $data[10] ?>" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-3 control-label">Payment Type</label>
<div class="col-sm-9">
<select class="form-control" name="paymentType" onchange="ChequeInput()" id="paymentType" >
<option value="">~~SELECT~~</option>
<option value="1" <?php if($data[11] == 1) {
echo "selected";
$display = 'block';
} ?> >Cheque</option>
<option value="2" <?php if($data[11] == 2) {
$display = 'none';
echo "selected";
} ?> >Cash</option>
</select>
</div>
</div> <!--/form-group-->
<div class="form-group" id="inpcheque" style="display: <?php echo $display ?>;">
<label for="imgCheque" class="col-sm-3 control-label">Image Cheque</label>
<div class="col-sm-9">
<input type="file" class="form-control-file " id="imgCheque" name="imgCheque" />
</div>
</div>
</div> <!--/col-md-6-->
<div class="form-group editButtonFooter">
<div class="col-sm-offset-2 col-sm-10">
<button type="button" class="btn btn-default" onclick="addRow()" id="addRowBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-plus-sign"></i> Ajouter une range </button>
<input type="hidden" name="orderId" id="orderId" value="<?php echo $_GET['i']; ?>" />
<button type="submit" id="editOrderBtn" data-loading-text="Loading..." class="btn btn-success"><i class="glyphicon glyphicon-ok-sign"></i> Sauvegarder les modifications</button>
</div>
</div>
</form>
<?php
} // /get order else ?>
</div> <!--/panel-->
</div> <!--/panel-->
<!-- edit order -->
<div class="modal fade" tabindex="-1" role="dialog" id="paymentOrderModal">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-edit"></i> Modifier le paiement
</h4>
</div>
<div class="modal-body form-horizontal" style="max-height:500px; overflow:auto;" >
<div class="paymentOrderMessages"></div>
<div class="form-group">
<label for="due" class="col-sm-3 control-label">Due Amount</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="due" name="due" disabled="true" />
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="payAmount" class="col-sm-3 control-label">Montant de la paye</label>
<div class="col-sm-9">
<input type="text" class="form-control" id="payAmount" name="payAmount"/>
</div>
</div> <!--/form-group-->
<div class="form-group">
<label for="objet" class="col-sm-3 control-label">Type de paiement</label>
<div class="col-sm-9">
<select class="form-control" name="paymentType" id="paymentType" >
<option value="">~~SELECT~~</option>
<option value="1">Cheque</option>
<option value="2">En espces</option>
</select>
</div>
</div> <!--/form-group-->
</div> <!--/modal-body-->
<div class="modal-footer">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Close</button>
<button type="button" class="btn btn-primary" id="updatePaymentOrderBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Sauvegarder les modifications
</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<!-- /edit order-->
<!-- Afficher image Devis -->
<div class="modal fade" tabindex="-1" role="dialog" id="affichImgModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-eye-open"></i> Image de Chque</h4>
</div>
<div class="modal-body">
<div class="ImgMessages"></div>
<img src="" id="Img" width="100%">
</div>
<div class="modal-footer removeProductFooter">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Annuler</button>
<a href="" id="downloadImg" download=""><button type="button" class="btn btn-primary" id="ImgBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-download-alt"></i> Telecharger Image</button></a>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<!-- /Afficher image Devis-->
<!-- remove order -->
<div class="modal fade" tabindex="-1" role="dialog" id="removeOrderModal">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title"><i class="glyphicon glyphicon-trash"></i> Supprimer le Devis</h4>
</div>
<div class="modal-body">
<div class="removeOrderMessages"></div>
<p>Voulez-vous vraiment supprimer?</p>
</div>
<div class="modal-footer removeProductFooter">
<button type="button" class="btn btn-default" data-dismiss="modal"> <i class="glyphicon glyphicon-remove-sign"></i> Annuler</button>
<button type="button" class="btn btn-primary" id="removeOrderBtn" data-loading-text="Loading..."> <i class="glyphicon glyphicon-ok-sign"></i> Sauvegarder les modifications</button>
</div>
</div><!-- /.modal-content -->
</div><!-- /.modal-dialog -->
</div><!-- /.modal -->
<!-- /remove order-->
<script src="custom/js/order.js"></script>
<?php require_once 'includes/footer.php'; ?>
Function Calls
| None |
Stats
| MD5 | d34673a68d6f3de984d3c9c6ef68694a |
| Eval Count | 0 |
| Decode Time | 110 ms |