| Server IP : 74.208.127.88 / Your IP : 3.17.73.81 Web Server : Apache/2.4.41 (Ubuntu) System : Linux ubuntu 5.4.0-163-generic #180-Ubuntu SMP Tue Sep 5 13:21:23 UTC 2023 x86_64 User : www-data ( 33) PHP Version : 7.4.3-4ubuntu2.29 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,pcntl_unshare, MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /var/www/html/t/sae/appsae/report/ |
Upload File : |
<?php
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
include "../core/autoload.php";
include "../core/app/model/ProductData.php";
include "../core/app/model/OperationData.php";
include "../core/app/model/CategoryData.php";
$date1 = $_POST['date1'];
$date2 = $_POST['date2'];
$barcode = $_POST['txtsearchitem'];
if (!empty($_POST['date1']) and !empty($_POST['date1'])){
/*Conectarse a la base de datos
$conn = new mysqli("localhost", "root", "", "pos36");
if(!$conn){
die("Fatal Error: No se pudo contectar a la base de datos!");
}
$q_book = $conn->query("select * from t_sale_detail where date(created_at) >= \"$date1\" and date(created_at) <= \"$date2\" order by created_at desc") or die(mysqli_error());
$v_book = $q_book->num_rows;
*/
if(empty($_POST['txtsearchitem'])){
$users = OperationData::getTsaleDetailByDate($date1,$date2);
if(count($users)>0){
$total=0;
foreach($users as $user){
$total = $total + $user->qty;
?>
<tr style="background:#red">
<td><?php echo $user->barcode;?></td>
<td><?php echo $user->item_name;?></td>
<td><?php echo $user->price;?></td>
<td><?php echo $user->qty;?></td>
<td><?php echo date("d/m/Y g:i a", strtotime($user->created_at));?></td>
</tr>
<?php
}
echo '
<tr>
<td colspan = "3" class="text-right">Articulos Vendidos: '.$total.'</td>
</tr>
';
?>
<?php
}else{
echo '
<tr>
<td colspan = "4" class="text-center">No se encontraron registros</td>
</tr>
';
}
}else{
//getTsaleDetailByDate_prod
$users = OperationData::getTsaleDetailByDate_prod($date1,$date2,$barcode);
//print_r($users);
?>
<tr style="background:#red">
<td><?php echo $users->barcode;?></td>
<td><?php echo $users->item_name;?></td>
<td><?php echo $users->price;?></td>
<td><?php echo $users->cant;?></td>
<td></td>
</tr>
<?php
}
} else {
echo '
<tr>
<td colspan = "4" class="text-center">Error de fechas</td>
</tr>
';
}
?>