-
Notifications
You must be signed in to change notification settings - Fork 0
/
add_product.php
120 lines (114 loc) · 4.56 KB
/
add_product.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
<?php
$page_title = 'Agregar producto';
require_once('includes/load.php');
// Verificar que nivel de usuario tiene permiso de ver esta página.
page_require_level(2);
$all_categories = find_all('categories');
$all_photo = find_all('media');
if(isset($_POST['add_product'])){
$req_fields = array('product-title','product-categorie','product-quantity','buying-price', 'saleing-price' );
validate_fields($req_fields);
if(empty($errors)){
$p_name = remove_junk($db->escape($_POST['product-title']));
$p_cat = remove_junk($db->escape($_POST['product-categorie']));
$p_qty = remove_junk($db->escape($_POST['product-quantity']));
$p_buy = remove_junk($db->escape($_POST['buying-price']));
$p_sale = remove_junk($db->escape($_POST['saleing-price']));
$date = make_date();
$query = "INSERT INTO products (";
$query .=" name,quantity,buy_price,sale_price,categorie_id,media_id,date";
$query .=") VALUES (";
$query .=" '{$p_name}', '{$p_qty}', '{$p_buy}', '{$p_sale}', '{$p_cat}', '{$media_id}', '{$date}'";
$query .=")";
$query .=" ON DUPLICATE KEY UPDATE name='{$p_name}'";
if($db->query($query)){
$session->msg('s',"Producto agregado exitosamente.");
redirect('add_product.php', false);
}else{
$session->msg('d','Registro fallido.');
redirect('product.php', false);
}
}else{
$session->msg("d", $errors);
redirect('add_product.php',false);
}
}
?>
<?php include_once('layouts/header.php'); ?>
<div class="row">
<div class="col-md-12">
<?php echo display_msg($msg); ?>
</div>
</div>
<div class="row">
<div class="col-md-12">
<div class="panel panel-default">
<div class="panel-heading">
<strong>
<span class="glyphicon glyphicon-th"></span>
<span>Agregar producto</span>
</strong>
</div>
<div class="panel-body">
<div class="col-md-12">
<form method="post" action="add_product.php" class="clearfix">
<div class="form-group">
<div class="input-group">
<span class="input-group-addon">
<i class="glyphicon glyphicon-th-large"></i>
</span>
<input type="text" class="form-control" name="product-title" placeholder="Descripción">
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-md-12">
<select class="form-control" name="product-categorie">
<option value="">Selecciona una categoría</option>
<?php foreach ($all_categories as $cat): ?>
<option value="<?php echo (int)$cat['id'] ?>">
<?php echo $cat['name'] ?>
</option>
<?php endforeach; ?>
</select>
</div>
</div>
</div>
<div class="form-group">
<div class="row">
<div class="col-md-4">
<div class="input-group">
<span class="input-group-addon">
<i class="glyphicon glyphicon-shopping-cart"></i>
</span>
<input type="number" class="form-control" name="product-quantity" placeholder="Cantidad">
</div>
</div>
<div class="col-md-4">
<div class="input-group">
<span class="input-group-addon">
<i class="glyphicon glyphicon-usd"></i>
</span>
<input type="number" class="form-control" name="buying-price" placeholder="Precio de compra">
<span class="input-group-addon">.00</span>
</div>
</div>
<div class="col-md-4">
<div class="input-group">
<span class="input-group-addon">
<i class="glyphicon glyphicon-usd"></i>
</span>
<input type="number" class="form-control" name="saleing-price" placeholder="Precio de venta">
<span class="input-group-addon">.00</span>
</div>
</div>
</div>
</div>
<button type="submit" name="add_product" class="btn btn-danger">Agregar producto</button>
</form>
</div>
</div>
</div>
</div>
</div>
<?php include_once('layouts/footer.php'); ?>