static function getOrdenesDeCompraByUserId($data)
{
$ocs = array();
$conn = ExternalDao::getConnection();
$sql = "select * from vt080_oc_cabe where f_entrega between " . $data->date . " and DATEADD(day, u_dias_limite_entrega, '" . $data->date . "') ";
if ($data->sucursalId) {
$sql = $sql . " and (M_OC_MADRE = 'S' or C_SUCU_DESTINO_ALT = " . $data->sucursalId . ' ) ';
}
if (isset($data->proveedorId) && $data->proveedorId) {
$sql = $sql . " and c_proveedor = " . $data->proveedorId;
} else {
if (isset($data->userId) && $data->userId) {
$users_proveedor = SecurityDao::getUserProveedores($data->userId);
$proveedorIds = Phinq::create($users_proveedor)->select(function ($item) {
return $item->proveedorId;
})->toArray();
$ids = implode(" , ", $proveedorIds);
$sql = $sql . " and c_proveedor in ( " . $ids . ") ";
}
}
$sql = $sql . " order by U_SUFIJO_OC ";
$stmt = sqlsrv_query($conn, $sql, null);
if ($stmt === false) {
die(print_r(sqlsrv_errors(), true));
}
while ($row = sqlsrv_fetch_array($stmt, SQLSRV_FETCH_ASSOC)) {
$oc = new \stdClass();
$oc->id = $row['U_SUFIJO_OC'];
$oc->proveedorId = $row['C_PROVEEDOR'];
$oc->fecha = $row['F_ENTREGA']->format('Y-m-d H:i:s');
$oc->diasLimiteEntrega = $row['U_DIAS_LIMITE_ENTREGA'];
array_push($ocs, $oc);
}
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
return $ocs;
}
static function addFormEntryMessage($messageDto)
{
$transaction = NULL;
$result = array();
$dwoo = new Core();
try {
$transaction = GenericDao::beginTransaction();
$message = new FormEntryMessage(null, date("Y-m-d H:i:s", time()), true, $messageDto->proveedorId, $messageDto->entryId, $messageDto->formId, $messageDto->message, $messageDto->sender);
FormDao::addFormEntryMessage($message, $transaction);
$entry = FormAdmin::getFormEntryDetailById($messageDto->formId, $messageDto->entryId);
if ($messageDto->sender == MessageSender::cliente) {
FormAdmin::changeProveedorEntryState($messageDto->proveedorId, $messageDto->formId, $messageDto->entryId, \entities\ClienteState::enviada, \entities\ProveedorState::recibida);
$transaction->commit();
$proveedor = ProveedorDao::getProveedorById($messageDto->proveedorId);
$user = SecurityDao::getUserById($proveedor->usuarioId);
$dest = 'proveedor';
} else {
FormAdmin::changeProveedorEntryState($messageDto->proveedorId, $messageDto->formId, $messageDto->entryId, \entities\ClienteState::enProceso, \entities\ProveedorState::enProceso);
$transaction->commit();
$user = SecurityDao::getUserById($entry->userId);
$dest = 'cliente';
}
$user->logo = AppConfig::logoUrl;
$user->producto = $entry->producto;
$code = base64_encode($user->id . '|' . $user->createDate . '|' . $user->mail . '|' . $dest . '|' . date("Y-m-d H:i:s", time()));
$link = 'http://' . getenv('HTTP_HOST') . APP_FOLDER . '/views/client/AutoLoginManager.php?c=' . $code;
$user->link = $link;
$template = $dwoo->get($_SERVER["DOCUMENT_ROOT"] . '/views/shared/templates/mails/newMessage.tpl', (array) $user);
Mail::Send($user->mail, 'Aladinnus, nuevo mensaje', $template);
} catch (\Exception $ex) {
$transaction->rollBack();
$result = array($ex->getMessage());
}
return $result;
}
<?php
if (!isset($_SESSION)) {
session_start();
}
$_SERVER["DOCUMENT_ROOT"] = $_SERVER["DOCUMENT_ROOT"] . '/turnos';
include_once $_SERVER["DOCUMENT_ROOT"] . '/common/Includes.php';
use admin\SolicitudesEntregaAdmin;
use dao\SecurityDao;
$solicitud = SolicitudesEntregaAdmin::getSolicitudEntregaById($_GET['id']);
$user = SecurityDao::getUserById($solicitud->userId);
$barcode = str_repeat("0", 8 - strlen($user->id)) . $user->id . str_repeat("0", 8 - strlen($solicitud->id)) . $solicitud->id;
$status = null;
switch ($solicitud->status) {
case 1:
$status = 'Ingresada';
break;
case 2:
$status = 'Pendiente de confirmación';
break;
case 3:
$status = 'Confirmada';
break;
case 4:
$status = 'Rechazada';
break;
}
$generator = new \lib\barcode\BarcodeGeneratorPNG();
$img = 'data:image/png;base64,' . base64_encode($generator->getBarcode($barcode, $generator::TYPE_CODE_128));
$pdf = new \lib\FPDF();
$pdf->AddPage();
static function changeState($solicitudEntregId, $status)
{
$solicitudEntrega = SolicitudesEntregaDao::getSolicitudEntregaById($solicitudEntregId);
$actualOcs = SolicitudesEntregaDao::getOrdenesDeCompraBySolicitudId($solicitudEntregId);
$proveedor = SecurityDao::getUserById($solicitudEntrega->userId);
try {
$transaction = GenericDao::beginTransaction();
$solicitudEntrega->status = $status;
$solicitudEntrega->updateDate = date("Y-m-d H:i:s", time());
SolicitudesEntregaDao::updateSolicitudEntrega($solicitudEntrega, $transaction);
$transaction->commit();
$ordenesDeCompraDetail = '';
foreach ($actualOcs as $oc) {
$ordenesDeCompraDetail = $ordenesDeCompraDetail . ', ' . $oc->ordenDeCompraId;
}
$ordenesDeCompraDetail = substr($ordenesDeCompraDetail, 1);
$subject = 'Entrega de solicitud';
$name = 'Administrador';
$title = 'Se le comunica que el proveedor ' . $proveedor->firstName . 'ha hecho entrega de la solicitud nro. ' . $solicitudEntrega->id . '.';
$detail = 'La entrega esta compuesta por las siguientes ordenes de compra: ' . $ordenesDeCompraDetail;
SolicitudesEntregaAdmin::sendMail('*****@*****.**', $subject, $name, $title, $detail);
} catch (\Exception $ex) {
$transaction->rollBack();
}
}
static function deleteReserva($id)
{
$reserva = SecurityDao::getReservaById($id);
$result = new Result();
try {
$transaction = GenericDao::beginTransaction();
$reserva->deleted = true;
SecurityDao::updateReserva($reserva, $transaction);
$transaction->commit();
} catch (\Exception $ex) {
$transaction->rollBack();
$result->hasErrors = true;
$result->messages = array($ex->getMessage());
}
$response = new Response($result, NULL);
return json_encode($response);
}
