public function mapAction($idVisit)
{
$visit = Visit::findFirst(array("conditions" => "idVisit = ?1", "bind" => array(1 => $idVisit)));
if (!$visit) {
$this->flashSession->error("Ocurrio un error procesando su solicitud, por favor intentelo nuevamente.");
return $this->response->redirect('index');
}
$user = User::findFirst(array("conditions" => "idUser = ?1 AND idAccount = ?2", "bind" => array(1 => $visit->idUser, 2 => $this->user->idAccount)));
if (!$user) {
$this->flashSession->error("Ocurrio un error procesando su solicitud, por favor intentelo nuevamente.");
return $this->response->redirect('visit/index');
}
try {
$sql_rows = "SELECT v.idVisit AS idUser, v.start AS date, u.name AS name, u.lastName AS lastname, vt.name AS visit, c.name AS client, v.battery AS battery, v.latitude AS latitude, v.longitude AS longitude, v.location AS location " . "FROM Visit AS v " . " JOIN User AS u ON (u.idUser = v.idUser) " . " JOIN Visittype AS vt ON (vt.idVisittype = v.idVisittype) " . " JOIN Client AS c ON (c.idClient = v.idClient) " . " WHERE v.idVisit = {$idVisit}";
// $this->logger->log($sql_rows);
$modelsManager = \Phalcon\DI::getDefault()->get('modelsManager');
$rows = $modelsManager->executeQuery($sql_rows);
$this->view->setVar('visit', $rows->getFirst());
$this->view->setVar('user', $user);
} catch (Exception $e) {
$this->flashSession->error($e->getMessage());
$this->trace("fail", $e->getMessage());
return $this->response->redirect('visit/index');
}
}
public static function hasDone($uid)
{
$visit = Visit::findFirst("uid={$uid}");
if (!$visit) {
return false;
}
$advises = Advise::getAdvisesByUid($uid, Advise::STATUS_UNDO, 'visit');
return $advises ? false : true;
}
public static function advise($uid, $foid, $adviseType, $reason, $loan = false)
{
$isLoanSketch = false;
switch ($adviseType) {
case 'loansketch':
$status = \App\LoanStatus::getStatusSketch();
$oid = User::findFirst("uid={$uid}")->oid;
$isLoanSketch = true;
break;
case 'visit':
$status = \App\LoanStatus::getStatusCarAssess();
$oid = Visit::findFirst("uid={$uid}")->oid;
$isLoanSketch = true;
break;
case 'car':
$status = \App\LoanStatus::getStatusVisit();
$oid = Car::findFirst("uid={$uid}")->oid;
$isLoanSketch = true;
break;
case 'face':
$status = \App\LoanStatus::getStatusChecked();
$oid = Face::findFirst("uid={$uid}")->oid;
$isLoanSketch = true;
break;
}
if (empty($oid)) {
return false;
}
if ($isLoanSketch) {
$model = LoanSketch::findFirst("uid={$uid}");
$model->status = $status;
$model->update();
}
Advise::add($uid, $oid, $foid, $adviseType, $reason);
return true;
}
