PHP DataGrid类代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了PHP中DataGrid类的典型用法代码示例。如果您正苦于以下问题：PHP DataGrid类的具体用法？PHP DataGrid怎么用？PHP DataGrid使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

在下文中一共展示了DataGrid类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。

示例1: filteredgrid2

 function filteredgrid2()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $mSPRV = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;odigo', 'nombre' => 'Nombre', 'rif' => 'Rif', 'contacto' => 'Contacto'), 'filtro' => array('proveed' => 'C&oacute;digo', 'nombre' => 'Nombre', 'rif' => 'Rif'), 'retornar' => array('proveed' => 'cod_prov'), 'titulo' => 'Buscar Beneficiario');
     $bSPRV = $this->datasis->p_modbus($mSPRV, "sprv");
     $filter = new DataFilter2($this->titp);
     $filter->nomi = new inputField("N&uacute;mero", "nomina");
     $filter->nomi->size = 15;
     //$filter->numero->clause="likerigth";
     $filter->cod_prov = new inputField("Proveedor", "cod_prov");
     $filter->cod_prov->rule = 'required';
     $filter->cod_prov->size = 5;
     $filter->cod_prov->append($bSPRV);
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . '/dataedit/show/<#nomina#>', '<str_pad><#nomina#>|8|0|STR_PAD_LEFT</str_pad>');
     $grid = new DataGrid("Lista de Deducciones de N&oacute;mina");
     $grid->db->select(array("nomina", "b.nombre", "SUM(monto)total"));
     $grid->db->from('retenomi');
     $grid->db->join('sprv b', 'retenomi.cod_prov = b.proveed', 'LEFT');
     $grid->db->groupby('nomina');
     $grid->db->orderby('nomina', 'desc');
     $grid->use_function('substr', 'str_pad');
     $grid->per_page = 20;
     $grid->column("N&uacute;mero", $uri);
     $grid->column("Proveedor", "nombre", 'align="left"');
     $grid->column("Total", "<number_format><#total#>|2|,|.</number_format>", 'align="right"');
     $grid->add($this->url . "dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = " {$this->titp} ";
     $data["head"] = script("jquery.js") . $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:enderochoa，项目名称:tortuga，代码行数:34，代码来源:retenomi.php

示例2: index

 function index()
 {
     $this->rapyd->load("datagrid", "datafilter2");
     $filter = new DataFilter2("Filtro de " . $this->titp, 'horarios');
     $filter->id = new inputField("Id", "id");
     $filter->id->size = 10;
     $filter->id->clause = "likerigth";
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 10;
     $filter->codigo->clause = "likerigth";
     $filter->denomi = new inputField("Denominaci&oacute;n", "denomi");
     $filter->denomi->size = 10;
     $filter->denomi->clause = "likerigth";
     $filter->turno = new inputField("Turno", "turno");
     $filter->turno->size = 10;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<#id#>', '<#id#>');
     $grid = new DataGrid();
     $grid->order_by("codigo", "asc");
     $grid->per_page = 15;
     $grid->column("Id", $uri);
     $grid->column("C&oacute;ndigo", "codigo");
     $grid->column("Denomina&oacute;n", "denomi");
     $grid->column("Turno", "turno", "align='left'");
     $grid->column("Entrada", "entrada", "align='left'");
     $grid->column("Salida", "salida", "align='left'");
     $grid->add($this->url . "dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = "<h1>{$this->titp}</h1>";
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:34，代码来源:horarios.php

示例3: detalles

 function detalles($codigo = NULL)
 {
     $this->rapyd->load("datagrid");
     $mSQL = "SELECT DATE_FORMAT(fecha, '%d/%m/%Y')as fecha,codigo,descri1,precio,costo,rela FROM rece WHERE codigo='{$codigo}'";
     $query = $this->db->query($mSQL);
     if ($query->num_rows() > 0) {
         $pdata = $query->row_array();
     }
     $grid = new DataGrid();
     $grid->db->select = array('codigo', 'descrip', 'cantidad', 'costo', 'monto', 'rendi');
     $grid->db->from('itrece');
     $grid->db->where('menu', $codigo);
     $grid->order_by("codigo", "asc");
     //$grid->per_page = 15;
     $uri = anchor("/hospitalidad/agregarrec/mdetalle/{$codigo}/<#codigo#>/modify", '<#codigo#>');
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Cantidad", "cantidad", "align='right'");
     $grid->column("Rendimiento", "rendi", "align='center'");
     $grid->column("Costo", "costo", "align='right'");
     $grid->column("Monto", "monto", "align='right'");
     $grid->add("hospitalidad/agregarrec/mdetalle/{$codigo}/create");
     $grid->build();
     $pdata['items'] = $grid->output;
     $data['content'] = $this->load->view('view_agrecetas', $pdata, true);
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = '<h1>Agregar Receta</h1>';
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:29，代码来源:agregarrec.php

示例4: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro por C&oacute;digo", 'rete');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 15;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('finanzas/rete/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid("Lista de Retenciones");
     $grid->order_by("codigo", "asc");
     $grid->per_page = 20;
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Pago de", "activida");
     $grid->column("Base Imponible", "base1");
     $grid->column("Porcentaje de Retenci&oacute;n", "tari1");
     $grid->column("Para pagos mayores a", "pama1");
     $grid->column("Tipo", "tipo");
     $grid->add("finanzas/rete/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Retenciones</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:26，代码来源:rete.php

示例5: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $filter = new DataFilter("Filtro de Transferencias", "stra");
     $filter->numero = new inputField("N&uacute;mero", "numero");
     $filter->numero->size = 15;
     $filter->fecha = new dateonlyField("Fecha", "fecha");
     $filter->fecha->size = 12;
     $filter->envia = new inputField("Envia", "envia");
     $filter->envia->size = 12;
     $filter->recibe = new inputField("Recibe", "recibe");
     $filter->recibe->size = 12;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('supermercado/stra/dataedit/show/<#numero#>', '<#numero#>');
     $grid = new DataGrid("Lista de transferencias");
     $grid->order_by("numero", "desc");
     $grid->per_page = 5;
     $grid->use_function("substr");
     $grid->column("N&uacute;mero", $uri);
     $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
     $grid->column("Env&iacute;a", "envia", "envia");
     $grid->column("Recibe", "recibe");
     $grid->column("Observaci&oacute;n", "observ1");
     //echo $grid->db->last_query();
     $grid->add("supermercado/stra/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Transferencias</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:32，代码来源:stra.php

示例6: Load

 public function Load()
 {
     $eUsuario = unserialize($_SESSION['eUsuario']);
     if ($eUsuario == null) {
         die;
     }
     $sPage = "index.php?Page=BBImprimirr&Action=";
     $lVars['usuario'] = $eUsuario->Apellidos . ', ' . $eUsuario->Nombres;
     $oCelularBBMod = new CelularBBMod();
     $oUbicacionMod = new UbicacionMod();
     $CelID = $_SESSION["sCelID"];
     $FechaMax = $_GET["max"];
     $FechaMin = $_GET["min"];
     $oCelular = $oCelularBBMod->GetCelulaByrID($CelID);
     $lVars['persona'] = $oCelular->Apellidos . ', ' . $oCelular->Nombres;
     $lVars['celular'] = $oCelular->Numero;
     $lVars['imei'] = $oCelular->IMEI;
     $lVars["btnImprimir"] = $this->oHtml->button("btnImprimir", "btnPrincipal", "Imprimir", array('onclick', "window.print();"));
     $dsUbicaciones = $oUbicacionMod->ListarUbicaciones($CelID, $FechaMax, $FechaMin);
     $dgView = new DataGrid($dsUbicaciones, '', 'DataGridA');
     $dgView->lCabecera = array(array('12%', 'Fecha'), array('40%', 'Direccion'), array('12%', 'Distrito'), array('12%', 'Ciudad'), array('12%', 'Departamento'), array('12%', 'Pais'));
     $dgView->lCampos = array(array('d', 'Fecha'), array('d', 'Calle'), array('d', 'Distrito'), array('d', 'Ciudad'), array('d', 'Departamento'), array('d', 'Pais'));
     $lVars['dgUbicaciones'] = $dgView->Imprimir();
     $lVars['Ajax'] = $this->oAjax->ImprimirJs();
     $this->lView->show($this->lPage, $lVars);
 }

开发者ID:ColliderTD，项目名称:geopd，代码行数:26，代码来源:BBImprimirCon.php

示例7: index

 function index()
 {
     $this->rapyd->load("datagrid", "datafilter");
     $this->datasis->modulo_id(715, 1);
     $filter = new DataFilter("Filtro de noco");
     $filter->db->select("codigo,tipo,nombre,CONCAT_WS('',observa1,observa2 ) AS observa");
     $filter->db->from('noco');
     $filter->nombre = new inputField("Nombre", "nombre");
     $filter->nombre->size = 40;
     //$filter->status = new dropdownField("Status", "tipo");
     //$filter->status->option("S","Semanal");
     //$filter->status->option("Q","Quincenal");
     //$filter->status->option("M","Mensual");
     //$filter->status->option("O","Otro");
     //$filter->status->style='width:100px';
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/noco/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid();
     $grid->order_by("codigo", "asc");
     $grid->per_page = 15;
     $grid->column("C&oacute;digo", $uri);
     //$grid->column("T&iacute;tulo","nombre");
     //$grid->column("Observaci&oacute;n","observa");
     //$grid->column("Tipo" ,"tipo" ,"align='center'");
     $grid->add("nomina/noco/dataedit/create");
     $grid->build();
     //echo $grid->db->last_query();
     $data['content'] = $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = '<h1>Contratos</h1>';
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:33，代码来源:noco.php

示例8: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("datafilter2", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter2("", 'carg');
     $filter->cargo = new inputField("C&oacute;digo", "cargo");
     $filter->cargo->size = 3;
     $filter->cargo->clause = "likerigth";
     $filter->descrip = new inputField("Descripci&oacute;n", "descrip");
     $filter->cargo->clause = "likerigth";
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/carg/dataedit/show/<raencode><#cargo#></raencode>', '<#cargo#>');
     $grid = new DataGrid("");
     $grid->order_by("cargo", "asc");
     $grid->per_page = 20;
     $grid->column_orderby("Cargo", $uri, "cargo");
     $grid->column_orderby("Descripci&oacute;n", "descrip", "descrip", "align='left'NOWRAP");
     $grid->column_orderby("Sueldo", "<number_format><#sueldo#>|2|,|.</number_format>", "sueldo", "align='right'     ");
     $grid->column_orderby("Estructura Administrativa", "codigoadm", "codigoadm", "align='left'      ");
     $grid->column_orderby("Codigo Presupuestario", "codigopres", "codigopres", "align='left'      ");
     $grid->column_orderby("F. Financiamiento", "fondo", "fondo", "align='left'      ");
     $grid->add("nomina/carg/dataedit/create");
     $grid->build();
     //$data['content'] = $filter->output.$grid->output;
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = "Cargos";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:enderochoa，项目名称:tortuga，代码行数:32，代码来源:carg.php

示例9: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro de Tarifas Telef&oacute;nicas", 'tari');
     $filter->gr_desc = new inputField("C&oacute;digo", "serial");
     $filter->gr_desc->size = 15;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('hospitalidad/taritele/dataedit/show/<#serial#>', '<#serial#>');
     $grid = new DataGrid("Lista de Tarifas Telef&oacute;nicas");
     $grid->order_by("serial", "asc");
     $grid->per_page = 7;
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descrip", "descrip");
     $grid->column("Banda", "banda");
     $grid->column("Pulso", "pulso");
     $grid->column("Tarifa 1", "tarifa1");
     $grid->column("Tarifa2", "tarifa2");
     $grid->add("hospitalidad/taritele/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "<h1>Tarifas Telef&oacute;nicas</h1>";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:26，代码来源:taritele.php

示例10: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid", "dataobject");
     $filter = new DataFilter("", "contribu");
     $filter->codigo = new inputField("C&oacute;digo", 'codigo');
     $filter->nombre = new inputField("Nombre", 'nombre');
     $filter->rifci = new inputField("RIF / C&eacute;dula", 'rifci');
     $filter->nacionali = new inputField("Nacionalidad", 'nacionali');
     $filter->nacionali->option('', '');
     $filter->nacionali->option('VENEZOLANA', 'VENEZOLANA');
     $filter->nacionali->option('EXTRANJERA', 'EXTRANJERA');
     $filter->direccion = new inputField("Direcci&oacute;n", 'direccion');
     $filter->telefono = new inputField("Telefono", 'telefono');
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor($this->url . 'dataedit/show/<raencode><#codigo#></raencode>', '<#codigo#>');
     $grid = new DataGrid("");
     $grid->order_by("codigo ");
     $grid->per_page = 40;
     $grid->column_orderby("C&oacute;digo", $uri, "codigo");
     $grid->column_orderby("Nombre", "nombre", "nombre", "align='left'    ");
     $grid->column_orderby("Nacionalidad", "nacionali", "numcuent", "align='left'    ");
     $grid->column_orderby("RIF/C&eacute;dula", "rifci", "cedula", "align='left'     ");
     $grid->column_orderby("Direcci&oacute;n", "direccion", "direccion", "align='left'    ");
     $grid->column_orderby("Telefono", "telefono", "direccion", "align='left'    ");
     $grid->add($this->url . "dataedit/create");
     $grid->build();
     //$data['content'] = $filter->output.$grid->output;
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data['title'] = "{$this->titp}";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:enderochoa，项目名称:tortuga，代码行数:35，代码来源:contribu.php

示例11: detalles

 function detalles($control = NULL)
 {
     $this->rapyd->load("datagrid");
     $mSQL = "SELECT * FROM scst WHERE control='{$control}'";
     $query = $this->db->query($mSQL);
     if ($query->num_rows() > 0) {
         $pdata = $query->row_array();
     }
     $grid = new DataGrid();
     $grid->db->select = array('codigo', 'descrip', 'cantidad', 'costo', 'importe');
     $grid->db->from('itscst');
     $grid->db->where('control', $control);
     $grid->order_by("codigo", "desc");
     //$grid->per_page = 15;
     $uri = anchor("/compras/agregar/mdetalle/{$control}/modify/<#id#>", '<#codigo#>');
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Cantidad", "cantidad", "align='right'");
     $grid->column("Precio", "costo", "align='right'");
     $grid->column("Importe", "importe", "align='right'");
     $grid->add("compras/agregar/mdetalle/{$control}/create");
     $grid->add("compras/agregar/encab/modify/{$control}/", 'Modificar encabezado');
     $grid->build();
     $pdata['items'] = $grid->output;
     $data['content'] = $this->load->view('view_agcompras', $pdata, true);
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = '<h1>Agregar Art&iacute;culos</h1>';
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:29，代码来源:agregar.php

示例12: createComponentDataGrid

 /**
  * Component factory.
  * @see Nette/ComponentContainer#createComponent()
  */
 protected function createComponentDataGrid($name)
 {
     $grid = new DataGrid();
     $grid->bindDataTable(dibi::getConnection()->dataSource('SELECT
       authorId as id,
       name,
       surname,
       class,', Model::sqlClassName(Model::getSchoolYear()) . 'as classMark,
       (SELECT COUNT(workId) FROM [works] WHERE author=authorId) as sum                        
       FROM [authors]
     '));
     $grid->addColumn('name', 'Jméno');
     $grid->addColumn('surname', 'Příjmení')->addDefaultSorting('asc');
     $grid->addColumn('class', 'Maturita')->getCellPrototype()->style('text-align: center;');
     $grid->addColumn('classMark', 'Třída')->getCellPrototype()->style('text-align: right;');
     $grid->addColumn('sum', 'Počet prací')->getCellPrototype()->style('text-align: right;')->class('pages');
     $grid->addActionColumn('Akce');
     $grid->keyName = 'id';
     $grid->addAction('Smazat', 'delete!', NULL, FALSE, DataGridAction::WITH_KEY);
     $grid['name']->addFilter();
     $grid['surname']->addFilter();
     $grid['class']->addSelectboxFilter();
     $grid['classMark']->addSelectboxFilter();
     $grid['sum']->addSelectboxFilter();
     $grid->multiOrder = FALSE;
     $grid->itemsPerPage = $this->getCookiesItemsCount(15);
     $renderer = $grid->getRenderer();
     $renderer->paginatorFormat = '%label% %input% z %count%';
     $renderer->infoFormat = 'Autoři %from%. - %to%. z %count% | Zobrazit: %selectbox% | %reset%';
     $renderer->onRowRender[] = array($this, 'OnRowRendered');
     //$grid->rememberState = TRUE;
     $this->addComponent($grid, $name);
     return;
 }

开发者ID:xixixao，项目名称:chytrapalice，代码行数:38，代码来源:AuthorList.php

示例13: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     //		$this->rapyd->uri->keep_persistence();
     $filter = new DataFilter("Filtro por Expediente", "bi_terreno");
     $filter->expediente = new inputField("Numero expediente", "expediente");
     $filter->expediente->size = 20;
     $filter->denominacion = new inputField("Denominaci&oacute;n", "denominacion");
     $filter->denominacion->size = 20;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('bienes/bi_terreno/dataedit/show/<#id#>', '<#id#>');
     $grid = new DataGrid("Lista de terrenos");
     $grid->order_by("expediente", "asc");
     $grid->per_page = 20;
     $grid->column("Id", $uri, "align='center'");
     $grid->column("Expediente", "expediente", "align='center'");
     $grid->column_orderby("Est.Propietario", "est_propietario", "est_propietario", "align='left'");
     $grid->column_orderby("Denominaci&oacute;n", "denominacion", "denominacion");
     //		$grid->column_orderby("Uso","uso" ,"uso"                    ,"align='center'");
     //		$grid->column_orderby("Estado"          ,"estado","estado"                     ,"align='center'");
     $grid->column_orderby("Municipio", "municipio", "municipio", "align='center'");
     $grid->column_orderby("Direccion", "direccion", "direccion", "align='left'");
     $grid->add("bienes/bi_terreno/dataedit/create");
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = "Terrenos";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:enderochoa，项目名称:tortuga，代码行数:30，代码来源:bi_terreno.php

示例14: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("dataform", "datagrid");
     $modbus = array('tabla' => 'usuario', 'columnas' => array('us_codigo' => 'C&oacute;digo', 'us_nombre' => 'Nombre'), 'filtro' => array('us_nombre' => 'nombre'), 'retornar' => array('us_codigo' => 'usuario'), 'titulo' => 'Buscar Usuario');
     $filter = new DataForm('/supervisor/trabajo/filteredgrid/search/osp');
     $filter->mes = new dateonlyField("Mes", "mes", 'm/Y');
     $filter->mes->clause = "where";
     $filter->mes->operator = "=";
     $filter->mes->size = 8;
     $filter->mes->dbformat = 'Ym';
     $filter->mes->insertValue = date("Y-m-d");
     $filter->usuario = new inputField("C&oacute;digo de usuario", "usuario");
     $filter->usuario->size = 11;
     $filter->usuario->append($this->datasis->modbus($modbus));
     $filter->submit('manda', 'Buscar');
     $filter->build_form();
     /*
     $mSQL="(SELECT fecha, count(*) AS cant FROM bitacora WHERE usuario='DAVID' GROUP BY fecha ) UNION
     (SELECT a.fecha, 0 AS cant FROM dim_tiempo AS a LEFT JOIN  bitacora as b ON a.fecha=b.fecha AND b.usuario='DAVID'
     WHERE a.fecha BETWEEN (SELECT MIN(fecha) FROM bitacora) AND (SELECT MAX(fecha) FROM bitacora) AND b.fecha IS NULL) ORDER BY fecha";
     */
     $content = '';
     if ($this->input->post('manda')) {
         $usr = $this->input->post('usuario') ? ' AND b.usuario="' . $this->input->post('usuario') . '"' : '';
         $fechad = '(SELECT MIN(fecha) FROM bitacora)';
         $fechah = '(SELECT MAX(fecha) FROM bitacora)';
         if ($this->input->post('mes')) {
             $acum = explode('/', $filter->mes->value);
             $fechad = $acum[1] . $acum[0] . '01';
             $fechah = $acum[1] . $acum[0] . '31';
         }
         $mSQL = "SELECT a.fecha, semana FROM dim_tiempo AS a LEFT JOIN  bitacora as b ON a.fecha=b.fecha {$usr} WHERE a.fecha BETWEEN {$fechad} AND {$fechah} AND b.fecha IS NULL";
         //echo $mSQL;
         $sema = array('Lunes', 'Martes', 'Miercoles', 'Jueves', 'Viernes', 'Sabado', 'Domingo');
         $query = $this->db->query($mSQL);
         $data = array();
         foreach ($query->result() as $row) {
             $pasa = array();
             $pasa['fecha'] = $row->fecha;
             if ($row->semana > 5) {
                 $pasa['cant'] = $sema[$row->semana - 1];
             } else {
                 $pasa['cant'] = '<b>' . $sema[$row->semana - 1] . '</b>';
             }
             $data[] = $pasa;
         }
         $query->free_result();
         //grid
         $grid = new DataGrid("Lista de Bitacora", $data);
         $grid->per_page = 31;
         $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>");
         $grid->column("Semana", "<#cant#>");
         $grid->build();
         $content = $grid->output;
     }
     $data['content'] = $filter->output . $content;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = ' Dias NO trabajados ';
     $this->load->view('view_ventanas', $data);
 }

开发者ID:enderochoa，项目名称:tortuga，代码行数:60，代码来源:trabajo.php

示例15: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load("datafilter", "datagrid");
     $filter = new DataFilter("", 'prof');
     $filter->codigo = new inputField("Codigo", "codigo");
     $filter->codigo->size = 20;
     $filter->codigo->maxlength = 8;
     $filter->profesion = new inputField("Profesion", "profesion");
     $filter->profesion->size = 20;
     $filter->profesion->maxlength = 40;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('nomina/prof/dataedit/show/<#codigo#>', '<#codigo#>');
     $grid = new DataGrid("");
     $grid->per_page = 15;
     $grid->column_orderby("Codigo", $uri, "codigo");
     $grid->column_orderby("Profesiones", "profesion", "profesion", "align='left'NOWRAP");
     $grid->add("nomina/prof/dataedit/create");
     $grid->build();
     //$data['content'] = $filter->output.$grid->output;
     $data['title'] = "Profesiones";
     $data['filtro'] = $filter->output;
     $data['content'] = $grid->output;
     $data['script'] = script("jquery.js") . "\n";
     $data["head"] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:enderochoa，项目名称:tortuga，代码行数:27，代码来源:prof.php

示例16: detalles

 function detalles($numero = NULL)
 {
     $this->rapyd->load("datagrid");
     $mSQL = "SELECT tipo_doc, numero,DATE_FORMAT(fecha, '%d/%m/%Y')as fecha, cod_cli, rifci, nombre, direc, dire1,totals, iva, totalg,DATE_FORMAT(vence, '%d/%m/%Y')as vence, observa1, observa2,orden FROM otin WHERE numero='{$numero}'";
     $query = $this->db->query($mSQL);
     if ($query->num_rows() > 0) {
         $pdata = $query->row_array();
     }
     $grid = new DataGrid();
     $grid->db->select = array('codigo', 'descrip', 'cantidad', 'precio', 'importe');
     $grid->db->from('itotin');
     $grid->db->where('numero', $numero);
     $grid->order_by("codigo", "desc");
     //$grid->per_page = 15;
     $uri = anchor("/ventas/agregaroi/mdetalle/{$numero}/modify/<#id#>", '<#codigo#>');
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descrip");
     $grid->column("Cantidad", "cantidad", "align='right'");
     $grid->column("Precio", "precio", "align='right'");
     $grid->column("Importe", "importe", "align='right'");
     $grid->add("ventas/agregaroi/mdetalle/{$numero}/create");
     $grid->build();
     $pdata['items'] = $grid->output;
     $data['content'] = $this->load->view('view_agotrosingresos', $pdata, true);
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = '<h1>Agregar Art&iacute;culos</h1>';
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:28，代码来源:agregaroi.php

示例17: index

 function index()
 {
     $this->rapyd->load("datagrid", "datafilter");
     $filter = new DataFilter("Filtro de Recetas", 'rece');
     $filter->codigo = new inputField("C&oacute;digo", "codigo");
     $filter->codigo->size = 10;
     $filter->descri1 = new inputField("Descripci&oacute;n", "descri1");
     $filter->descri1->size = 30;
     $filter->buttons("reset", "search");
     $filter->build();
     $uri = anchor('hospitalidad/recetas/dataedit/show/<#codigo#>/', '<#codigo#>');
     $grid = new DataGrid();
     $grid->order_by("fecha", "desc");
     $grid->per_page = 15;
     $grid->column("C&oacute;digo", $uri);
     $grid->column("Descripci&oacute;n", "descri1");
     $grid->column("Precio", "<number_format><#precio#>|2</number_format>", "align=right");
     $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'");
     $grid->column("Costo", "<number_format><#costo#>|2</number_format>", "align=right");
     $grid->column("Rela", "rela", "align='center'");
     $grid->add("hospitalidad/agregarrec");
     $grid->build();
     //echo $grid->db->last_query();
     $data['content'] = $filter->output . $grid->output;
     $data["head"] = $this->rapyd->get_head();
     $data['title'] = '<h1>Recetas</h1>';
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:28，代码来源:recetas.php

示例18: filteredgrid

 function filteredgrid()
 {
     $this->rapyd->load('datafilter2', 'datagrid');
     $filter = new DataFilter2('', 'tban');
     $filter->codbanc = new inputField('C&oacute;digo', 'cod_banc');
     $filter->codbanc->size = 5;
     $filter->codbanc->clause = 'likerigth';
     $filter->banco = new inputField('Nombre de Banco', 'nomb_banc');
     $filter->banco->size = 30;
     $filter->banco->clause = 'likerigth';
     $filter->buttons('reset', 'search');
     $filter->build();
     $uri = anchor('tesoreria/tban/dataedit/show/<#cod_banc#>', '<#cod_banc#>');
     $grid = new DataGrid("");
     $grid->per_page = 20;
     $grid->column_orderby('C&oacute;digo', $uri, 'cod_banc');
     $grid->column_orderby('Banco', 'nomb_banc', 'nomb_banc', "align='left' NOWRAP");
     //$grid->column_orderby("Tipo"   ,"tipotra"  ,"tipotra"  );
     //$grid->column_orderby("Formaca","formaca"  ,"formaca"  );
     $grid->add('tesoreria/tban/dataedit/create');
     $grid->build();
     $data['content'] = $filter->output . $grid->output;
     $data['title'] = 'Tabla de Bancos';
     $data['head'] = $this->rapyd->get_head();
     $this->load->view('view_ventanas', $data);
 }

开发者ID:enderochoa，项目名称:tortuga，代码行数:26，代码来源:tban.php

示例19: index

 function index()
 {
     $this->datasis->modulo_id($this->modulo, 1);
     $this->rapyd->load("datagrid", "dataform", "fields");
     $control = $this->uri->segment(4);
     $checkbox = '<input type="checkbox" name="genera[]" value="<#modulo#>" CHECKED>';
     $grid = new DataGrid('Seleccione los m&oacute;dulos que desea generar');
     $grid->db->select('modulo, descripcion');
     $grid->db->from('`reglascont`');
     $grid->db->groupby('modulo');
     $grid->db->orderby('modulo,regla');
     $grid->column("M&oacute;dulo", "modulo");
     $grid->column("Descripci&oacute;n", "descripcion");
     $grid->column('Generar', $checkbox, 'align="center"');
     $grid->build();
     $form = new DataForm('contabilidad/generar/procesar');
     $form->title('Rango de fecha para la Generaci&oacute;n');
     $form->fechai = new dateonlyField("Fecha Desde", "fechai", "d/m/Y");
     $form->fechaf = new dateonlyField("Fecha Hasta", "fechaf", "d/m/Y");
     $form->fechaf->size = $form->fechai->size = 10;
     $form->fechai->insertValue = $this->input->post('fechai') ? $this->input->post('fechai') : date("Ymd");
     $form->fechaf->insertValue = $this->input->post('fechaf') ? $this->input->post('fechaf') : date("Ymd");
     $form->tabla = new containerField('tabla', $grid->output);
     if ($control) {
         $form->control = new containerField('control', 'Contabilidad Generada');
     }
     //$form->submit("btn_submit","Generar Depurado");
     $form->build_form();
     $data['script'] = "<script type='text/javascript'>\n\t\tvar handlerFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert(t.responseText);\n\t\t}\n\n\t\tvar errFunc = function(t) {\n\t\t\tdocument.getElementById('preloader').style.display='none';\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:0.3, to:1.0});\n\t\t\talert('Error ' + t.status + ' -- ' + t.statusText);\n\t\t}\n\n\t\tfunction generar() {\n\t\t\tnew Effect.toggle('preloader', 'appear');\n\t\t\tnew Effect.Opacity('contenido', {duration:0.5, from:1.0, to:0.3});\n\t\t\tnew Ajax.Request('" . site_url('contabilidad/generar/procesar') . "',{\n\t\t\t method: 'post',\n\t\t\t parameters : Form.serialize('df1'),\n\t\t\t onSuccess:handlerFunc,\n\t\t\t onFailure:errFunc});\n\t\t}\n\t\t</script>";
     $data['extras'] = "<div id='preloader' style='display: none;\tposition:absolute; left:40%; top:40%; font-family:Verdana, Arial, Helvetica, sans-serif;'>\n\t\t\t<center>" . image("loading4.gif") . "<br>" . image("loadingBarra.gif") . "<br>\n\t\t\t<b>Generando . . . </b>\n\t\t\t</center>\n\t\t</div>";
     $data['content'] = $form->output . "<input type=button value='Generar' onclick='generar()'>";
     $data["head"] = $this->rapyd->get_head() . script("prototype.js") . script("scriptaculous.js") . script("effects.js");
     $data['title'] = "<h1>Generar Contabilidad</h1>";
     $this->load->view('view_ventanas', $data);
 }

开发者ID:codethics，项目名称:proteoerp，代码行数:35，代码来源:generar.php

示例20: filteredgrid

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

PHP DataHandler类代码示例发布时间：2022-05-23

PHP DataGenerator类代码示例发布时间：2022-05-23

Kong/lua-resty-worker-events: Cross Work

leoliu1221/matlabFaceRecognitionRealTime

2022-08-17

delphi6.0如何做订单

2022-07-18

notagoat/mastoji: Fetches emojis from in

2022-08-17

iscsi-osx/iSCSIInitiator: iSCSI Initiato

2022-08-18

CVE-2022-2537

2022-09-18

阅读排行榜

1 dphi-official/Machine_Learning_Bootcamp

dphi-official/Machine_Learning_Bootcamp

阅读：1379|2022-08-18

2 juven/maven-bash-completion: Maven Bash

juven/maven-bash-completion: Maven Bash Auto Completion

阅读：827|2022-08-16

3 win7系统注册表编辑器打开的操作方法

win7系统电脑使用过程中有不少朋友表示遇到过win7系统注册表编辑器打开的状况，当出现

阅读：771|2022-11-06

4 route101/mastoinker: Quick image view as

route101/mastoinker: Quick image view assistant for Mastodon client

阅读：937|2022-08-18

5 CVE-2022-21509

Vulnerability in the MySQL Server product of Oracle MySQL (component: Server: Op

阅读：617|2022-07-29

6 CVE-2022-2576

In Eclipse Californium version 2.0.0 to 2.7.2 and 3.0.0-3.5.0 a DTLS resumption

阅读：1001|2022-08-12

7 0e0w · GitHub

0e0w · GitHub

阅读：435|2022-08-15

8 tgreyuk/typedoc-plugin-markdown: A plugi

tgreyuk/typedoc-plugin-markdown: A plugin for TypeDoc that enables TypeScript AP

阅读：778|2022-08-18

9 c++builder重载WindowProc、WndProc截获消

c++builder重载WindowProc、WndProc截获消息方法一WindowProcvoid__fastcall myWin

阅读：669|2022-07-18

10 台湾人说什么话，大连话和台湾腔的魔性对比

台湾人的方言是“台湾话”，官方是“国语”，和普通话一样。小编一直觉得，大连话和台

阅读：321|2022-11-06

扫描微信二维码

查看手机版网站

随时了解更新最新资讯

139-2527-9053

在线客服（服务时间 9:00～18:00）

在线QQ客服

地址：深圳市南山区西丽大学城创智工业园

电邮：jeky_zhao#qq.com

移动电话：139-2527-9053

客服电话

电子邮件