<?php $combo = new OptionComboSimple(); $pr['campania'] = Utilidades::clear_input($in['campania']); $estados = $modelo->getEstadoActivas($pr); $estados_reales = $modelo->getEstadoRealActivas($in); ?> <table id="<?php echo $prefix . 'tabla'; ?> "> <thead> <!-- <tr> <td>0</td> <td>1</td> <td>2</td> <td>3</td> <td>4</td> <td>5</td> <td>6</td> <td>7</td> <td>8</td> <td>9</td> <td>10</td> <td>11</td> <td>12</td> <td>13</td> <td>14</td> <td>15</td>
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../modelo/ModeloVenta.php"; session_start(); $venta = new ModeloVenta(); // -------------------------------------------------------- INPUT $in['campania'] = Utilidades::clear_input(Utilidades::sanear_string($_POST['campania'])); $in['venta_id'] = Utilidades::clear_input_id($_POST['venta_id']); $in['fecha'] = date('Y-m-d H:i:s'); $in['usuario'] = $_SESSION['user_id']; $dato = $_POST; // -------------------------------------------------------- Data $campos = $venta->getcampos($in); if ($in['venta_id'] != '0') { $in['fields']['id'] = ''; foreach ($campos as $r) { $in['fields'][$r['nombre']] = ''; } $old = $venta->getUnDato($in); } $id = $venta->setVenta($in); $sql_campos = 'id'; // insert $sql_valores = $id; // insert $sql_set = ''; // update // lo siguiente es si existe "estado_real" para cambiar
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../../../lib/html/tabla.php"; include "../../../modelo/ModeloReporte01.php"; session_start(); $venta = new ModeloVenta(); // -------------------------------------------------------- INPUT $in['anio-mes-ini'] = Utilidades::clear_input($_POST['anio-mes-ini']); $in['dia-ini'] = Utilidades::clear_input_id((int) $_POST['dia-ini']); $in['anio-mes-end'] = Utilidades::clear_input($_POST['anio-mes-end']); $in['dia-end'] = Utilidades::clear_input_id((int) $_POST['dia-end']); $in['campania_id'] = Utilidades::clear_input($_POST['campania_id']); $in['supervisor_id'] = Utilidades::clear_input_id((int) $_POST['supervisor_id']); $in['lineas'] = Utilidades::clear_input($_SESSION['lineas']); // -------------------------------------------------------- Data $ou = $venta->getSupervisorByFechas($in); if ($ou) { $combo = new OptionComboSimple(); $combo->set_option($in['supervisor_id']); $combo->set_format(array('supervisor_id', 'supervisor')); $combo->imprimir($ou); } // -------------------------------------------------------- TEST // Utilidades::printr($in); // Utilidades::printr($ou); // -------------------------------------------------------- OUT
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../../../lib/html/tabla.php"; include "../../../modelo/ModeloVenta.php"; session_start(); $venta = new ModeloVenta(); // -------------------------------------------------------- INPUT $in['campania'] = Utilidades::clear_input($_POST['campania']); // -------------------------------------------------------- Data $ou = $venta->getEstadoRealActivas($in); $combo = new OptionComboSimple(); // $combo->set_option(0); $combo->set_format(array('id', 'nombre')); $combo->imprimir($ou); // -------------------------------------------------------- TEST // Utilidades::printr($in); // Utilidades::printr($campos); // Utilidades::printr($dato); // -------------------------------------------------------- OUT
} function c1($num, $i) { return c0($num) . $i; } function c2($num1, $num2, $i1, $i2) { return c0($num1) . $i1 . ':' . c0($num2) . $i2; } $objPHPExcel = new PHPExcel(); $objPHPExcel->getProperties()->setCreator("Claudio Rodriguez Ore"); session_start(); $venta = new ModeloVenta(); // -------------------------------------------------------- INPUT $in['ini'] = Utilidades::clear_input($_GET['ini']); $in['end'] = Utilidades::clear_input($_GET['end']); // -------------------------------------------------------- Data $fields = array('id' => '', 'cliente' => '', 'contacto_fijo' => '', 'contacto_movil' => '', 'fecha_entrega' => '', 'observacion_entrega' => '', 'distrito' => '', 'direccion' => '', 'provincia' => '', 'departamento' => '', 'referencia' => '', 'fachada' => '', 'producto' => '', 'cantidad' => '', 'color' => '', 'tipo_pago' => '', 'precio' => '', 'costo_envio' => '', 'obsequio' => '', 'estado_real' => '', 'estado_observacion' => ''); $sql = ' SELECT d.id , d.cliente_nombre, d.cliente_contacto_fijo, d.cliente_contacto_movil , d.fecha_entrega, d.fecha_entrega_observacion , d01.nombre dis, d.direccion , d02.nombre, d03.nombre, d.referencia_lugar, d.referencia_fachada , d04.nombre, d.producto_cantidad, d05.nombre , d08.nombre, d.precio, d.costo_envio, d06.nombre , d07.nombre, d.estado_observacion FROM venta_campania_003 d JOIN venta v ON v.id = d.id LEFT JOIN venta_ubigeoPeruDistrito d01 ON d01.id = d.ubigeoPeruDistrito LEFT JOIN venta_ubigeoPeruProvincia d02 ON d02.id = d.ubigeoPeruProvincia
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../modelo/ModeloApunte.php"; session_start(); $prefix = 'apuntes_listado_'; $modelo = new ModeloApunte(); // -------------------------------------------------------- INPUT $in['search_ini'] = Utilidades::clear_input($_POST['search_ini']); $in['search_end'] = Utilidades::clear_input($_POST['search_end']); $in['search_pendiente'] = (int) Utilidades::clear_input($_POST['search_pendiente']); $in['pagina'] = Utilidades::clear_input($_POST['pagina']); $in['items'] = $modelo->apuntes_get_pagina(); $in['user_id'] = Utilidades::clear_input($_SESSION['user_id']); // --------------------------------------------------------- DATA $ou = $modelo->apuntes_listado($in); // --------------------------------------------------------- TEST // Utilidades::printr($_POST); // Utilidades::printr($ou); // ------------------------------------------------------- OUTPUT if (isset($ou)) { foreach ($ou as $row) { $pendiente = 'pendiente-no'; if ($row['pendiente'] == '1') { $pendiente = 'pendiente-si'; } if ('' == trim($row['telefono'])) { $row['telefono'] = 'Vacio'; }
} // ------------------------------------------ TOTAL $total_1 = count($fibra['residencial']['2P']['300MB']) + count($fibra['residencial']['2P']['120MB']) + count($fibra['residencial']['2P']['50MB']) + count($fibra['residencial']['3P']['300MB']) + count($fibra['residencial']['3P']['120MB']) + count($fibra['residencial']['3P']['50MB']); $total_2 = count($movil['residencial']['S']) + count($movil['residencial']['M']) + count($movil['residencial']['L']); $total_3 = count($fibra['autonomo']['fibra']['300MB']['Alta Nueva']) + count($fibra['autonomo']['fibra']['300MB']['Portabilidad']) + count($fibra['autonomo']['fibra']['120MB']['Alta Nueva']) + count($fibra['autonomo']['fibra']['120MB']['Portabilidad']) + count($fibra['autonomo']['fibra']['50MB']['Alta Nueva']) + count($fibra['autonomo']['fibra']['50MB']['Portabilidad']) + count($fibra['autonomo']['adsl']['Alta Nueva']) + count($fibra['autonomo']['adsl']['Portabilidad']); $total_4 = count($movil['autonomo']['linea 1']['S']) + count($movil['autonomo']['linea 1']['M']) + count($movil['autonomo']['linea 1']['L']) + count($movil['autonomo']['linea 2']['S']) + count($movil['autonomo']['linea 2']['M']) + count($movil['autonomo']['linea 2']['L']); $total_5 = $total_1 + $total_3; $total_6 = $total_2 + $total_4; $objPHPExcel->getActiveSheet()->getStyle(c2(1, 34, $i, $i + 3))->applyFromArray($border_style); $objPHPExcel->setActiveSheetIndex($index)->setCellValue(c1(1, $i), $titulo)->mergeCells(c2(1, 1, $i, $i + 3))->setCellValue(c1(2, $i), 'Fibra 300MB')->setCellValue(c1(3, $i), count($fibra['residencial']['2P']['300MB']))->setCellValue(c1(4, $i), '')->setCellValue(c1(5, $i), count($fibra['residencial']['3P']['300MB']))->setCellValue(c1(6, $i), '')->setCellValue(c1(7, $i), $total_1)->mergeCells(c2(7, 7, $i, $i + 3))->setCellValue(c1(8, $i), count($movil['residencial']['S']))->mergeCells(c2(8, 8, $i, $i + 3))->setCellValue(c1(9, $i), '')->mergeCells(c2(9, 9, $i, $i + 3))->setCellValue(c1(10, $i), count($movil['residencial']['M']))->mergeCells(c2(10, 10, $i, $i + 3))->setCellValue(c1(11, $i), '')->mergeCells(c2(11, 11, $i, $i + 3))->setCellValue(c1(12, $i), count($movil['residencial']['L']))->mergeCells(c2(12, 12, $i, $i + 3))->setCellValue(c1(13, $i), '')->mergeCells(c2(13, 13, $i, $i + 3))->setCellValue(c1(14, $i), $total_2)->mergeCells(c2(14, 14, $i, $i + 3))->setCellValue(c1(15, $i), count($fibra['autonomo']['fibra']['300MB']['Alta Nueva']))->setCellValue(c1(16, $i), '')->setCellValue(c1(17, $i), count($fibra['autonomo']['fibra']['300MB']['Portabilidad']))->setCellValue(c1(18, $i), '')->setCellValue(c1(19, $i), $total_3)->mergeCells(c2(19, 19, $i, $i + 3))->setCellValue(c1(20, $i), count($movil['autonomo']['linea 1']['S']))->mergeCells(c2(20, 20, $i, $i + 3))->setCellValue(c1(21, $i), '')->mergeCells(c2(21, 21, $i, $i + 3))->setCellValue(c1(22, $i), count($movil['autonomo']['linea 1']['M']))->mergeCells(c2(22, 22, $i, $i + 3))->setCellValue(c1(23, $i), '')->mergeCells(c2(23, 23, $i, $i + 3))->setCellValue(c1(24, $i), count($movil['autonomo']['linea 1']['L']))->mergeCells(c2(24, 24, $i, $i + 3))->setCellValue(c1(25, $i), '')->mergeCells(c2(25, 25, $i, $i + 3))->setCellValue(c1(26, $i), count($movil['autonomo']['linea 2']['S']))->mergeCells(c2(26, 26, $i, $i + 3))->setCellValue(c1(27, $i), '')->mergeCells(c2(27, 27, $i, $i + 3))->setCellValue(c1(28, $i), count($movil['autonomo']['linea 2']['M']))->mergeCells(c2(28, 28, $i, $i + 3))->setCellValue(c1(29, $i), '')->mergeCells(c2(29, 29, $i, $i + 3))->setCellValue(c1(30, $i), count($movil['autonomo']['linea 1']['L']))->mergeCells(c2(30, 30, $i, $i + 3))->setCellValue(c1(31, $i), '')->mergeCells(c2(31, 31, $i, $i + 3))->setCellValue(c1(32, $i), $total_4)->mergeCells(c2(32, 32, $i, $i + 3))->setCellValue(c1(33, $i), $total_5)->mergeCells(c2(33, 33, $i, $i + 3))->setCellValue(c1(34, $i), $total_6)->mergeCells(c2(34, 34, $i, $i + 3))->setCellValue(c1(2, $i + 1), 'Fibra 120MB')->setCellValue(c1(3, $i + 1), count($fibra['residencial']['2P']['120MB']))->setCellValue(c1(4, $i + 1), '')->setCellValue(c1(5, $i + 1), count($fibra['residencial']['3P']['120MB']))->setCellValue(c1(6, $i + 1), '')->setCellValue(c1(15, $i + 1), count($fibra['autonomo']['fibra']['120MB']['Alta Nueva']))->setCellValue(c1(16, $i + 1), '')->setCellValue(c1(17, $i + 1), count($fibra['autonomo']['fibra']['120MB']['Portabilidad']))->setCellValue(c1(18, $i + 1), '')->setCellValue(c1(2, $i + 2), 'Fibra 50MB')->setCellValue(c1(3, $i + 2), count($fibra['residencial']['2P']['50MB']))->setCellValue(c1(4, $i + 2), '')->setCellValue(c1(5, $i + 2), count($fibra['residencial']['3P']['50MB']))->setCellValue(c1(6, $i + 2), '')->setCellValue(c1(15, $i + 2), count($fibra['autonomo']['fibra']['50MB']['Alta Nueva']))->setCellValue(c1(16, $i + 2), '')->setCellValue(c1(17, $i + 2), count($fibra['autonomo']['fibra']['50MB']['Portabilidad']))->setCellValue(c1(18, $i + 2), '')->setCellValue(c1(2, $i + 3), 'ADSL')->setCellValue(c1(3, $i + 3), count($fibra['residencial']['2P']['adsl']))->setCellValue(c1(4, $i + 3), '')->setCellValue(c1(5, $i + 3), count($fibra['residencial']['3P']['adsl']))->setCellValue(c1(6, $i + 3), '')->setCellValue(c1(15, $i + 3), count($fibra['autonomo']['adsl']['Alta Nueva']))->setCellValue(c1(16, $i + 3), '')->setCellValue(c1(17, $i + 3), count($fibra['autonomo']['adsl']['Portabilidad']))->setCellValue(c1(18, $i + 3), ''); } session_start(); $modelo = new ModeloComision(); // -------------------------------------------------------- INPUT $in['campania_id'] = Utilidades::clear_input($_GET['campania_id']); $in['anio-mes'] = Utilidades::clear_input($_GET['fecha']); $in['campania_info'] = $modelo->campania_info($in['campania_id']); $in['lineas'] = trim($_SESSION['lineas']); // -------------------------------------------------------- Data if ($in['campania_info']['indice'] == 'campania_001' && 'Vodafone One' == trim($in['campania_info']['nombre'])) { $pr = $modelo->campania_001_Vodafon_one($in); if (is_array($pr['datos'])) { $ou = $modelo->campania_001_Vodafon_one_process($pr); } else { $ou = null; } } // -------------------------------------------------------- TEST // Utilidades::printr($in); // Utilidades::printr($ou); // -------------------------------------------------------- OUT
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../modelo/ModeloVenta.php"; session_start(); $venta = new ModeloVenta(); // -------------------------------------------------------- INPUT $in['lineas'] = Utilidades::clear_input($_SESSION['lineas']); $in['proceso'] = Utilidades::clear_input($_POST['proceso']); $in['title'] = Utilidades::clear_input($_POST['title']); // --------------------------------------------------------- DATA $ou = $venta->getTimerEstructuraListado($in); echo '<center><h2>' . html_entity_decode($in['title']) . '</h2></center>'; echo '<input type="hidden" class="field_proceso" value="' . $in['proceso'] . '">'; echo '<table width="100%">'; echo '<thead>'; echo '<tr>'; echo '<th>Nro</th> <th>Fecha de Creación</th> <th>Documento</th> <th>Cliente</th> <th>Campaña</th> <th>Supervisor</th> <th>Asesor de Venta</th> <th>Acciones</th> '; echo '</tr>'; echo '</thead>'; $i = 1;
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../../../lib/html/tabla.php"; include "../../../modelo/ModeloReporte01.php"; session_start(); $venta = new ModeloVenta(); // -------------------------------------------------------- INPUT $in['campania_id'] = Utilidades::clear_input($_POST['campania_id']); $in['cliente_tipo_id'] = Utilidades::clear_input($_POST['cliente_tipo_id']); // -------------------------------------------------------- Data $ou = $venta->getClienteTipoByCampania($in); if ($ou) { $combo = new OptionComboSimple(); $combo->set_option($in['cliente_tipo_id']); $combo->set_format(array('id', 'nombre')); $combo->imprimir($ou); } // -------------------------------------------------------- TEST // Utilidades::printr($in); // Utilidades::printr($ou); // -------------------------------------------------------- OUT
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../modelo/ModeloApunte.php"; session_start(); $prefix = 'apuntes_listado_'; $modelo = new ModeloApunte(); // -------------------------------------------------------- INPUT $in['id'] = Utilidades::clear_input_id($_POST['id']); $in['texto'] = Utilidades::clear_input($_POST['texto']); $in['pendiente'] = Utilidades::clear_input($_POST['pendiente']); $in['telefono'] = Utilidades::clear_input($_POST['telefono']); $in['user_id'] = Utilidades::clear_input_id($_SESSION['user_id']); $in['fecha'] = date('Y-m-d H:i:s'); // --------------------------------------------------------- DATA $modelo->apuntes_save($in); // --------------------------------------------------------- TEST // Utilidades::printr($in); // echo html_entity_decode($in['texto']); // ---------------------------------------------------------- OUT
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../modelo/ModeloUsuario.php"; $modelo = new ModeloUsuario(); session_start(); // -------------------------------------------------------- INPUT $in['id'] = Utilidades::clear_input_id($_POST['usuario_id']); $in['info_status'] = Utilidades::clear_input($_POST['vigente']); $in['fecha'] = date('Y-m-d H:i:s'); $in['usuario'] = $_SESSION['user_id']; // -------------------------------------------------------- Data $modelo->updateVigente($in); // -------------------------------------------------------- TEST // Utilidades::printr($in); // -------------------------------------------------------- OUT
<?php include "../../../lib/mysql/dbconnector.php"; include "../../../lib/mysql/conexion01.php"; include "../../../lib/mysql/utilidades.php"; include "../modelo/logica.php"; if ($_SERVER["REQUEST_METHOD"] == "POST") { $in['nombre'] = Utilidades::clear_input($_POST["nombre"]); $in['pwd'] = Utilidades::clear_input($_POST["pwd"]); ModeloAuten::logIn($in); // var_dump($_SESSION); } header('Location: ../../ventas/index.php');
<?php include "../../../lib/mysql/dbconnector.php"; include "../../../lib/mysql/conexion01.php"; include "../../../lib/mysql/utilidades.php"; include "../modelo/logica.php"; if ($_SERVER["REQUEST_METHOD"] == "POST") { $in['user_id'] = $_SESSION["user_id"]; $in['login'] = $_SESSION["user_name"]; $in['pwd-old'] = Utilidades::clear_input($_POST["pwd-old"]); $in['pwd-new-1'] = Utilidades::clear_input($_POST["pwd-new-1"]); $in['pwd-new-2'] = Utilidades::clear_input($_POST["pwd-new-2"]); // var_dump($in); ModeloAuten::changePWD($in); } header('Location: ../../autentificacion/index.php');
<?php include "../../../../../lib/mysql/dbconnector.php"; include "../../../../../lib/mysql/conexion01.php"; include "../../../../../lib/mysql/utilidades.php"; include "../../../../../lib/html/tabla.php"; include "../../../modelo/ModeloVenta.php"; $venta = new ModeloVenta(); // -------------------------------------------------------- INPUT $in['termino'] = Utilidades::clear_input(Utilidades::sanear_complete_string($_REQUEST['term'])); $in['campo'] = Utilidades::clear_input_id($_REQUEST['campo']); $in['dependencia'] = Utilidades::clear_input($_REQUEST['dependencia']); $in['dependencia_value'] = Utilidades::clear_input($_REQUEST['dependencia_value']); $in['diccionario'] = Utilidades::clear_input($_REQUEST['diccionario']); // print_r($in); // --------------------------------------------------------- DATA $ou = $venta->getAutoComplete($in); // --------------------------------------------------------- TEST $json = array(); if (is_array($ou)) { foreach ($ou as $row) { $tmp = array(); $tmp['value'] = utf8_encode($row['termino']); $tmp['label'] = utf8_encode($row['termino']); $tmp['id'] = $row['id']; $json[] = $tmp; } } echo json_encode($json);