public static function listAll(&$eT_ANALYTICS)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mP_TAnalytics T_Analytics_Model */
$mP_TAnalytics = $MY->mP_TAnalytics;
$eT_ANALYTICS = $mP_TAnalytics->loadAll();
$oBus->isSuccess(TRUE);
return $oBus;
}
public static function loadCiudad($id_ciudad, &$eCiudad)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mCiudad Ciudad_Model */
$mCiudad = $MY->mCiudad;
$eCiudad = $mCiudad->load($id_ciudad);
$oBus->isSuccess(TRUE);
return $oBus;
}
public static function listPais(&$ePaises)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mPais Pais_Model */
$mPais = $MY->mPais;
$ePaises = $mPais->listAll('', NULL, NULL);
$oBus->isSuccess(TRUE);
return $oBus;
}
public static function saveProfilePermission($id_profile, $arr_eProfilePermissions)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mProfilePermission Profile_Permission_Model */
$mProfilePermission =& $MY->mProfilePermission;
$oTransaction = new MY_Business();
$oTransaction->begin();
try {
$mProfilePermission->deleteByProfile($id_profile);
/* @var $eProfilePermission eProfilePermission*/
foreach ($arr_eProfilePermissions as $eProfilePermission) {
if (!empty($eProfilePermission->id_permission)) {
$mProfilePermission->save($eProfilePermission);
}
}
$oTransaction->commit();
$oBus->isSuccess(TRUE);
$oBus->message("Guardado exitosamente");
} catch (Exception $e) {
$oTransaction->rollback();
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
return $oBus;
}
public static function loadUser($id_user)
{
$MY =& MY_Controller::get_instance();
$oBus = new Response_Business();
/* @var $mUser User_Model */
$mUser =& $MY->mUser;
try {
/* @var $eUser eUser */
$eUser = $mUser->load($id_user);
$oBus->isSuccess(TRUE);
} catch (Exception $e) {
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
$oBus->data(array('eUser' => $eUser));
return $oBus;
}
public static function listCatalog()
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mCatalog Catalog_Model */
$mCatalog = $MY->mCatalog;
/* @var $mCatalogByType Catalog_Type_Model */
$mCatalogByType = $MY->mCatalogType;
$data = array();
$mCatalogByTypes = $mCatalogByType->listAll(NULL, NULL, NULL);
if (!empty($mCatalogByTypes)) {
foreach ($mCatalogByTypes as $eTypeByCatalog) {
/* @var $eTypeByCatalog eCatalogType */
$eCatalogos = $mCatalog->listAll($eTypeByCatalog->id, NULL, NULL);
$data[] = array('eTypeByCatalog' => $eTypeByCatalog, 'eCatalog' => $eCatalogos);
}
}
$oBus->isSuccess(TRUE);
$oBus->data($data);
return $oBus;
}
public static function loadLogo($id_company = NULL)
{
$oBus = new Response_Business();
$uri = '';
try {
if (empty($id_company)) {
throw new Exception('Logo por defecto');
}
$uri = "resources/uploads/company/{$id_company}/logo.png";
if (!file_exists(BASEPATH . '../' . $uri)) {
throw new Exception('Logo por defecto');
}
$oBus->isSuccess(TRUE);
} catch (Exception $e) {
$uri = "resources/img/nologo.png";
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
$oBus->data(array('uri' => $uri));
return $oBus;
}
public static function listBinnacle($txt_filter, $limit, $offset, $arrTxtAction, $dateBegin, $dateEnd)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mUserLog User_Log_Model */
$mUserLog =& $MY->mUserLog;
$eUsers = array();
$eUserLogs = array();
$count = 0;
try {
$filter = new filterUserLog();
$filter->limit = $limit;
$filter->offset = $offset;
$filter->text = $txt_filter;
$filter->action = $arrTxtAction;
$filter->date_begin = $dateBegin;
$filter->date_end = $dateEnd;
$mUserLog->filter($filter, $eUserLogs, $eUsers, $count);
$oBus->isSuccess(TRUE);
} catch (Exception $ex) {
$oBus->isSuccess(FALSE);
$oBus->message($ex->getMessage());
}
$oBus->data(array('eUserLogs' => $eUserLogs, 'eUsers' => $eUsers, 'count' => $count));
return $oBus;
}
public static function sendEmail($data)
{
$MY =& MY_Controller::get_instance();
$config_email = Helper_Config::getEmail();
$MY->load->library('email', $config_email);
$oBus = new Response_Business();
$smtp_user = $config_email['smtp_user'];
$messege = "De: " . $data['name'] . " <br>";
$messege .= "Email:" . $data['email'] . " <br>";
$messege .= "Detalle:" . $data['message'] . " <br>";
try {
$MY->email->from($smtp_user, $data['name']);
$MY->email->to('*****@*****.**');
$MY->email->subject($data['subject']);
$MY->email->message($messege);
if (!$MY->email->send()) {
throw new Exception($MY->email->print_debugger());
}
$oBus->isSuccess(TRUE);
$oBus->message('Email enviado!');
} catch (Exception $ex) {
$oBus->isSuccess(FALSE);
$oBus->message($ex->getMessage());
}
return $oBus;
}
public static function saveAcount(ePerson $ePerson, eUser $eUser, eUserProfile $eUserProfile, $eUserProfile_CompanyBranches)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mPerson Person_Model */
$mPerson =& $MY->mPerson;
/* @var $mUser User_Model */
$mUser =& $MY->mUser;
/* @var $mUserProfile User_Profile_Model */
$mUserProfile =& $MY->mUserProfile;
/* @var $mUserProfileCompanyBranch User_Profile_Company_Branch_Model */
$mUserProfileCompanyBranch =& $MY->mUserProfileCompanyBranch;
$oTransaction = new MY_Business();
$oTransaction->begin();
try {
if (!Helper_App_Session::isAdminProfile() || !Helper_App_Session::isSuperAdminProfile()) {
if (Business_App_Person::isValidDocument($ePerson->document)) {
throw new Exception('Documento Invalido, No permitido');
}
}
$ePersonT = $mPerson->loadByDocument($ePerson->document, $ePerson->id);
if (!$ePersonT->isEmpty()) {
throw new Exception('Persona Existente');
}
$eUserT = $mUser->load($eUser->username, 'username', $eUser->id);
if (!$eUserT->isEmpty()) {
throw new Exception('Usuario Existente');
}
$mPerson->save($ePerson);
$mUser->save($eUser);
$eUserProfileT = $mUserProfile->loadArray(array('id_user' => $eUser->id, 'id_profile' => $eUserProfile->id_profile));
$eUserProfile->id_user = $eUser->id;
$eUserProfile->id = $eUserProfileT->id;
$mUserProfile->save($eUserProfile);
$mUserProfileCompanyBranch->deleteByUserProfile($eUserProfile->id);
if (!empty($eUserProfile_CompanyBranches)) {
/* @var $eUserProfileCompanyBranch eUserProfileCompanyBranch */
foreach ($eUserProfile_CompanyBranches as $eUserProfileCompanyBranch) {
$eUserProfileCompanyBranch->id_user_profile = $eUserProfile->id;
$mUserProfileCompanyBranch->save($eUserProfileCompanyBranch);
}
}
$oTransaction->commit();
$oBus->isSuccess(TRUE);
$oBus->message("Guardado exitosamente");
} catch (Exception $e) {
$oTransaction->rollback();
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
return $oBus;
}
public static function savePermission(ePermission $ePermission)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mPermission Permission_Model */
$mPermission =& $MY->mPermission;
$oTransaction = new MY_Business();
$oTransaction->begin();
try {
$mPermission->save($ePermission);
$oTransaction->commit();
$oBus->isSuccess(TRUE);
$oBus->message("Guardado exitosamente");
} catch (Exception $e) {
$oTransaction->rollback();
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
return $oBus;
}
public static function savePerson(ePerson $ePerson)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mPerson Person_Model */
$mPerson =& $MY->mPerson;
$oTransaction = new MY_Business();
$oTransaction->begin();
try {
$ePersonT = $mPerson->load($ePerson->id);
if (!Helper_App_Session::isAdminProfile() || !Helper_App_Session::isSuperAdminProfile()) {
if (self::isValidDocument($ePerson->document)) {
throw new Exception('Documento Invalido: ' + $ePerson->document);
}
if ($ePersonT->tipo_documento != $ePerson->tipo_documento) {
throw new Exception('No tiene permisos para editar el tipo de documento');
}
if ($ePersonT->document != $ePerson->document) {
throw new Exception('No tiene permisos para editar el documento');
}
}
$ePersonDocument = $mPerson->loadByDocument($ePerson->document, $ePerson->id);
if (!$ePersonDocument->isEmpty()) {
throw new Exception('Documento Existente: ' + $ePerson->document);
}
$mPerson->save($ePerson);
$oBus->isSuccess(TRUE);
$oBus->message("Guardado exitosamente");
$oTransaction->commit();
} catch (Exception $e) {
$oTransaction->rollback();
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
return $oBus;
}
public static function listByUserProfile($id_user, $id_profile)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mCompanyBranch Company_Branch_Model */
$mCompanyBranch =& $MY->mCompanyBranch;
$eCompanyBranchs = $mCompanyBranch->listByUserProfile($id_user, $id_profile);
$oBus->isSuccess(!empty($eCompanyBranchs));
$oBus->message(empty($eCompanyBranchs) ? 'Usuario no tiene asociado ninguna Sede.' : '');
$oBus->data(array('eCompanyBranchs' => $eCompanyBranchs));
return $oBus;
}
public static function saveOrderModules($eModules)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mModule Module_Model */
$mModule =& $MY->mModule;
$oTransaction = new MY_Business();
$oTransaction->begin();
try {
if (!empty($eModules)) {
foreach ($eModules as $eModule) {
$mModule->saveOrder($eModule);
}
}
$oTransaction->commit();
$oBus->isSuccess(TRUE);
$oBus->message("Guardado exitosamente");
} catch (Exception $e) {
$oTransaction->rollback();
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
return $oBus;
}
public static function loadResumenCamera($dateEnd, $dateBegin)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mT_Analytics T_Analytics_Model */
$mT_Analytics = $MY->mT_Analytics;
/* @var $mDateTime_Generate Datetime_Generate_Model */
$mDateTime_Generate =& $MY->mDateTime_Generate;
/* @var $mResumen_Camera Resumen_Camera_Model */
$mResumen_Camera = $MY->mResumen_Camera;
$MY->db->trans_begin();
try {
$eDatetimeGenerate = $mDateTime_Generate->load(Helper_Config::getFTTProcessResumenCamera(), 'process_name');
if (!$eDatetimeGenerate->isEmpty()) {
$dateBegin = $eDatetimeGenerate->update_datetime;
}
$eDatetimeGenerate->process_name = Helper_Config::getFTTProcessResumenCamera();
$eDatetimeGenerate->update_datetime = $dateEnd;
$mDateTime_Generate->save($eDatetimeGenerate);
$result = $mT_Analytics->loadResumenCamera($dateEnd, $dateBegin);
$eResumenCameras = array();
if (!empty($result)) {
foreach ($result as $row) {
$eResumenCamera = new eResumenCamera(FALSE);
$eResumenCamera->parseRow($row, '', true);
$eResumenCameras[] = $eResumenCamera;
}
}
if (!empty($eResumenCameras)) {
foreach ($eResumenCameras as $eResumenCamera) {
$mResumen_Camera->save($eResumenCamera);
}
}
$oBus->isSuccess(TRUE);
$oBus->message('Guardado exitosamente: Resumen de Camera');
$MY->db->trans_commit();
} catch (Exception $ex) {
$oBus->isSuccess(FALSE);
$oBus->message($ex->getMessage());
$MY->db->trans_rollback();
}
return $oBus;
}
public static function listRolesAndModulesAByRol($id_rol)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mRolModule Rol_Module_Model */
$mRolModule =& $MY->mRolModule;
$eRolesModules = array();
try {
$eRolesModules = $mRolModule->listRolesAndModulesByRol($id_rol);
$oBus->isSuccess(TRUE);
} catch (Exception $ex) {
$oBus->isSuccess(FALSE);
$oBus->message($ex->getMessage());
}
$oBus->data(array('eRolesModules' => $eRolesModules));
return $oBus;
}
public static function loadUserProfile($id_user)
{
$oBus = new Response_Business();
$MY =& MY_Controller::get_instance();
/* @var $mUserProfile User_Profile_Model */
$mUserProfile =& $MY->mUserProfile;
$eUserProfile = new eUserProfile();
try {
$eUserProfile = $mUserProfile->load($id_user, 'id_user');
$oBus->isSuccess(TRUE);
} catch (Exception $e) {
$oBus->isSuccess(FALSE);
$oBus->message($e->getMessage());
}
$oBus->data(array('eUserProfile' => $eUserProfile));
return $oBus;
}
