| Server IP : 74.208.127.88 / Your IP : 3.147.140.129 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/muebles/mueblesOLDMAYO/applicationOLD/category/ |
Upload File : |
<?php
session_start();
require_once ("../model/dbconn.php");
require_once ("../model/pos.php");
function cmp($a, $b) {
return strcmp($a["id_item"], $b["id_item"]);
}
$method=$_POST['method'];
//LISTAR LA TABLA DE VENTAS DE HOY PARA MANDAR A COBRO
if($method == 'list_data'){
$id_colletor = $_POST['id_empl'];
$pos = new pos();
$array = $pos->getCollectorList($id_colletor);
$data = $array[2];
$i=0;
foreach ($data as $key) {
//1. obtenemos el id del cliente en base al contrato
$id_item=$data[$i]['id_client'];
$pos2 = new pos();
$array2 = $pos2->getCustomer($id_item);
$id_cust = $array2[1]['id_cust'];
$name_client = $array2[1]['name'];
if($id_item<10){
$name_client = 'VENTA PUBLICO EN GENERAL';
}
//2. ahora obtenemos pago minimo
$pos3=new pos();
$data3= $pos3->getCollectionPay($id_cust);
$pay_min= $data3[1]['min_pay'];
$payday = $data3[1]['payday'];
$txtpayment_period = $data3[1]['txtpayment_period'];
switch($txtpayment_period) {
case 1: $txtpayment_period= "S";
break;
case 2: $txtpayment_period= "C";
break;
case 3: $txtpayment_period= "Q";
break;
case 4: $txtpayment_period= "M";
break;
case 0: $txtpayment_period= "S";
break;
}
//obtenemos el enganche
$enganche= $data[$i]['disc_rp'];
//2a. obtenemos la fecha del siguiente abono en baso a dias de pago y periodicidad
$date_pay1=date("l j F, Y");
//4. obtenemos si hay abonos y hacemos diferencia del total para que se obtenga el saldo
//saldo = total- enganche - (abonos);
$pos4=new pos();
$sale_id = $data[$i]['sale_id'];
$data4= $pos4->getPays($id_item,$sale_id);
$balance= abs($data4[1]['balance']);
$saldo = $data[$i]['total'] - $enganche - $balance;
//5.obtenemos el nombre del cobrador
$pos5=new pos();
$collector_id = $data[$i]['id_collector'];
$data5= $pos5->getEmployee($collector_id);
$name_repartidor = $data5[1]['name'];
$var= $payday;
switch($var) {
case 7: $payday= " domingo";
break;
case 1: $payday= "Lunes";
break;
case 2: $payday= "Martes";
break;
case 3: $payday= "Miercoles";
break;
case 4: $payday= "Jueves";
break;
case 5: $payday= "viernes";
break;
case 6: $payday= "Sabado";
break;
}
$data[$i]['cuenta']="<td><input id='id_cuenta' value='224'></td>";
$data[$i]['sale_id']= $data[$i]['sale_id'];
$data[$i]['id_client']= $data[$i]['id_client'];
$data[$i]['name_client'] = $name_client;
//fecha de venta sigue//////
$data[$i]['total'] = number_format($data[$i]['total'],2);
$data[$i]['pay_min']= $pay_min;
$data[$i]['payday'] = $payday;
$data[$i]['txtpayment_period'] = $txtpayment_period;
$data[$i]['enganche'] = number_format($enganche,2);
$data[$i]['date_pay1'] = $date_pay1;
$data[$i]['balance'] = number_format($saldo,2);
$data[$i]['id_collector']= $name_repartidor;
$i++;
}
$datax = array('data' => $data);
echo json_encode($datax);
}