コード例 #1
0
 public function listproductosclientesAction($cliente_id)
 {
     $model = new Planpagos();
     $resul = $model->lista($cliente_id);
     $this->view->disable();
     foreach ($resul as $v) {
         $customers[] = array('id' => $v->id, 'grupo' => $v->grupo, 'razon_social' => $v->razon_social, 'linea' => $v->linea, 'estacion' => $v->estacion, 'producto' => '<a href="/planpagos/controlpago/' . $v->id . '">' . $v->producto . '</a>', 'contrato' => $v->contrato, 'fecha_contrato' => $v->fecha_contrato, 'fecha_inicio' => $v->fecha_inicio, 'fecha_fin' => $v->fecha_fin, 'total' => $v->total, 'deposito' => $v->deposito, 'cobrar' => $v->total - $v->deposito, 'mora' => $v->mora);
     }
     echo json_encode($customers);
 }
コード例 #2
0
 public function reporteAction()
 {
     $this->view->disable();
     $model = new Planpagos();
     $resul = $model->lista();
     include_once 'tbs_us/tbs_class.php';
     // Load the TinyButStrong template engine
     include_once 'tbs_us/tbs_plugin_opentbs/tbs_plugin_opentbs.php';
     // Load the OpenTBS plugin
     $TBS = new clsTinyButStrong();
     // new instance of TBS
     $TBS->Plugin(TBS_INSTALL, OPENTBS_PLUGIN);
     // load the OpenTBS plugin
     $TBS->VarRef['usuario'] = $this->_user->nombre . ' ' . $this->_user->paterno;
     $data = array();
     $c = 1;
     foreach ($resul as $v) {
         $data[] = array('rank' => 'A', 'nro' => $c, 'grupo' => $v->grupo, 'linea' => $v->linea, 'estacion' => $v->estacion, 'razon_social' => $v->razon_social, 'contrato' => $v->contrato, 'fecha_contrato' => $v->fecha_contrato, 'producto' => $v->producto, 'fecha_inicio' => $v->fecha_inicio, 'fecha_fin' => $v->fecha_fin, 'total' => $v->total, 'deposito' => $v->deposito, 'cobrar' => $v->total - $v->deposito, 'mora' => number_format($v->mora, 2, '.', ','));
         $c++;
     }
     $template = 'file/template/temp_reporte_contratos.xlsx';
     $TBS->LoadTemplate($template, OPENTBS_ALREADY_UTF8);
     // Also merge some [onload] automatic fields (depends of the type of document).
     // ----------------------
     // Debug mode of the demo
     // ----------------------
     // if (isset($_POST['debug']) && ($_POST['debug']=='current')) $TBS->Plugin(OPENTBS_DEBUG_XML_CURRENT, true); // Display the intented XML of the current sub-file, and exit.
     // if (isset($_POST['debug']) && ($_POST['debug']=='info'))    $TBS->Plugin(OPENTBS_DEBUG_INFO, true); // Display information about the document, and exit.
     // if (isset($_POST['debug']) && ($_POST['debug']=='show'))    $TBS->Plugin(OPENTBS_DEBUG_XML_SHOW); // Tells TBS to display information when the document is merged. No exit.
     // Merge data in the first sheet
     $TBS->MergeBlock('a,b', $data);
     // -----------------
     // Output the result
     // -----------------
     // $output_file_name = str_replace('.', '_'.date('Y-m-d').'.', $template);
     $output_file_name = date('Y-m-d') . ' ' . 'reporte.xlsx';
     $TBS->Show(OPENTBS_DOWNLOAD, $output_file_name);
     // Also merges all [onshow] automatic fields.
     exit;
 }