PHP ModeloComision 예제들

예제 #1

파일: comisiones_listado_excel.bk.php 프로젝트: claudiospro/neointel_proyecto02

    }
    if (!isset($fibra['autonomo']['adsl']['Portabilidad'])) {
        $fibra['autonomo']['adsl']['Portabilidad'] = array();
    }
    // ------------------------------------------ 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

예제 #2

파일: comisiones_listado_campaniaXusuario.php 프로젝트: claudiospro/neointel_proyecto02

<?php

include "../../../../../lib/mysql/dbconnector.php";
include "../../../../../lib/mysql/conexion01.php";
include "../../../../../lib/mysql/utilidades.php";
include "../../../../../lib/html/tabla.php";
include "../../../modelo/ModeloComision.php";
session_start();
$modelo = new ModeloComision();
// -------------------------------------------------------- INPUT
$in['campania_id'] = Utilidades::clear_input_id($_POST['campania_id']);
$in['lineas'] = trim($_SESSION['lineas']);
// -------------------------------------------------------- Data
$ou = $modelo->campaniasXusuario($in);
$combo = new OptionComboSimple();
$combo->set_option($in['campania_id']);
$combo->set_format(array('id', 'nombre'));
$combo->imprimir($ou);
// -------------------------------------------------------- TEST
// Utilidades::printr($in);
// Utilidades::printr($ou);
// -------------------------------------------------------- OUT
// echo '<option>aqui</option>';