/**
* reenviar tarea de officetrack
* POST /api/reenviarot
* @param int gestion_id
* @return Response
*/
public function postReenviarot()
{
if (Input::has('gestion_id')) {
Input::replace(array('buscar' => Input::get('gestion_id'), 'tipo' => 'g.id'));
$result = Gestion::getCargar();
$resultDos = array();
if ($result['rst'] == '1') {
$datos = $result['datos'][0];
$resultDos['fh_agenda'] = $datos->fh_agenda;
$resultDos['codactu'] = trim($datos->codactu . ' ');
$resultDos['fecha_registro'] = trim($datos->fecha_registro . ' ');
$resultDos['nombre_cliente'] = trim($datos->nombre_cliente . ' ');
$resultDos['act_codmotivo_req_catv'] = trim($datos->codmotivo_req_catv . ' ');
$resultDos['orden_trabajo'] = trim($datos->orden_trabajo . ' ');
$resultDos['fftt'] = trim($datos->fftt . ' ');
$resultDos['dir_terminal'] = trim($datos->dir_terminal . ' ');
$resultDos['inscripcion'] = trim($datos->inscripcion . ' ');
$resultDos['mdf'] = trim($datos->mdf . ' ');
$resultDos['segmento'] = trim($datos->segmento . ' ');
$resultDos['clase_servicio_catv'] = trim($datos->clase_servicio_catv . ' ');
$resultDos['total_averias'] = trim($datos->total_averias . ' ');
$resultDos['zonal'] = trim($datos->zonal . ' ');
$resultDos['llamadastec15dias'] = trim($datos->llamadastec15dias . ' ');
$resultDos['quiebre'] = trim($datos->quiebre . ' ');
$resultDos['lejano'] = trim($datos->lejano . ' ');
$resultDos['distrito'] = trim($datos->distrito . ' ');
$resultDos['averia_m1'] = trim($datos->averia_m1 . ' ');
$resultDos['telefono_codclientecms'] = trim($datos->telefono_codclientecms . ' ');
$resultDos['area2'] = trim($datos->area2 . ' ');
$resultDos['eecc_final'] = trim($datos->eecc_zona . ' ');
$resultDos['gestion_id'] = trim($datos->id . ' ');
$resultDos['estado'] = trim($datos->estado . ' ');
$resultDos['velocidad'] = trim($datos->veloc_adsl . ' ');
$resultDos['cr_observacion'] = trim($datos->observacion . ' ');
//$resultDos['reenviar'] =trim( $datos->reenviar.' ');
$resultDos['actividad'] = trim($datos->actividad . ' ');
$resultDos['tecnico_id'] = trim($datos->tecnico_id . ' ');
$resultDos['coordinado2'] = trim($datos->coordinado . ' ');
$resultDos['direccion_instalacion'] = trim($datos->direccion_instalacion . ' ');
$resultTres = Helpers::ruta('officetrack/procesarot', 'POST', $resultDos, false);
return Response::json($resultTres);
} else {
return Response::json($result);
}
}
}
public function postBandejaexcel()
{
$gestion = Gestion::getCargar();
if (Input::has('imagen')) {
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setCreator("Jorge Salcedo")->setLastModifiedBy("Jorge Salcedo")->setTitle("Office 2007 XLSX Test Document")->setSubject("Office 2007 XLSX Test Document")->setDescription("Reporte de Problemas")->setKeywords("office 2007 openxml php")->setCategory("Test result file");
$az = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH', 'AI', 'AJ', 'AK', 'AL', 'AM', 'AN', 'AO', 'AP', 'AQ', 'AR', 'AS', 'AT', 'AU', 'AV', 'AW', 'AX', 'AY', 'AZ', 'BA', 'BB', 'BC', 'BD', 'BE', 'BF', 'BG', 'BH', 'BI', 'BJ', 'BK', 'BL', 'BM', 'BN', 'BO', 'BP', 'BQ', 'BR', 'BS', 'BT', 'BU', 'BV', 'BW', 'BX', 'BY', 'BZ', 'CA', 'CB', 'CC', 'CD', 'CE', 'CF', 'CG', 'CH', 'CI', 'CJ', 'CK', 'CL', 'CM', 'CN', 'CO', 'CP', 'CQ', 'CR', 'CS', 'CT', 'CU', 'CV', 'CW', 'CX', 'CY', 'CZ', 'DA', 'DB', 'DC', 'DD', 'DE', 'DF', 'DG', 'DH', 'DI', 'DJ', 'DK', 'DL', 'DM', 'DN', 'DO', 'DP', 'DQ', 'DR', 'DS', 'DT', 'DU', 'DV', 'DW', 'DX', 'DY', 'DZ');
$objPHPExcel->getDefaultStyle()->getFont()->setName('Bookman Old Style');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(8);
$valorinicial = 1;
$azpos = 0;
foreach ($gestion['datos'] as $data) {
//Encabezado
if ($valorinicial == 1) {
foreach ($data as $key => $val) {
$objPHPExcel->getActiveSheet()->setCellValue($az[$azpos] . $valorinicial, $key);
$azpos++;
}
}
$valorinicial++;
$azpos = 0;
//Datos
foreach ($data as $val) {
$val = str_replace(array("\r\n", "\n", "\n\n", "\t", "\r"), array("", "", "", "", ""), $val);
$objPHPExcel->getActiveSheet()->setCellValue($az[$azpos] . $valorinicial, $val);
$azpos++;
}
}
$objPHPExcel->getActiveSheet()->setTitle('PSI');
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->save('reporte/u743/PSI_' . date("Y-m-d_H-i-s") . '.xlsx');
$zipfile = new Zipfile();
$zipfile->add_dir("reporte/");
$ruta = "reporte/u743/";
$zipfile->carpeta = array();
$zipfile->archivo = array();
$zipfile->listar_directorios_ruta($ruta);
$carpeta = $zipfile->carpeta;
$archivo = $zipfile->archivo;
for ($i = 0; $i < count($carpeta); $i++) {
$zipfile->add_dir(str_replace("reporte/u743/", "reporte/", $carpeta[$i]));
//$zipfile->add_dir( $carpeta[$i] );
}
for ($i = 0; $i < count($archivo); $i++) {
$zipfile->add_file($archivo[$i], str_replace("reporte/u743/", "reporte/", $archivo[$i]));
//$zipfile->add_file($archivo[$i],$archivo[$i] );
}
header("Content-type: application/octet-stream");
header("Content-disposition: attachment; filename=bandeja.zip");
echo $zipfile->file();
exit;
} else {
$filename = Helpers::convert_to_file_excel('Bandeja_' . date("Ymd_His"));
header('Content-Type: application/octet-stream; charset=utf-8;');
header('Content-Disposition: attachment; filename=' . $filename);
header('Expires: 0');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header("Content-Transfer-Encoding: binary");
header('Pragma: public');
$n = 1;
foreach ($gestion['datos'] as $data) {
//Encabezado
if ($n == 1) {
foreach ($data as $key => $val) {
echo $key . "\t";
}
echo "\r\n";
}
//Datos
foreach ($data as $val) {
$val = str_replace(array("\r\n", "\n", "\n\n", "\t", "\r"), array("", "", "", "", ""), $val);
echo $val . "\t";
}
echo "\r\n";
$n++;
}
}
//
}
public function norealizadoOfsc()
{
$save["aid"] = $activityId;
$actu = \Gestion::getCargar($codactu);
$actuObj = $actu["datos"][0];
$actuArray = (array) $actuObj;
$actuArray['estado_agendamiento'] = "3-0";
$actuArray['gestion_id'] = $actuObj->id;
$actuArray['estado'] = 5;
$actuArray['motivo'] = 4;
$actuArray['submotivo'] = 6;
unset($actuArray["fecha_agenda"]);
unset($actuArray["horario_id"]);
unset($actuArray["dia_id"]);
unset($actuArray["tecnico"]);
unset($actuArray["tecnico_id"]);
unset($actuArray["celula_id"]);
Input::replace($actuArray);
$save = $this->_gestionMovimientoController->postRegistrar();
$datos = array();
$datos['aid'] = $activityId;
$datos['envio_ofsc'] = 4;
$datos['gestion_id'] = $save['gestion_id'];
$datos['gestion_movimiento_id'] = $save['gestion_movimiento_id'];
$datos['estado_ofsc_id'] = 4;
GestionMovimiento::OfscUpdate($datos);
}
public function postEnvioofsc()
{
$datos = array();
$datos['hf'] = explode("||", Input::get('hf'));
$datos['fecha'] = $datos['hf'][0];
$datos['bucket'] = $datos['hf'][1];
$datos['slot'] = $datos['hf'][2];
//time slot
$datos['horas'] = explode("-", $datos['hf'][3]);
$datos['empresa_id'] = Input::get('empresa_id');
$datos['codactu'] = Input::get('codactu');
$sla = false;
$slaInicio = "0000-00-00 00:00";
//retorno de transaccion
$save = array("rst" => 2, "msj" => "Sin reultados.", "error" => "", "gestion_id" => 0);
$inbound = new Inbound();
$gestionId = "";
$codactu = $datos['codactu'];
//"35268199"; //
$date = $datos['fecha'];
//date("Y-m-d"); //
$bucket = $datos['bucket'];
//"BK_PRUEBAS_TOA";
$tini = trim($datos['horas'][0]);
//"09:00"
$tend = trim($datos['horas'][1]);
//"13:00"
$tobooking = date("Y-m-d H:i");
$slot = $datos['slot'];
//"AM"
$cuadrante = "Something";
$techTp = "NULL";
$techBb = "NULL";
$techTv = "NULL";
$wzKey = "";
$wtLabel = "";
$wType = "";
$accTech = "COAXIAL";
$businessType = "";
$phone = array(0 => "", 1 => "");
//Datos de la actuacion
$actu = \Gestion::getCargar($codactu);
//Existe la actuacion
if (isset($actu["datos"][0])) {
$actuObj = $actu["datos"][0];
$actuArray = (array) $actuObj;
$actuArray['noajax'] = "ok";
//Motivo/Submotivo
$actuArray['gestion_id'] = $actuObj->id;
$actuArray['motivo'] = 1;
$actuArray['submotivo'] = 1;
$actuArray['estado'] = 2;
//GestionID
$gestionId = $actuObj->id;
//Tipo de actividad: tabla "actividaes_tipos"
$actTipo = DB::table('actividades_tipos')->select('nombre', 'label', 'sla', 'duracion')->where('id', '=', $actuArray['actividad_tipo_id'])->first();
//Duracion en minutos
$duration = $actTipo->duracion;
//Quiebre grupo
$quiebreGrupo = DB::table('quiebre_grupos')->select('nombre')->where('id', '=', $actuArray['quiebre_grupo_id'])->first();
//Negocio por texto
if (strpos($actuArray['tipo_averia'], "catv") > 0) {
$businessType = "CATV";
}
if (strpos($actuArray['tipo_averia'], "adsl") > 0) {
$businessType = "ADSL";
}
if (strpos($actuArray['tipo_averia'], "bas") > 0) {
$businessType = "BASICA";
}
$wtLabel = $actTipo->label;
$wType = $actTipo->nombre;
//Telefonos de contacto
$phoneArray = explode("|", $actuArray['fonos_contacto']);
if (isset($phoneArray[0])) {
$phone[0] = $phoneArray[0];
}
if (isset($phoneArray[1])) {
$phone[1] = $phoneArray[1];
}
//Si no hay telefono de contacto
if (strlen(trim($actuArray['fonos_contacto'])) < 6) {
$phone = array("0000000", "0000000");
}
//Datos XY Web
$actuArray['x'] = $actuArray['coord_x'];
$actuArray['y'] = $actuArray['coord_y'];
//Facilidades técnicas
$ffttController = new \FfttController();
$val = new stdClass();
$val->fftt = $actuArray['fftt'];
$val->tipoactu = $actuArray['tipo_averia'];
$ffttArray = $ffttController->getExplodefftt($val);
if ($ffttArray["tipo"] == 'catv') {
$wzKey = $ffttArray["nodo"] . "_" . $ffttArray["troba"];
} else {
$wzKey = $ffttArray["mdf"] . "_" . $ffttArray["armario"];
}
//Parche: datos no concuerdan -> enumeration
if ($actuArray['segmento'] == "NO-VIP") {
$actuArray['segmento'] = "N";
}
//Homologacion de campos
$dataOfsc = array("bucket" => $datos['bucket'], "actividad" => strtolower($actuObj->actividad), "date" => $date, "type" => "update_activity", "external_id" => $bucket, "start_time" => $tini, "end_time" => $tend, "appt_number" => $actuArray['codactu'], "customer_number" => $actuArray['inscripcion'], "worktype_label" => $wtLabel, "time_slot" => $slot, "time_of_booking" => $tobooking, "duration" => $duration, "name" => $actuArray['nombre_cliente'], "phone" => $phone[0], "email" => "", "cell" => $phone[1], "address" => $actuArray['direccion_instalacion'], "city" => "Lima", "state" => "Lima", "zip" => "LIMA 05", "language" => "1", "reminder_time" => "15", "time_zone" => "19", "coordx" => $actuArray['coord_x'], "coordy" => $actuArray['coord_y'], "XA_CREATION_DATE" => $tobooking, "XA_SOURCE_SYSTEM" => "PSI", "XA_CUSTOMER_SEGMENT" => $actuArray['segmento'], "XA_CUSTOMER_TYPE" => "", "XA_CONTACT_NAME" => "", "XA_CONTACT_PHONE_NUMBER_2" => "", "XA_CONTACT_PHONE_NUMBER_3" => "", "XA_CONTACT_PHONE_NUMBER_4" => "", "XA_CITY_CODE" => "", "XA_DISTRICT_CODE" => $actuArray['codigo_distrito'], "XA_DISTRICT_NAME" => $actuArray['distrito'], "XA_ZONE" => $actuArray['zonal'], "XA_QUADRANT" => $cuadrante, "XA_WORK_ZONE_KEY" => $wzKey, "XA_RURAL" => "", "XA_RED_ZONE" => "", "XA_WORK_TYPE" => $wType, "XA_APPOINTMENT_SCHEDULER" => "CLI", "XA_USER" => "", "XA_REQUIREMENT_NUMBER" => $actuArray['codactu'], "XA_NUMBER_SERVICE_ORDER" => $actuArray['orden_trabajo'], "XA_CHANNEL_ORIGIN" => "", "XA_SALES_POINT_CODE" => "", "XA_SALES_POINT_DESCRIPTION" => "", "XA_COMMERCIAL_VALIDATION" => "", "XA_TECHNICAL_VALIDATION" => "", "XA_WEB_UNIFICADA" => "", "XA_ORDER_AREA" => "", "XA_COMMERCIAL_PACKET" => "", "XA_COMPANY_NAME" => $actuArray['empresa'], "XA_GRUPO_QUIEBRE" => $quiebreGrupo->nombre, "XA_QUIEBRES" => $actuArray['quiebre'], "XA_BUSINESS_TYPE" => $businessType, "XA_PRODUCTS_SERVICES" => "", "XA_CURRENT_PRODUCTS_SERVICES" => "", "XA_EQUIPMENT" => "", "XA_NOTE" => $actuArray['observacion'], "XA_TELEPHONE_TECHNOLOGY" => $techTp, "XA_BROADBAND_TECHNOLOGY" => $techBb, "XA_TV_TECHNOLOGY" => $techTv, "XA_ACCESS_TECHNOLOGY" => $accTech, "XA_HFC_ZONE" => "", "XA_HFC_NODE" => "", "XA_HFC_TROBA" => "", "XA_HFC_AMPLIFIER" => "", "XA_HFC_TAP" => "", "XA_HFC_BORNE" => "", "XA_REQUIREMENT_TYPE" => "", "XA_REQUIREMENT_REASON" => "", "XA_CATV_SERVICE_CLASS" => "", "XA_MDF" => $actuArray['mdf'], "XA_CABLE" => "", "XA_CABINET" => "", "XA_BOX" => "", "XA_TERMINAL_ADDRESS" => "", "XA_TERMINAL_LINKHTTP" => "", "XA_ADSLSTB_PREFFIX" => "NULL", "XA_ADSLSTB_MOVEMENT" => "NULL", "XA_ADSL_SPEED" => "", "XA_ADSLSTB_SERVICE_TYPE" => "", "XA_PENDING_EXTERNAL_ACTION" => "", "XA_SMS_1" => $actuArray['sms1'], "XA_DIAGNOSIS" => "", "XA_TOTAL_REPAIRS" => $actuArray['total_averias']);
//Envio por SLA
if (Input::get('agdsla') == 'sla' and Input::get('slaini') != '') {
$sla = true;
$slaInicio = strtotime(Input::get('slaini'));
$slaDay = $actTipo->sla * 3600;
$slaFin = $slaInicio + $slaDay;
$dataOfsc["sla_window_start"] = date("Y-m-d H:i", $slaInicio);
$dataOfsc["sla_window_end"] = date("Y-m-d H:i", $slaFin);
$dataOfsc["date"] = date("Y-m-d", $slaInicio);
}
//Campos adicionales para averia
if (strtolower($actuObj->actividad) == 'averia') {
$dataOfsc["XA_DIAGNOSIS"] = "SB_01";
}
/**
* Guardar en tablas de gestion
* - gestiones
* - gestiones_detalles
* - gestiones_movimientos
* - ultimos_movimientos
*/
$actuArray['fecha_agenda'] = $date;
$horario = Horario::where('horario', '=', $slot)->first();
if ($horario != NULL and $horario != '') {
$actuArray['horario_id'] = $horario->id;
$actuArray['dia_id'] = date("N", strtotime($date));
}
$actuArray['estado_agendamiento'] = "1-1";
unset($actuArray["tecnico"]);
unset($actuArray["tecnico_id"]);
unset($actuArray["celula_id"]);
Input::replace($actuArray);
$save = $this->_gestionMovimientoController->postRegistrar();
unset($actuArray["fecha_agenda"]);
unset($actuArray["horario_id"]);
unset($actuArray["dia_id"]);
$actuArray['estado_agendamiento'] = "3-0";
$actuArray['motivo'] = 2;
$actuArray['submotivo'] = 18;
$actuArray['estado'] = 7;
if ($save["rst"] == 1) {
//Crear actividad en OFSC
/*if ( $dataOfsc['date']==0 ) {
$dataOfsc['date']=date("Y-m-d",strtotime(Input::get('slaini')) );
}*/
$response = $inbound->createActivity($dataOfsc, $sla);
$report = $response->data->data->commands->command->appointment->report;
$resultBool = true;
/**
* $report->message:
*
* El mensaje de respuesta puede ser un arreglo
* o un único mensaje.
* Se valida la respuesta para cada mensaje recibido.
*/
if (is_array($report->message)) {
foreach ($report->message as $val) {
if ($val->result == 'warning') {
$save["error"][] = $val->description;
}
if ($val->result == 'error') {
$save["error"][] = $val->description;
}
}
} else {
if ($report->message->result == 'error') {
$resultBool = false;
$save["error"][] = $report->message->description;
}
}
//$result = $report->message->result;
//Retorno OK
if ($resultBool) {
//Appointment id
$aid = $response->data->data->commands->command->appointment->aid;
$datosofsc = array();
$datosofsc['aid'] = $aid;
$datosofsc['gestion_id'] = $save['gestion_id'];
$datosofsc['envio_ofsc'] = 2;
if ($sla == false) {
$datosofsc['envio_ofsc'] = 1;
}
$datosofsc['gestion_movimiento_id'] = $save['gestion_movimiento_id'];
GestionMovimiento::ActOfscAid($datosofsc);
$save["msj"] = "Registro y envío a OFSC correcto.";
$save["aid"] = $aid;
}
//Retorno ERROR
if (!$resultBool) {
$errArray['type'] = $report->message->type;
$errArray['code'] = $report->message->code;
$errArray['desc'] = $report->message->description;
Input::replace($actuArray);
$save = $this->_gestionMovimientoController->postRegistrar();
$save["rst"] = 2;
$save["msj"] = "No se pudo enviar a OFSC. " . $report->message->description;
}
}
}
return json_encode($save);
}
public function postCargar()
{
if (Request::ajax()) {
return Response::json(Gestion::getCargar());
}
}
