function wol() { if (!extension_loaded('sockets')) { show_error('La extension "sockets" no esta cargada, debe cargarla para poder usar estas opciones'); } $this->load->library('rapyd'); $this->rapyd->load('dataform'); $form = new DataForm('supervisor/monitoreo/wol/process'); $form->mac = new inputField('Dirección MAC', 'mac'); $form->mac->append('Ejemplo: 00:01:02:03:04:05'); $form->mac->rule = 'required|mac'; $form->mac->maxlength = 17; $form->mac->size = 20; $form->submit('btnsubmit', 'Enviar'); $form->build_form(); if ($form->on_success()) { $mac = $form->mac->newValue; $rt = $this->_wol($mac); if (!$rt) { $form->error_string = $this->error; $form->build_form(); $salida = $form->output . br(); } else { $salida = $form->output . br() . 'Señal enviada satisfactoriamente'; } } else { $salida = $form->output; } $this->rapyd->jquery[] = '$(".inputnum").numeric(".");'; $data['content'] = $salida; $data['title'] = heading('Envio de señal de encendido por LAN'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
public function testTimesAdded() { echo '<h3>Checking Times</h3>'; $sql = 'SELECT `flighttime` FROM ' . TABLE_PREFIX . 'pireps WHERE `accepted`=' . PIREP_ACCEPTED; $results = DB::get_results($sql); $this->added_time = 0; foreach ($results as $row) { $this->added_time = Util::AddTime($this->added_time, $row->flighttime); } heading('Time added, all PIREPS at once'); $this->assertNotEqual(0, $this->added_time); heading('Time added, pilot by pilot'); // Now calculate by PIREP $allpilots = PilotData::GetAllPilots(); $total = 0; foreach ($allpilots as $pilot) { $p_hours = PilotData::getPilotHours($pilot->pilotid); $total = Util::AddTime($total, $p_hours); } $this->assertNotEqual(0, $total); heading('Comparing pilot to pilot vs all PIREPS'); $this->assertEqual($total, $this->added_time); heading('Compare to STAT total hours'); StatsData::UpdateTotalHours(); $this->assertEqual($total, StatsData::TotalHours()); echo '<br />'; }
function predict($opponentCode) { $this->data['ResultsHeading'] = heading("Results", 2, 'class="text-center bg-danger"'); //---- get PIT overall average and get PIT last 5 games average //Our Team $ourCode = "PIT"; $steelersStandings = $this->teams->getFromCode($ourCode); $overallAvg = $steelersStandings->Pct1; //----end get PIT overall average and last 5 games $this->load->model('scores'); $lastFive = $this->scores->getAvgLast5($ourCode); ///--------Predict our points $avgAgainstOpponent = $this->scores->getAvgLast5Opponent($ourCode, $opponentCode); if ($avgAgainstOpponent == 0) { $pointsUs = (0.7 * $overallAvg + 0.2 * $lastFive) / 0.9; } else { $pointsUs = 0.7 * $overallAvg + 0.2 * $lastFive + 0.1 * $avgAgainstOpponent; } $ourTeam = array('TeamName' => $ourCode, 'AveragePts' => $pointsUs); $this->data['OurTeamArray'] = $ourTeam; ///---------end Prediction for Our Team /////------------Predict Opponent points $opponentStandings = $this->teams->getFromCode($opponentCode); $overallOpponentAvg = $opponentStandings->Pct1; $lastFiveOpponent = $this->scores->getAvgLast5($opponentCode); //different when standings updated $avgAgainstUs = $this->scores->getAvgLast5Opponent($opponentCode, $ourCode); if ($avgAgainstUs == 0) { $pointsOpponent = (0.7 * $overallOpponentAvg + 0.2 * $lastFiveOpponent) / 0.9; } else { $pointsOpponent = 0.7 * $overallOpponentAvg + 0.2 * $lastFiveOpponent + 0.1 * $avgAgainstUs; } $opponent = array('TeamName' => $opponentCode, 'AveragePts' => $pointsOpponent); $this->data['OpponentArray'] = $opponent; }
function filteredgrid() { $this->pi18n->cargar('i18n', 'dataedit'); $this->rapyd->load('datafilter', 'datagrid'); $this->rapyd->uri->keep_persistence(); $this->pi18n->msj('rifci', 'RIF o C.I.'); $filter = new DataFilter('Filtro', 'i18n'); $filter->modulo = new inputField('Módulo', 'modulo'); $filter->modulo->size = 20; $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor('supervisor/i18n/dataedit/modify/<#id#>', '<#id#>'); $grid = new DataGrid('Internacionalización'); $grid->order_by('id', 'asc'); $grid->per_page = 20; $grid->column_orderby('ID', $uri, 'id'); $grid->column_orderby('Modulo', 'modulo', 'modulo'); $grid->column_orderby('Método', 'metodo', 'metodo'); $grid->column_orderby('País', 'pais', 'pais'); $grid->column_orderby('Campo', 'campo', 'campo'); $grid->add('supervisor/i18n/dataedit/create'); $grid->build(); $data['content'] = $filter->output . $grid->output; $data['content'] .= $this->pi18n->fallas(); $data['title'] = heading('Internacionalización'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->rapyd->load('dataedit'); $this->rapyd->uri->keep_persistence(); $edit = new DataEdit('Cheque emitido', 'bmov'); $status = $edit->_status; if ($status != 'show') { show_error('Error de parámetros'); } $edit->back_url = site_url('finanzas/conforch/filteredgrid'); $edit->fecha = new DateonlyField('Fecha', 'fecha', 'd/m/Y'); $edit->fecha->insertValue = date('Y-m-d'); $edit->benefi = new inputField('A nombre de', "benefi"); $edit->benefi->group = 'Detalle del cheque'; $edit->banco = new inputField("Del Banco", "banco"); $edit->banco->group = 'Detalle del cheque'; $edit->numcuent = new inputField("Número Cuenta", "numcuent"); $edit->numcuent->in = 'banco'; $edit->numcuent->group = 'Detalle del cheque'; $edit->numero = new inputField("Número de cheque", "numero"); $edit->numero->group = 'Detalle del cheque'; $edit->monto = new inputField("Por un Monto de", "monto"); $edit->monto->group = 'Detalle del cheque'; $edit->nombre = new inputField('Proveedor', 'nombre'); $edit->concepto = new inputField("Por Concepto", "concepto"); $edit->anulado = new inputField("Anulado", "anulado"); $edit->buttons('back'); $edit->build(); $data['content'] = $edit->output; $data['title'] = heading('Consulta de Cheques'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->uri->keep_persistence(); $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter('', 'gpt_pro'); $filter->parr = new inputField('Parámetro', 'parr'); $filter->parr->rule = 'trim|required'; $filter->parr->clause = ''; //$filter->submit = new submitField('Buscar', 'submitbtn'); //$filter->submit->in='parr'; $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor($this->url . 'dataedit/show/<raencode><#id_pro#></raencode>', '<#nom_pro#>', 'target="framedetrepo" onclick="$(\'#cajafiltro\').hide();"'); //$uri = anchor($this->url.'dataedit/show/<raencode><#id_pro#></raencode>','<#nom_pro#>'); $grid = new DataGrid('Especialidades farmaceuticas'); if (strlen($filter->parr->newValue) > 0) { $dbparr = $this->db->escape($filter->parr->newValue); $grid->db->where('MATCH(nom_pro,pres_pro,lab_pro,gen_pro,mono_pro) AGAINST (' . $dbparr . ')'); } $grid->order_by('nom_pro'); $grid->per_page = 15; $grid->column_orderby('Nombre', $uri, 'nom_pro', 'align="left"'); $grid->column_orderby('Presentación', 'pres_pro', 'pres_pro', 'align="left"'); $grid->column_orderby('Laboratorio', 'lab_pro', 'lab_pro', 'align="left"'); //$grid->column_orderby('Cod. Pro','cod_pro','cod_pro','align="left"'); //$grid->column_orderby('Gen. Pro','gen_pro','gen_pro','align="left"'); $grid->build(); $data['filtro'] = $filter->output . $grid->output; $data['content'] = '<script type="text/javascript"> $(function(){ $("#cajafiltro").show(); }); </script>'; //$data['content'].= $acti->output; $data['content'] .= '<IFRAME src="' . site_url('farmacia/gpt_pro/dummy') . '" width="100%" height="500" scrolling="auto" frameborder="0" name="framedetrepo">iframe no son soportados</IFRAME>'; $data['head'] = $this->rapyd->get_head() . script('jquery.js') . script('jquery.highlight.js'); $data['title'] = heading($this->titp); $this->load->view('view_ventanas', $data); }
function dataedit() { $this->rapyd->load('dataedit'); $edit = new DataEdit($this->t**s, 'edifubica'); $edit->back_url = site_url($this->url . 'filteredgrid'); $edit->post_process('insert', '_post_insert'); $edit->post_process('update', '_post_update'); $edit->post_process('delete', '_post_delete'); $edit->pre_process('insert', '_pre_insert'); $edit->pre_process('update', '_pre_update'); $edit->pre_process('delete', '_pre_delete'); $edit->id_edif = new dropdownField('Edificación', 'id_edif'); $edit->id_edif->option('', 'Seleccionar'); $edit->id_edif->options('SELECT id,TRIM(nombre) AS nombre FROM edif ORDER BY nombre'); $edit->id_edif->rule = 'max_length[11]'; $edit->descripcion = new inputField('Descripción', 'descripcion'); $edit->descripcion->rule = 'max_length[50]'; $edit->descripcion->size = 52; $edit->descripcion->maxlength = 50; $edit->buttons('modify', 'save', 'undo', 'delete', 'back', 'add'); $edit->build(); $data['content'] = $edit->output; $data['head'] = $this->rapyd->get_head(); $data['title'] = heading($this->t**s); $this->load->view('view_ventanas', $data); }
/** * database function. * * @access public * @return void */ public function database() { $this->output->enable_profiler(true); $this->load->database(); $this->load->dbutil(); $this->load->dbforge(); $data['title'] = $this->system_model->get('app_name'); $data['breadcrumbs'] = array(array('data' => anchor('/', $this->system_model->get('app_name')), 'mode' => 'unavailable'), array('data' => anchor('install', ucfirst(lang('install'))), 'mode' => 'unavailable'), array('data' => anchor('install/database', ucfirst(lang('install') . ' ' . lang('database'))), 'mode' => 'current')); $html = heading(ucfirst(lang('install')) . ' ' . lang('database'), 1); $current = $this->migration->current(); if (is_null($current)) { $html .= div($this->migration->error_string(), 'alert-box error'); } else { $html .= div('Klubb database version: ' . $current, 'alert-box success'); } $tables = $this->db->list_tables(); foreach ($tables as $table) { $fields = $this->db->list_fields($table); array_unshift($fields, strong('Fält:')); $fields = ul($fields, array('class' => 'inline-list')); $html .= div(heading('Tabell: ' . $table, 4) . $fields, 'radius panel'); } $data['html'] = $html; $this->system_model->view('template', $data); }
function index() { $this->rapyd->load('dataform'); $filter = new dataForm('buscador/index/procesar'); $filter->valor = new inputField('Valor', 'valor'); $filter->valor->rule = 'required'; $filter->valor->size = 20; $filter->submit('btnsubmit', 'Buscar'); $filter->build_form(); $sal = ''; if ($filter->on_success()) { $this->load->library('table'); $this->table->set_heading('Tabla', 'Campo', 'Coincidencias'); $valor = $this->db->escape($filter->valor->newValue); $tables = $this->db->list_tables(); foreach ($tables as $table) { $fields = $this->db->list_fields($table); foreach ($fields as $field) { $mSQL = "SELECT COUNT(*) AS cana FROM `{$table}` WHERE `" . $field . "` = {$valor}"; $cana = $this->datasis->dameval($mSQL); if ($cana > 0) { $this->table->add_row($table, $field, $cana); } } } $sal = $this->table->generate(); } $data['content'] = $filter->output . $sal; $data['title'] = heading('Busca un valor en toda la base de datos'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('dataform', 'datagrid'); $this->load->library('encrypt'); $filter = new DataForm('ejecutasql/filteredgrid/process'); $filter->sql = new textareaField('', 'sql'); $filter->sql->cols = 90; $filter->sql->rows = 9; $filter->sql->rule = 'required'; $filter->submit('btnsubmit', 'Ejecutar'); $filter->build_form(); $salida = ''; if ($filter->on_success()) { $data = array(); $mSQL = $filter->sql->value; $link = @mysql_connect($this->db->hostname, $this->db->username, $this->db->password) or die('Error de coneccion'); mysql_select_db($this->db->database, $link) or die('Base de datos no seleccionable'); $result = mysql_query($mSQL, $link); if (!$result) { $salida = mysql_errno($link) . ": " . mysql_error($link); } else { if (is_resource($result)) { $num_rows = mysql_num_rows($result); $afectados = 0; } elseif (is_bool($result)) { $num_rows = 0; $afectados = mysql_affected_rows(); } else { $num_rows = 0; $afectados = 0; } if ($num_rows > 0) { $colunas = mysql_num_fields($result); while ($row = mysql_fetch_assoc($result)) { $data[] = $row; } $grid = new DataGrid("Filas : {$num_rows}, Columnas : {$colunas} ,Afectados :{$afectados}", $data); $grid->per_page = 100000; foreach ($data[0] as $campos => $value) { $grid->column($campos, $campos); } $grid->build(); $salida = $grid->output; if (stristr($mSQL, 'SELECT')) { $mSQL2 = $this->encrypt->encode($mSQL); $salida .= "<form action='/../../proteoerp/xlsauto/repoauto2/'; method='post'>\n \t\t\t\t\t\t<input size='100' type='hidden' name='mSQL' value='{$mSQL2}'>\n \t\t\t\t\t\t<input type='submit' value='Descargar a Excel' name='boton'/>\n \t\t\t\t\t\t</form>"; } } elseif ($afectados > 0) { $salida = "Filas afectadas {$afectados}"; } else { $salida = 'Esta consulta no genero resultados'; } } } $data['content'] = $filter->output . $salida; $data['title'] = heading('Consulta SQL'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function heading_nb_level2($l1tag, $l1url, $l2tag, $l2url) { global $site, $siteuri; echo "<a href='{$siteuri}'>"; heading($site . " < " . $l1tag . " < " . $l2tag); nb_top(); nb_level2($l1tag, $l1url, $l2tag, $l2url); }
function print_logr() { global $env, $logr; if ($env == 'test') { heading('Log'); print_r($logr); } }
function index() { $this->rapyd->load('dataform', 'datatable', 'datagrid'); $this->load->library('table'); $base_process_uri = $this->rapyd->uri->implode_uri("base_uri", "gfid", "orderby"); $filter = new DataForm($this->rapyd->uri->add_clause($base_process_uri, "search")); $filter->title('Elija una tabla'); $filter->attributes = array('onsubmit' => 'is_loaded()'); $filter->tabla = new dropdownField("Tabla", "tabla"); $filter->tabla->option("pers", "Personal"); $filter->tabla->option("nomina", "Nomina"); $filter->tabla->option("sprv", "Proveedores"); $filter->tabla->option("abonotros", "Abono Otros"); $filter->tabla->clause = ""; //$filter->obra = new dropdownField("Obra", "depto"); //$filter->obra->db_name='depto'; //$filter->obra->clause="where"; //$filter->obra->option(" ","Todos"); //$filter->obra->options("SELECT depto, descrip FROM dpto ORDER BY depto "); //$filter->obra->operator="="; //$filter->status = new dropdownField("Status","status"); //$filter->status->option("","Todos"); //$filter->status->option("A","Activos"); //$filter->status->option("I","Inactivos"); //$filter->status->style='width:100px'; $filter->submit('btnsubmit', 'Descargar'); $filter->build_form(); if ($this->rapyd->uri->is_set("search")) { $table = $filter->tabla->newValue; $mSQL = "DESCRIBE {$table}"; $query = $this->db->query($mSQL); if ($query->num_rows() > 0) { foreach ($query->result_array() as $row) { $data[] = $row; } } function ractivo($field) { $data2 = array('name' => 'campos[]', 'id' => 'c' . $field, 'value' => $field, 'checked' => FALSE, 'style' => 'margin:5px'); $retorna = form_checkbox($data2); return $retorna; } $grid = new DataGrid("Resultados", $data); $grid->use_function('ractivo', 'ucwords'); $grid->column('Campos', '<ucwords><#Field#></ucwords>'); $grid->column('Mostrar', "<ractivo><#Field#></ractivo>", 'align="center"'); $grid->build(); $tabla = $grid->output; $filter->build_form(); $conten = $filter->output . form_open("nomina/rpers/crear/{$table}") . $tabla . form_submit('mysubmit', 'Generar') . form_close(); } else { $conten = $filter->output; } $data['content'] = $conten; $data['title'] = heading('Reporte'); $data["head"] = script("jquery.js") . $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $data = array(); $data['header'] = ''; $data['content'] = $this->load->view('view_verificador', $data, true); $data['footer'] = ''; $data['script'] = script('jquery-min.js'); $data['script'] .= phpscript('nformat.js'); $data['script'] .= script('jquery.bootgrid.min.js'); $data['style'] = style('jquery.bootgrid.min.css'); $data['panel'] = ''; $data['title'] = heading('Verificador de precios'); $this->load->view('view_ventanasjq', $data); /* // Filter grid $this->rapyd->load('datafilter','datagrid'); $filter = new DataFilter('Consulta de Precios', 'sinv'); $filter->Descripcion = new inputField('Descripcion','decrip'); $filter->clave->rule ='max_length[50]'; $filter->clave->size =7; $filter->clave->maxlength =5; $filter->marca = new inputField('Marca','marca'); $filter->marca->rule ='max_length[30]'; $filter->marca->size =32; $filter->marca->maxlength =30; $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor($this->url.'dataedit/show/<raencode><#id#></raencode>','<#id#>'); $grid = new DataGrid(''); $grid->db->select('codigo', 'descrip','unidad','base1','precio1-base1 iva','precio1'); $grid->db->order_by('codigo'); $grid->db->order_by('codigo'); $grid->per_page = 40; $grid->column_orderby('Código' ,'codigo' ,'codigo', 'align="left"'); $grid->column_orderby('Descripcion' ,'nombre' ,'descrip', 'align="left"'); $grid->column_orderby('Medida' ,'unidad' ,'unidad', 'align="left"'); $grid->column_orderby('Precio' ,'base1' ,'base1', 'align="right"'); $grid->column_orderby('I.V.A.' ,'iva' ,'iva', 'align="right"'); $grid->column_orderby('Precio de Venta' ,'precio1' ,'precio1', 'align="right"'); $grid->add($this->url.'dataedit/create'); $grid->build(); $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head().script('jquery.min.js'); $data['title'] = heading($this->titp); $this->load->view('view_ventanas', $data); */ }
public function testFindSchedules() { heading('findSchedules'); $data = SchedulesData::findSchedules(array()); $this->assertNotEqual($data, false); heading('Find disabled schedules'); $data = SchedulesData::findSchedules(array('s.enabled' => 0)); $this->assertNotEqual($data, false); }
public function test_heading_object_attributes() { // Test array of attributes $this->assertEquals('<h2 class="bar" id="foo">foobar</h2>', heading('foobar', 2, array('class' => 'bar', 'id' => 'foo'))); $test = new stdClass(); $test->class = "bar"; $test->id = "foo"; $this->assertEquals('<h2 class="bar" id="foo">foobar</h2>', heading('foobar', 2, $test)); }
function motd() { $motd = join('', file(MOTD_FILE)); $stat = stat(MOTD_FILE); $mtime = $stat['mtime']; if ($mtime > time() - 60 * 60 * 24 * 7 and trim($motd)) { return heading(2, "Message of the Day") . "<blockquote>" . wiki_render(date('M d, Y @ H:i', $mtime) . "\n\n" . $motd) . "</blockquote>"; } }
/** * index function. * * @access public * @return void */ public function index() { $this->output->enable_profiler(false); $this->benchmark->mark('auth_start'); if (!$this->auth->loggedin()) { redirect('user/login'); } $uid = intval($this->auth->userid()); $this->benchmark->mark('auth_end'); $user = $this->user_model->get_user($uid); $greeting = ''; if (isset($user['firstname'])) { $greeting = ' ' . $user['firstname']; $data['firstname'] = $user['firstname']; } else { $greeting = ' ' . $user['username']; $data['firstname'] = $user['firstname']; } $data['title'] = $this->system_model->get('app_name'); $data['stylesheets'] = array('buttons_purple'); $data['partial'] = 'home'; $data['org_name'] = $this->system_model->get('org_name'); $data['app_name'] = $this->system_model->get('app_name'); $data['members'] = $this->member_model->count_members(); $data['users'] = $this->user_model->count_users(); $memberdata = heading(ucfirst(lang('members')), 5); $ofeachtype = array(); $this->benchmark->mark('members_process_start'); foreach ($this->member_model->get_types() as $type) { $count = $this->member_model->count_members_type($type['id']); array_push($ofeachtype, $count . ' ' . strtolower($type['plural'])); } $data['membertypes'] = $ofeachtype; $memberdata .= p(ucfirst($data['org_name']) . ' har totalt ' . anchor('members', $data['members'] . ' ' . lang('members')) . ' varav:'); $memberdata .= ul($data['membertypes'], array('class' => 'disc')); $memberdata .= button_group(array(button_anchor('members', ucfirst(lang('administer')) . ' ' . lang('members'), 'radius'), button_anchor('member/register', ucfirst(lang('register_member')), 'radius')), 'radius'); $this->benchmark->mark('members_process_end'); $userdata = heading(ucfirst(lang('users')), 5); $this->benchmark->mark('users_process_start'); $userdata .= p(ucfirst($data['app_name']) . ' har totalt ' . anchor('admin/users', $data['users'] . ' ' . lang('users')) . '.'); $active = $this->user_model->get_active(); $ausers = array(); foreach ($active as $aid) { $auser = $this->user_model->get_user($aid); array_push($ausers, $auser['firstname'] . ' ' . $auser['lastname']); } $data['loggedon'] = $ausers; $userdata .= heading(ucfirst(lang('currently_logged_on')) . ':', 6) . ul($ausers, array('class' => 'disc')); $userdata .= button_group(array(button_anchor('admin/users', ucfirst(lang('administer')) . ' ' . lang('users'), 'radius'), button_anchor('user/create', ucfirst(lang('create_user')), 'radius')), 'radius'); $this->benchmark->mark('users_process_end'); $content = heading(ucfirst(lang('welcome')) . $greeting . '!', 1); $content .= row(columns($memberdata, 6) . columns($userdata, 6)); $html = $content; $data['html'] = $html; $this->system_model->view('template', $data); }
function index() { $this->rapyd->load('datatable', 'dataform'); $form = new DataForm('supermercado/cargahisto/index/process'); $form->title('Este modulo permite cargar manual las ventas sacadas de los historicos de las cajas'); $form->fecha = new dateonlyField('Fecha', 'fecha', 'd/m/Y'); $form->fecha->db_format = 'Ymd'; $form->fecha->insertValue = date('Y-m-d'); $form->fecha->size = 11; $form->fecha->autocomplete = false; $form->fecha->rule = 'required|chfecha'; $form->hf = new uploadField('Facturas (<b>hf</b>YYYYMMCCCAAA.dbf)', 'hf'); $form->hf->upload_path = 'tmp'; $form->hf->upload_root = '/'; $form->hf->rule = 'required'; $form->hf->allowed_types = 'csv|dbf'; $form->hi = new uploadField('Artículos (<b>hi</b>YYYYMMCCCAAA.dbf)', 'hi'); $form->hi->upload_path = 'tmp'; $form->hi->upload_root = '/'; $form->hi->rule = 'required'; $form->hi->allowed_types = 'csv|dbf'; $form->hs = new uploadField('Pagos (<b>hs</b>YYYYMMCCCAAA.dbf)', 'hs'); $form->hs->upload_path = 'tmp'; $form->hs->upload_root = '/'; $form->hs->rule = 'required'; $form->hs->allowed_types = 'csv|dbf'; $form->submit('btnsubmit', 'Procesar'); $form->build_form(); if ($form->on_success()) { $fecha = $form->fecha->newValue; $encab = false; if (!empty($form->hf->upload_data['full_path'])) { if (substr($form->hf->upload_data['file_name'], 0, 2) == 'hf') { $encab = true; $this->_cargadbf($form->hf->upload_data['full_path'], $fecha); unlink($form->hf->upload_data['full_path']); } else { $form->error = 'Encabezado primero'; $form->build_form(); } } if (!empty($form->hi->upload_data['full_path']) && $encab) { $this->_cargadbf($form->hi->upload_data['full_path'], $fecha); unlink($form->hi->upload_data['full_path']); } if (!empty($form->hs->upload_data['full_path']) && $encab) { $this->_cargadbf($form->hs->upload_data['full_path'], $fecha); unlink($form->hs->upload_data['full_path']); } } $data['content'] = $form->output; $data['title'] = heading('Cargar ventas de los históricos de cajas'); $data['script'] = script('jquery-1.2.6.js'); $data['head'] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function index() { $data = array(); $data['header'] = ''; $data['content'] = $this->load->view('view_lprecios', $data, true); $data['footer'] = ''; $data['script'] = ''; $data['panel'] = ''; $data['title'] = heading('Consulta de precios'); $this->load->view('view_ventanasjqm', $data); }
function index() { $data = array(); $data['header'] = ''; $data['content'] = $this->load->view('view_sfacmovil', $data, true); $data['footer'] = ''; $data['script'] = ''; $data['panel'] = ''; $data['title'] = heading('Pre-factura'); $this->load->view('view_ventanasjqm', $data); }
function index() { $this->rapyd->load('dataform'); $this->rapyd->load('datagrid2'); $this->load->library('encrypt'); function dif($a, $b) { return number_format($a - $b, 2, ',', '.'); } $form = new DataForm('supermercado/conciliacion/index/process'); $form->fechad = new dateonlyField('Desde', 'fechad', 'd/m/Y'); $form->fechad->insertValue = date('Y-m-d', mktime(0, 0, 0, date("m"), date("d") - 30, date("Y"))); $form->fechad->rule = 'required'; $form->fechah = new dateonlyField('Hasta', 'fechah', 'd/m/Y'); $form->fechah->insertValue = date('Y-m-d'); $form->fechah->rule = 'required'; $form->submit('btnsubmit', 'Buscar'); $form->build_form(); $tabla = ''; if ($form->on_success()) { $fechad = $form->fechad->newValue; $fechah = $form->fechah->newValue; //$mSQL="SELECT 'PV' ,caja,SUM(gtotal*IF(MID(numero,1,2)='NC',-1,1)) FROM viefac WHERE fecha BETWEEN '$fechad' AND '$fechah' GROUP BY caja UNION //SELECT 'PV' ,'MAYO',SUM(gtotal*IF(tipo='D',-1,1)) FROM fmay WHERE fecha BETWEEN '$fechad' AND '$fechah' UNION //SELECT 'CZ' ,caja,SUM(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) FROM fiscalz WHERE fecha BETWEEN '$fechad' AND '$fechah' GROUP BY caja"; $mSQL = "SELECT a.fecha, a.caja, sum(a.gtotal*if(MID(a.numero,1,2)='NC',-1,1)) AS factura,\n\t\t\t(SELECT sum(exento+base+iva-ncexento-ncbase-nciva) venta FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=a.caja ) AS cierrez,\n\t\t\t(SELECT sum(exento+base+iva-ncexento-ncbase-nciva) venta FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=a.caja )-\n\t\t\tsum(a.gtotal*if(MID(a.numero,1,2)='NC',-1,1)) AS dife\n\t\t\tFROM viefac a\n\t\t\tWHERE a.fecha BETWEEN '{$fechad}' AND '{$fechah}' GROUP BY a.fecha, a.caja ORDER BY a.caja,a.fecha"; $grid = new DataGrid2('Resúmen'); $grid->db->_escape_char = ''; $grid->db->_protect_identifiers = false; //$grid->per_page = 20; $grid->use_function('dif'); $select = array('a.fecha', 'b.caja', '(SELECT sum(exento+base+iva+base1+iva1+base2+iva2-ncexento-ncbase-nciva-ncbase1-nciva1-ncbase2-nciva2) FROM fiscalz c WHERE c.fecha=a.fecha AND c.caja=b.caja) AS cierrez', '(SELECT sum(d.gtotal) FROM viefac AS d WHERE d.fecha=a.fecha AND d.caja=b.caja) AS factura'); $grid->db->select($select); $grid->db->from('tiempo AS a'); $grid->db->join("caja AS b", "a.fecha BETWEEN '{$fechad}' AND '{$fechah}'"); $grid->db->orderby("caja,fecha"); $grid->db->having("cierrez IS NOT null OR factura IS NOT null"); $grid->column("Fecha", "<dbdate_to_human><#fecha#></dbdate_to_human>", "align='center'"); $grid->column("Caja", "caja", 'align=center'); $grid->column("Factura", "<nformat><#factura#></nformat>", 'align=right'); $grid->column("Cierre Z", "<nformat><#cierrez#></nformat>", 'align=right'); $grid->column("Diferencia", "<dif><#factura#>|<#cierrez#></dif>", 'align=right'); $grid->totalizar('factura', 'cierrez'); $grid->build(); //echo $grid->db->last_query(); $tabla = $grid->output; } $reporte = anchor('reportes/ver/CONCILIACI', 'Imprimir'); $data['content'] = $form->output . $reporte . $tabla; $data["head"] = script("jquery.pack.js") . script("plugins/jquery.numeric.pack.js") . script("plugins/jquery.floatnumber.js") . $this->rapyd->get_head(); $data['title'] = heading('Concialiaciones de Cierre Z'); $this->load->view('view_ventanas', $data); }
function filteredgrid() { $this->rapyd->load('datafilter', 'datagrid'); $filter = new DataFilter($this->titp); $filter->db->from('caudi AS a'); $filter->db->join('usuario AS b', 'a.uscaja = b.us_codigo'); $filter->caja = new dropdownField('Caja', 'caja'); $filter->caja->style = 'width:200px'; $filter->caja->option('', 'Todos'); $filter->caja->options("SELECT codbanc,CONCAT_WS('-',codbanc,banco) AS val FROM banc WHERE tbanco = 'CAJ' ORDER BY banco"); $filter->uscaja = new dropdownField('Responsable', 'uscaja'); $filter->uscaja->style = 'width:200px'; $filter->uscaja->option('', 'Todos'); $filter->uscaja->options("SELECT us_codigo,us_nombre FROM usuario ORDER BY us_nombre"); $filter->status = new dropdownField('Estatus', 'status'); $filter->status->style = 'width:200px'; $filter->status->option('', 'Todos'); $filter->status->option('P', 'Pendientes'); $filter->status->option('A', 'Anulados'); $filter->status->option('C', 'Cerrados'); $filter->observa = new inputField('Observación', 'observa'); $filter->buttons('reset', 'search'); $filter->build(); $uri = anchor($this->url . '/auditoria/<raencode><#caja#></raencode>', '<str_pad><#id#>|10|0|0</str_pad>'); function status($sto) { if ($sto == 'P') { return 'Pendiente'; } elseif ($sto == 'A') { return 'Anulado'; } else { return 'Cerrado'; } } $grid = new DataGrid(''); $grid->use_function('str_pad', 'status'); $grid->order_by('id'); $grid->per_page = 40; $grid->column_orderby('Número', $uri, 'id', 'align="left"'); $grid->column_orderby('Caja', 'caja', 'caja', 'align="left"'); $grid->column_orderby('Responsable', '<#uscaja#>-<#us_nombre#>', 'uscaja', 'align="left"'); $grid->column_orderby('Estatus', '<status><#status#></status>', 'status', 'align="left"'); $grid->column_orderby('Saldo', '<nformat><#saldo#></nformat>', 'saldo', 'align="right"'); $grid->column_orderby('Monto', '<nformat><#monto#></nformat>', 'monto', 'align="right"'); $grid->column_orderby('Diferencia', '<nformat><#diferencia#></nformat>', 'diferencia', 'align="right"'); $grid->add($this->url . '/agregar'); $grid->build(); $data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $data['title'] = heading($this->titp); $this->load->view('view_ventanas', $data); }
function filteredgrid($barras = '', $farmacia = '') { $this->rapyd->load('datafilter', 'datagrid'); $modbus = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'Código', 'barras' => 'Barras', 'descrip' => 'Descripción', 'precio1' => 'Precio 1', 'precio2' => 'Precio 2', 'precio3' => 'Precio 3', 'precio4' => 'Precio 4'), 'filtro' => array('codigo' => 'Código', 'barras' => 'Barras', 'descrip' => 'Descripción'), 'retornar' => array('barras' => 'barras'), 'titulo' => 'Buscar en inventario', 'dbgroup' => 'consolidado'); $boton = $this->datasis->modbus($modbus); $barrase = $this->db->escape($barras); $sql = "\n\t\tSELECT fecha,fe,fa,descrip,venta,compras,saldo,semanal FROM (\n\t\tselect '' fe,farmacia fa,fecha,farmacia,descrip,venta,compras,saldo,(venta/4) semanal\n\t\tfrom vieventascompras \n\t\twhere barras={$barrase} AND farmacia is not null\n\t\tUNION ALL\n\t\tselect '','',fecha,farmacia,'TOTALES',SUM(venta),SUM(compras),SUM(saldo),(venta/4) semanal \n\t\tfrom vieventascompras \n\t\twhere barras={$barrase} AND farmacia is not null\n\t\tGROUP BY fecha with rollup\n\t\tUNION ALL\n\t\tselect CONCAT(MID(fecha,1,4),'-',MID(fecha,5,5)) fe,'',fecha,farmacia,'','','','','' \n\t\tfrom vieventascompras \n\t\twhere barras={$barrase} AND farmacia is not null\n\t\tGROUP BY fecha \n\t\t)todo\n\t\tORDER BY fecha is null,fecha ,fe='',descrip='TOTALES',farmacia\n\t\t"; $atts = array('width' => '800', 'height' => '600', 'scrollbars' => 'yes', 'status' => 'yes', 'resizable' => 'yes', 'screenx' => '0', 'screeny' => '0'); $descrip = $this->datasis->dameval("SELECT descrip FROM sinv WHERE barras={$barrase} LIMIT 10 "); $uri = anchor_popup($this->url . "kardex/{$barras}/<#fa#>/<#fecha#>", '<#fa#>', $atts); $sql = $this->db->query($sql); $sql = $sql->result_array(); function negrita($descrip, $fecha = NULL) { if ($descrip == 'TOTALES' && !(strlen($fecha) > 0)) { return "<span style='font-size:1.5em'><strong>TOTAL GENERAL</strong></span>"; } elseif ($descrip == 'TOTALES') { return "<span style='font-size:1.2em'><strong>TOTALES</strong></span>"; } else { return $descrip; } } function negrita2($descrip, $monto) { if ($descrip == 'TOTALES') { return "<span style='font-size:1.2em'><strong>" . nformat($monto) . "</strong></span>"; } elseif (strlen($monto) > 0) { return nformat($monto); } else { return ''; } } $grid = new DataGrid(anchor($this->url . 'viewinventario', 'Ir al Inventario por sucursales'), $sql); $grid->db->_escape_char = ''; $grid->db->_protect_identifiers = false; $grid->use_function('negrita', 'negrita2'); //$grid->column_orderby('Barras' ,$uri ,'align="left"' ); $grid->column('Año/Mes', "fe", 'align="center"'); $grid->column('Farmacia', $uri, 'align="left"'); $grid->column('Descripción', "<negrita><#descrip#>|<#fecha#></negrita>", 'align="left"'); $grid->column('Mensual', "<negrita2><#descrip#>|<#venta#></negrita2>", 'align="right"'); $grid->column('Semanal', "<negrita2><#descrip#>|<#semanal#></negrita2>", 'align="right"'); $grid->column('Compras', "<negrita2><#descrip#>|<#compras#></negrita2>", 'align="right"'); $grid->column('Saldo', "<negrita2><#descrip#>|<#saldo#></negrita2>", 'align="right"'); $grid->build(); //echo $grid->db->last_query(); //$data['filtro'] = $filter->output; $data['content'] = $grid->output; $data['head'] = $this->rapyd->get_head() . script('jquery.js'); $data['title'] = heading($descrip); $this->load->view('view_ventanas', $data); }
function anuales() { $this->rapyd->load('datagrid2'); $this->rapyd->load('dataform'); $this->load->helper('openflash'); if ($this->uri->segment(4)) { $anio = $this->uri->segment(4); } elseif (isset($_POST['anio'])) { $anio = $_POST['anio']; } if (empty($anio)) { $anio = date("Y"); } $fechai = $anio . '0101'; $fechaf = $anio . '1231'; $filter = new DataForm('compras/proveedores/anuales'); $filter->title('Filtro de compras Anuales'); $filter->anio = new inputField('Año', 'anio'); $filter->anio->size = 4; $filter->anio->insertValue = $anio; $filter->anio->rule = 'max_length[4]'; $filter->button('btnsubmit', 'Buscar', form2uri(site_url('compras/proveedores/anuales'), array('anio')), $position = "BL"); $filter->build_form(); $grid = new DataGrid2(); $select = array('proveed', 'fecha', 'nombre', "SUM(montonet*IF(tipo_doc!='FC',-1,1)) AS grantotal", 'MONTH(fecha) AS mes', "SUM(inicial*IF( tipo_doc!='FC',-1,1)) AS contado", "SUM(credito*IF( tipo_doc!='FC',-1,1)) AS credito", "SUM(montotot*IF(tipo_doc!='FC',-1,1)) AS subtotal", "SUM(montoiva*IF(tipo_doc!='FC',-1,1)) AS impuesto", 'COUNT(*) AS numfac'); $grid->db->select($select); $grid->db->from('scst'); $grid->db->where('tipo_doc <>', 'NE'); $grid->db->where('fecha >= ', $fechai); $grid->db->where('fecha <= ', $fechaf); $grid->db->where('actuali >= fecha'); $grid->db->groupby('proveed'); $grid->db->orderby('grantotal DESC'); $grid->per_page = 15; //$grid->db->limit(15,0); $grid->column('Proveedor', 'nombre', 'align=\'left\''); $grid->column('Sub-Total', '<nformat><#subtotal#>|2</nformat>', 'align=\'right\''); $grid->column('Impuesto', '<nformat><#impuesto#>|2</nformat>', 'align=\'right\''); $grid->column('Total', '<nformat><#grantotal#>|2</nformat>', 'align=\'right\''); $grid->column('Contado', '<nformat><#contado#>|2</nformat>', 'align=\'right\''); $grid->column('Credito', '<nformat><#credito#>|2</nformat>', 'align=\'right\''); $grid->column('Cant. Fact', 'numfac', 'align=\'right\''); $grid->totalizar('impuesto', 'grantotal', 'contado', 'credito', 'subtotal'); $grid->build(); $grafico = open_flash_chart_object(700, 450, site_url("compras/proveedores/ganuales/{$anio}/")); $data['content'] = $grafico; $data['content'] .= $filter->output . $grid->output; $data['head'] = $this->rapyd->get_head(); $data['title'] = heading('Compras Anuales'); $this->load->view('view_ventanas', $data); }
public function index() { $data["title"] = heading("List of Product", 3); $data["products"] = $this->Products_model->showAllProducts(); $this->load->view("view_products", $data); //var_dump($data->result_array()); //$data2->ProductsName; //$x ='<ol>'; //foreach ($data->result() as $row){ // $x .='<li>' .$row->ProductName. '</li>'; //} //$x .= '</ol>'; //echo $x; }
public function check_email() { if ($this->input->post('recovery_submit')) { $email = $this->input->post('reset_email'); //echo $email; $this->load->model('forget_password_model'); $info = $this->forget_password_model->exist_email($email); if (count($info) != 0) { //echo "here"; $this->load->helper('html'); $this->load->library('email'); $this->load->library('session'); $newdata = array('email' => $email); $this->session->set_userdata($newdata); //$this->session->set_userdata($email); //$config['protocol'] = 'mail';$this->email->initialize($config); $tmp_password = $this->forget_password_model->update_tmp_password($email); //echo $tmp_password; $config = array('protocol' => 'smtp', 'smtp_host' => 'ssl://orange.whitelabelwebserver.com', 'smtp_port' => 465, 'smtp_user' => '*****@*****.**', 'smtp_pass' => 'Q^F{ke_&xk(}', 'mailtype' => 'html', 'charset' => 'iso-8859-1'); $this->load->library('email', $config); $this->email->set_newline("\r\n"); $this->email->from('*****@*****.**', 'admin'); $this->email->to($email); $base = $this->config->base_url(); $message = heading('Your Email:'); $message .= $email; $message .= br(2); $message .= heading('Password Recovery Link:'); $message .= "<a href='" . $base . "index.php/forget/getlink/" . $tmp_password . "'>Click Here</a>"; $message .= br(2); $message .= "Thank You"; //$message="<a href='fsdkfjdsfjsdfjdsf'>sdfsdfsdf</a>"; $this->email->subject('Password Recovery'); $this->email->message($message); $this->email->set_mailtype("html"); $this->email->send(); // echo "<script>alert('Please check your email to update your password');</script>"; echo $this->email->print_debugger(); //redirect('welcome','refresh'); // echo "<script> // alert('Please check your email to update your password'); // window.location.href='welcome'; // </script>"; } else { //echo ""; echo "<script>\n\t\t\t\talert('Email not registered yet!!!');\n\t\t\t\twindow.location.href='welcome';\n\t\t\t\t</script>"; } } }
/** * Index Page for this controller. * * Maps to the following URL * http://example.com/index.php/welcome * - or - * http://example.com/index.php/welcome/index * - or - * Since this controller is set as the default controller in * config/routes.php, it's displayed at http://example.com/ * * So any other public methods not prefixed with an underscore will * map to /index.php/welcome/<method_name> * @see http://codeigniter.com/user_guide/general/urls.html */ public function index() { /*//$this->load->view('welcome_message'); echo "<h3>List Categories</h3>"; $data = $this->Categories_model->getAlldata(); //var_dump($data); $vdata = "<ol>"; foreach ($data as $row) { $vdata .="<li>".$row->CategoryName."</li>"; } $vdata .="</ol>"; echo $vdata;*/ $data['judul'] = heading("List Categories", 3); $data['categories'] = $this->Categories_model->getAlldata(); $this->load->view('view_categories', $data); }
function displayDivision() { $this->data['thetable'] = ""; $orderBy = $this->session->userdata('orderbyteam'); $conferences = $this->teams->getGroups('Conference'); $this->data['thetable'] .= heading("Divisions", 2, 'class=""'); foreach ($conferences as $conference) { $this->data['thetable'] .= heading($conference->Conference, 3, 'class="ConferenceHeading shadow"'); $divisions = $this->teams->getGroups('Division'); foreach ($divisions as $division) { if ($division->Conference == $conference->Conference) { $this->data['thetable'] .= heading($division->Division, 4, 'class="divisionHeading shadow"'); $this->data['thetable'] .= $this->createTable($this->teams->some('Division', $division->Division, $orderBy)); } } } }
/** * index function. * * @access public * @return void */ public function index() { $this->output->enable_profiler(false); if (!$this->auth->loggedin()) { redirect('user/login'); } $data['title'] = $this->system_model->get('app_name'); $html = row(columns(heading(ucfirst(lang('about')) . ' ' . $this->system_model->get('app_name'), 1), 12)); $uptime_array = explode(" ", exec("cat /proc/uptime")); $seconds = round($uptime_array[0], 0); $minutes = $seconds / 60; $hours = $minutes / 60; $days = floor($hours / 24); $hours = sprintf('%02d', floor($hours - $days * 24)); $minutes = sprintf('%02d', floor($minutes - $days * 24 * 60 - $hours * 60)); if ($days == 0) { $uptime = $hours . ":" . $minutes; } elseif ($days == 1) { $uptime = $days . " " . lang('day') . ", " . $hours . ":" . $minutes; } else { $uptime = $days . " " . lang('days') . ", " . $hours . ":" . $minutes; } $infolist = ul(array(heading('Applikation', 5) . ul(array(strong('Klubb-' . lang('version') . ': ') . KLUBB_VERSION, strong('CodeIgniter-' . lang('version') . ': ') . CI_VERSION, strong(ucfirst(lang('database')) . ': ') . $this->db->platform() . ', ' . lang('version') . ': ' . $this->db->version(), strong(ucfirst(lang('environment') . ': ')) . lang(ENVIRONMENT))), heading('Server', 5) . ul(array(strong('Namn: ') . php_uname('n'), strong('System: ') . php_uname('s') . ' ' . php_uname('r') . ' ' . php_uname('v') . ' ' . php_uname('m'), strong('Upptid: ') . $uptime, strong('PHP-version: ') . phpversion(), strong('PHP-moduler: ') . implode(', ', get_loaded_extensions())))), array('class' => 'no-bullet')); $html .= row(columns($infolist)); $data['breadcrumbs'] = array(array('data' => anchor('/', $this->system_model->get('app_name')), 'mode' => 'unavailable'), array('data' => anchor('about', ucfirst(lang('about') . ' ' . $data['title'])), 'mode' => 'current')); $data['html'] = $html; $this->system_model->view('template', $data); }