-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathfunciones.php
173 lines (153 loc) · 6.33 KB
/
funciones.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
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
<?php
function get_row($table,$row, $id, $equal){
global $con;
$query=mysqli_query($con,"select $row from $table where $id='$equal'");
$rw=mysqli_fetch_array($query);
$value=$rw[$row];
return $value;
}
?>
<?php
require_once ("config/db.php");//Contiene las variables de configuracion para conectar a la base de datos
require_once ("config/conexion.php");//Conti
function cliente()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM clientes");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function factura()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM facturas");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function venta()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT ROUND(SUM(total_venta),2) as total FROM facturas ");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function productos()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT SUM(cantidad) as total FROM detalle_factura");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function productos_finales()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM products WHERE id_tipo=1");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function productos_materiales()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM products WHERE id_tipo=2");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function productos_insumos()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM products WHERE id_tipo=3");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function productos_total()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM products");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function productos_min()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM products WHERE products.id_tipo=1 and products.stock_min>=products.stock");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function materiales_insumos_min()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM products WHERE (products.id_tipo=2 or products.id_tipo=3) and products.stock_min>=products.stock");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function produccion()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM ordenp");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function requisicion()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT COUNT(*) as total FROM requisicion");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function p_producidos()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT SUM(cantidad) as total FROM detalle_ordenp");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
function p_requeridos()
{
global $con;
$query_ConsultaFuncion = sprintf("SELECT SUM(cantidad) as total FROM detalle_requisicion");
$ConsultaFuncion = mysqli_query($con, $query_ConsultaFuncion) or die(mysqli_error($con));
$row_ConsultaFuncion = mysqli_fetch_assoc($ConsultaFuncion);
$totalRows_ConsultaFuncion = mysqli_num_rows($ConsultaFuncion);
return $row_ConsultaFuncion['total'];
mysqli_free_result($ConsultaFuncion);
}
?>