function masivo() { $this->rapyd->uri->keep_persistence(); $sql = $this->input->post('sql'); $cantidad = $this->input->post('cantidad'); $msj = "</br>Usted esta modificando {$cantidad} Registros"; $this->rapyd->load("dataform"); $edit = new DataForm($this->url . "masivo/process"); //$edit->post_process('insert','_post_insert'); //$edit->post_process('update','_post_update'); //$edit->post_process('delete','_post_delete'); $mNOCO = array('tabla' => 'noco', 'columnas' => array('codigo' => 'Código de Sucursal', 'nombre' => 'Nombre'), 'filtro' => array('codigo' => 'Código', 'nombre' => 'Nombre'), 'retornar' => array('codigo' => 'contrato'), 'titulo' => 'Buscar Contratos', 'where' => 'tipo <> "O"'); $bNOCO = $this->datasis->modbus($mNOCO); $edit->sql = new hiddenField("", "sql"); $edit->sql->value = $sql; $edit->cantidad = new hiddenField("", "cantidad"); $edit->cantidad->value = $cantidad; $edit->contrato = new inputField("Contrato", "contrato"); $edit->contrato->size = 4; $edit->contrato->maxlength = 5; $edit->contrato->readonly = true; $edit->contrato->group = "Relación Laboral"; $edit->contrato->append($bNOCO); $edit->m_contrato = new checkboxField('', 'm_contrato', 'Y', 'N'); $edit->m_contrato->insertValue = 'N'; $edit->m_contrato->in = 'contrato'; $edit->m_contrato->append("Modificar"); $edit->codigoadm = new dropdownField("Estructura Administrativa", "codigoadm"); $edit->codigoadm->option("", ""); $edit->codigoadm->options("SELECT b.codigo, CONCAT_WS(' ',b.codigo,b.denominacion) AS val FROM presupuesto AS a JOIN estruadm AS b ON a.codigoadm=b.codigo GROUP BY b.codigo"); $edit->codigoadm->group = "Relación Laboral"; $edit->m_codigoadm = new checkboxField('', 'm_codigoadm', 'Y', 'N'); $edit->m_codigoadm->insertValue = 'N'; $edit->m_codigoadm->in = 'codigoadm'; $edit->m_codigoadm->append("Modificar"); $edit->codigopres = new inputField("Partida", "codigopres"); $edit->codigopres->size = 20; $edit->codigopres->group = "Relación Laboral"; $edit->m_codigopres = new checkboxField('', 'm_codigopres', 'Y', 'N'); $edit->m_codigopres->insertValue = 'N'; $edit->m_codigopres->in = 'codigopres'; $edit->m_codigopres->append("Modificar"); $edit->m_codigopres->group = "Relación Laboral"; $edit->fondo = new dropdownField("Fondo", "fondo"); $edit->fondo->style = "width:300px;"; $edit->fondo->group = "Relación Laboral"; $edit->fondo->option("", ""); $edit->fondo->options("SELECT tipo,tipo n FROM presupuesto GROUP BY tipo"); $edit->m_fondo = new checkboxField('', 'm_fondo', 'Y', 'N'); $edit->m_fondo->insertValue = 'N'; $edit->m_fondo->in = 'fondo'; $edit->m_fondo->append("Modificar"); $edit->divi = new dropdownField("División", "divi"); $edit->divi->style = "width:250px;"; $edit->divi->option("", ""); $edit->divi->options("SELECT division,CONCAT_WS(' ',division,descrip)des FROM divi ORDER BY division"); $edit->divi->group = "Relación Laboral"; $edit->m_divi = new checkboxField('', 'm_divi', 'Y', 'N'); $edit->m_divi->insertValue = 'N'; $edit->m_divi->in = 'divi'; $edit->m_divi->append("Modificar"); $edit->status = new dropdownField("Estatus", "status"); $edit->status->option("", ""); $edit->status->options(array("A" => "Activo", "V" => "Vacaciones", "R" => "Retirado")); $edit->status->group = "Relación Laboral"; $edit->status->style = "width:100px;"; $edit->m_status = new checkboxField('', 'm_status', 'Y', 'N'); $edit->m_status->insertValue = 'N'; $edit->m_status->in = 'status'; $edit->m_status->append("Modificar"); $edit->tipemp = new dropdownField("Condicion", "tipemp"); $edit->tipemp->style = "width:100px;"; $edit->tipemp->option("", ""); $edit->tipemp->option("F", "Fijo"); $edit->tipemp->option("C", "Contratado"); $edit->tipemp->option("J", "Jubilado"); $edit->tipemp->option("P", "Pensionado"); $edit->tipemp->option("A", "Alto Nivel y Direccion"); $edit->tipemp->option("E", "Eleccion Popular"); $edit->tipemp->group = "Relación Laboral"; $edit->m_tipemp = new checkboxField('', 'm_tipemp', 'Y', 'N'); $edit->m_tipemp->insertValue = 'N'; $edit->m_tipemp->in = 'tipemp'; $edit->m_tipemp->append("Modificar"); $edit->m_tipemp->group = "Relación Laboral"; $edit->vari1 = new inputField($this->datasis->traevalor("VARI1") . "XVARI1", "vari1"); $edit->vari1->group = "Variables"; $edit->vari1->size = 16; $edit->vari1->maxlength = 14; $edit->vari1->rule = "trim"; $edit->vari1->css_class = 'inputnum'; $edit->m_vari1 = new checkboxField('', 'm_vari1', 'Y', 'N'); $edit->m_vari1->insertValue = 'N'; $edit->m_vari1->in = 'vari1'; $edit->m_vari1->append("Modificar"); $edit->vari2 = new inputField($this->datasis->traevalor("VARI2") . "XVARI2", "vari2"); $edit->vari2->group = "Variables"; $edit->vari2->size = 16; $edit->vari2->maxlength = 14; $edit->vari2->rule = "trim"; $edit->vari2->css_class = 'inputnum'; $edit->m_vari2 = new checkboxField('', 'm_vari2', 'Y', 'N'); $edit->m_vari2->insertValue = 'N'; $edit->m_vari2->in = 'vari2'; $edit->m_vari2->append("Modificar"); $edit->vari3 = new inputField($this->datasis->traevalor("VARI3") . "XVARI3", "vari3"); $edit->vari3->group = "Variables"; $edit->vari3->size = 16; $edit->vari3->maxlength = 14; $edit->vari3->rule = "trim"; $edit->vari3->css_class = 'inputnum'; $edit->m_vari3 = new checkboxField('', 'm_vari3', 'Y', 'N'); $edit->m_vari3->insertValue = 'N'; $edit->m_vari3->in = 'vari3'; $edit->m_vari3->append("Modificar"); $edit->vari4 = new inputField($this->datasis->traevalor("VARI4") . "XVARI4", "vari4"); $edit->vari4->group = "Variables"; $edit->vari4->size = 12; $edit->vari4->maxlength = 11; $edit->vari4->rule = "trim"; $edit->vari4->css_class = 'inputnum'; $edit->m_vari4 = new checkboxField('', 'm_vari4', 'Y', 'N'); $edit->m_vari4->insertValue = 'N'; $edit->m_vari4->in = 'vari4'; $edit->m_vari4->append("Modificar"); $edit->vari5 = new inputField($this->datasis->traevalor("VARI5") . "XVARI5", "vari5"); $edit->vari5->group = "Variables"; $edit->vari5->size = 12; $edit->vari5->maxlength = 12; $edit->vari5->rule = "trim"; $edit->m_vari5 = new checkboxField('', 'm_vari5', 'Y', 'N'); $edit->m_vari5->insertValue = 'N'; $edit->m_vari5->in = 'vari5'; $edit->m_vari5->append("Modificar"); $edit->vari6 = new inputField($this->datasis->traevalor("VARI6") . "XVARI6", "vari6"); $edit->vari6->group = "Variables"; $edit->vari6->size = 16; $edit->vari6->maxlength = 14; $edit->vari6->rule = "trim"; $edit->vari6->css_class = 'inputnum'; $edit->m_vari6 = new checkboxField('', 'm_vari6', 'Y', 'N'); $edit->m_vari6->insertValue = 'N'; $edit->m_vari6->in = 'vari6'; $edit->m_vari6->append("Modificar"); $edit->vari7 = new inputField($this->datasis->traevalor("VARI7") . "XVARI7", "vari7"); $edit->vari7->group = "Variables"; $edit->vari7->size = 16; $edit->vari7->maxlength = 14; $edit->vari7->rule = "trim"; $edit->m_vari7 = new checkboxField('', 'm_vari7', 'Y', 'N'); $edit->m_vari7->insertValue = 'N'; $edit->m_vari7->in = 'vari7'; $edit->m_vari7->append("Modificar"); $edit->vari8 = new inputField($this->datasis->traevalor("VARI8") . "XVARI8", "vari8"); $edit->vari8->group = "Variables"; $edit->vari8->size = 16; $edit->vari8->maxlength = 14; $edit->vari8->rule = "trim"; $edit->m_vari8 = new checkboxField('', 'm_vari8', 'Y', 'N'); $edit->m_vari8->insertValue = 'N'; $edit->m_vari8->in = 'vari8'; $edit->m_vari8->append("Modificar"); $edit->sueldo = new inputField("Sueldo ", "sueldo"); $edit->sueldo->group = "Relación Laboral"; $edit->sueldo->size = 15; $edit->sueldo->maxlength = 10; $edit->sueldo->css_class = '.inputnum'; $edit->m_sueldo = new checkboxField('', 'm_sueldo', 'Y', 'N'); $edit->m_sueldo->insertValue = 'N'; $edit->m_sueldo->in = 'sueldo'; $edit->m_sueldo->append("Modificar"); $edit->submit("btnsubmit", "Guardar"); $edit->build_form(); if ($edit->on_show()) { //do something } if ($edit->on_success()) { $data = array(); $sql = $this->input->post('sql'); $campos = array('m_contrato', 'm_codigoadm', 'm_fondo', 'm_divi', 'm_status', 'm_sueldo', 'm_vari1', 'm_vari2', 'm_vari3', 'm_vari4', 'm_vari5', 'm_vari6', 'm_vari7', 'm_vari8', 'm_codigopres', 'm_tipemp'); foreach ($campos as $campo) { if ($this->input->post($campo) == 'Y') { $data[substr($campo, 2)] = $this->input->post(substr($campo, 2)); } } $sql = substr($sql, 0, strpos($sql, 'LIMIT')); $query = $this->db->query($sql); $query = $query->result_array(); $codigos = array(); foreach ($query as $row) { //echo $row['codigo'].br(); $codigos[] = $this->db->escape($row['codigo']); } $codigos = implode($codigos, ','); if (count($data) > 0) { $where = "codigo IN ({$codigos})"; $query = $this->db->update_string('pers', $data, $where); if ($this->db->query($query)) { $msj .= "</br>Usted ha modificado satisfacrotiamente {$cantidad} de registros"; } } } if ($edit->on_error()) { //do something else (display suggestions.. etc) //note: validation messages are integrated, so you don't have to do anything (just make fields rules). } $atras = anchor($this->url . 'filteredgrid', 'Ir al Filtro'); $data['content'] = $atras . $msj . $edit->output; $data['title'] = "Modificar Personal Masivo"; $data["head"] = $this->rapyd->get_head(); $this->load->view('view_ventanas', $data); }
function datapar() { $this->rapyd->load('dataform'); $this->genesal = false; $script = ' function totaliza(){ var preca = Number($("#ttpreca_0").val()); var preca2 = Number($("#ttpreca_1").val()); var thora = $("#horaentrada").val(); var iva = Number($("#ttiva").val()); var t = thora.split(":"); var d = new Date(); var total = 0; var hentra = Number(t[0]); var mentra = Number(t[1]); var mmentr = hentra*60+mentra; var hactual = d.getHours(); var mactual = d.getMinutes(); var mmactua = hactual*60+mactual; var diff = mmactua-mmentr; var cana = Math.floor(diff/60); var dminu= diff-cana*60 //var cana = hactual-hentra; var fraci= 0; //var dminu = mactual- mentra; if(dminu >0 && dminu <=30){ fraci = 1; }else if(dminu > 30){ cana = cana+1; } if(cana ==0 && fraci ==1){ cana = 1; fraci= 0; } $("#ttcana_0").val(cana); $("#ttcana_1").val(fraci); total = total+(cana*preca); total = total+(fraci*preca2); $("#total").text(nformat(total*(1+(iva/100)),2)); } function tarifa(){ buscapreca(); totaliza(); } function buscapreca(){ var codigo = $("#ttcodigoa_0").val(); var tarifa = JSON.parse($.ajax({ type: "POST", url: "' . site_url('ajax/buscaprecio1') . '/", data: {q : codigo} ,dataType: "json",async: false }).responseText); $("#ttpreca_0").val(tarifa[0]); $("#ttpreca_1").val(tarifa[1]); $("#ttiva").val(tarifa[2]); } $(function() { $("#horaentrada").mask("99:99"); $("#horaentrada").keyup(function(e) { totaliza(); }); //$("#horaentrada").timepicker({ // timeFormat: "hh:mm", // onClose: function(dateText, inst){ // totaliza(); // }, // onSelect: function(selectedDateTime){ // tarifa(); // } //}); tarifa(); //tab enter $("#placa,#ttcodigoa_0,#ttcana_0,#ttcana_1,#ttpreca_0,#ttpreca_1").keydown( function(e) { var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0; if(key == 13) { e.preventDefault(); var inputs = $(this).closest("form").find(":input:visible").not("#ttcodigoa_0,#ttcana_0,#ttcana_1,#ttpreca_0,#ttpreca_1"); inputs.eq(inputs.index(this)+1).focus(); } }); $("#horaentrada,#ttcodigoa_0,#ttcana_0,#ttcana_1,#ttpreca_0,#ttpreca_1").keydown( function(e) { var key = e.charCode ? e.charCode : e.keyCode ? e.keyCode : 0; if(key == 13) { $(":button:contains(\'Guardar\')").click(); } }); }); '; $tisize = '1.6'; $form = new DataForm($this->url . 'datapar/insert'); $form->script($script); $form->placa = new inputField('<span style="font-size:' . $tisize . 'em">Placa</span>', 'placa'); $form->placa->rule = 'trim|strtoupper|max_length[20]|callback_chplaca'; $form->placa->size = 10; $form->placa->maxlength = 7; $form->placa->style = 'font-size: 3em;font-weight:bold;'; $form->placa->tabindex = '1'; $form->horaentrada = new inputField('<span style="font-size:' . $tisize . 'em">Hora de entrada</span>', 'horaentrada'); $form->horaentrada->rule = 'required|hora'; $form->horaentrada->tabindex = '2'; $form->horaentrada->size = 10; $form->horaentrada->maxlength = 5; $form->horaentrada->style = 'font-size: 3em;font-weight:bold;'; $form->horaentrada->insertValue = date('H:i', mktime(date('H') - 1, date('i'))); $form->cana = new inputField('Cantidad', 'ttcana_0'); $form->cana->rule = 'required|numeric'; $form->cana->size = 4; $form->cana->css_class = 'inputnum'; $form->cana->onkeyup = 'tarifa()'; $form->cana->maxlength = 5; $form->cana2 = new inputField('fraccion', 'ttcana_1'); $form->cana2->rule = 'required|numeric'; $form->cana2->size = 3; $form->cana2->css_class = 'inputnum'; $form->cana2->in = 'cana'; $form->cana2->onkeyup = 'tarifa()'; $form->cana2->maxlength = 5; $form->cana2->tabindex = '3'; $form->codigo = new dropdownField('<span style="font-size:' . $tisize . 'em">Tipo vehículo</span>', 'ttcodigoa_0'); //$form->codigo->option('','Seleccionar'); $form->codigo->options('SELECT codigo,CONCAT_WS("-",descrip,precio1) AS val FROM sinv WHERE clave LIKE "TARIFA%" AND tipo="Servicio"'); $form->codigo->style = 'width:140px;'; $form->codigo->onchange = 'tarifa()'; $form->codigo->rule = 'required'; $form->preca = new inputField('Tarifa', 'ttpreca_0'); $form->preca->rule = 'required|mayorcero'; $form->preca->size = 5; $form->preca->maxlength = 7; $form->preca2 = new inputField('fraccion', 'ttpreca_1'); $form->preca2->rule = 'required|mayorcero'; $form->preca2->size = 5; $form->preca2->maxlength = 5; $form->preca2->in = 'preca'; $form->iva = new hiddenField('', 'ttiva'); $form->iva->rule = 'required|mayorcero'; $form->iva->in = 'preca'; $form->total = new freeField('<span style="font-size:' . $tisize . 'em">Monto a pagar</span>', 'total', '<span style="font-size:3em;" id="total">0,00</span>'); $form->build_form(); if ($form->on_success()) { $monto = 0; $placa = trim($form->placa->newValue); $cana = $form->cana->newValue; $cana2 = $form->cana2->newValue; $preca = $form->preca->newValue; $preca2 = $form->preca2->newValue; $codigo = $form->codigo->newValue; $sinvr = $this->datasis->damereg("SELECT descrip,iva,tipo FROM sinv WHERE codigo = " . $this->db->escape($codigo)); //Encabezado $_POST['pfac'] = ''; $_POST['fecha'] = date('d/m/Y'); $_POST['cajero'] = $this->secu->getcajero(); $_POST['vd'] = $this->secu->getvendedor(); $_POST['almacen'] = $this->secu->getalmacen(); $_POST['tipo_doc'] = 'F'; $_POST['factura'] = ''; $_POST['cod_cli'] = 'CONTA'; $_POST['sclitipo'] = '1'; $_POST['nombre'] = 'CLIENTE CONTADO'; $_POST['rifci'] = 'V000000'; $_POST['direc'] = ''; unset($_POST['iva']); //Items $id = 0; if ($cana > 0) { $tota = $cana * $preca; $ind = 'codigoa_' . $id; $_POST[$ind] = $codigo; $ind = 'desca_' . $id; $_POST[$ind] = $sinvr['descrip']; $ind = 'cana_' . $id; $_POST[$ind] = $cana; $ind = 'preca_' . $id; $_POST[$ind] = $preca; $ind = 'tota_' . $id; $_POST[$ind] = $tota; $ind = 'precio1_' . $id; $_POST[$ind] = 0; $ind = 'precio2_' . $id; $_POST[$ind] = 0; $ind = 'precio3_' . $id; $_POST[$ind] = 0; $ind = 'precio4_' . $id; $_POST[$ind] = 0; $ind = 'itiva_' . $id; $_POST[$ind] = round($sinvr['iva'], 2); $ind = 'sinvpeso_' . $id; $_POST[$ind] = 0; $ind = 'sinvtipo_' . $id; $_POST[$ind] = $sinvr['tipo']; $monto += $tota; } else { $ind = 'codigoa_' . $id; unset($_POST[$ind]); $ind = 'desca_' . $id; unset($_POST[$ind]); $ind = 'cana_' . $id; unset($_POST[$ind]); $ind = 'preca_' . $id; unset($_POST[$ind]); $ind = 'tota_' . $id; unset($_POST[$ind]); $ind = 'precio1_' . $id; unset($_POST[$ind]); $ind = 'precio2_' . $id; unset($_POST[$ind]); $ind = 'precio3_' . $id; unset($_POST[$ind]); $ind = 'precio4_' . $id; unset($_POST[$ind]); $ind = 'itiva_' . $id; unset($_POST[$ind]); $ind = 'sinvpeso_' . $id; unset($_POST[$ind]); $ind = 'sinvtipo_' . $id; unset($_POST[$ind]); } $id++; if ($cana2 > 0) { $tota = $cana2 * $preca2; $ind = 'codigoa_' . $id; $_POST[$ind] = $codigo; $ind = 'desca_' . $id; $_POST[$ind] = $sinvr['descrip']; $ind = 'cana_' . $id; $_POST[$ind] = $cana2; $ind = 'preca_' . $id; $_POST[$ind] = $preca2; $ind = 'tota_' . $id; $_POST[$ind] = $tota; $ind = 'precio1_' . $id; $_POST[$ind] = 0; $ind = 'precio2_' . $id; $_POST[$ind] = 0; $ind = 'precio3_' . $id; $_POST[$ind] = 0; $ind = 'precio4_' . $id; $_POST[$ind] = 0; $ind = 'itiva_' . $id; $_POST[$ind] = round($sinvr['iva'], 2); $ind = 'sinvpeso_' . $id; $_POST[$ind] = 0; $ind = 'sinvtipo_' . $id; $_POST[$ind] = $sinvr['tipo']; $monto += $tota; } else { $ind = 'codigoa_' . $id; unset($_POST[$ind]); $ind = 'desca_' . $id; unset($_POST[$ind]); $ind = 'cana_' . $id; unset($_POST[$ind]); $ind = 'preca_' . $id; unset($_POST[$ind]); $ind = 'tota_' . $id; unset($_POST[$ind]); $ind = 'precio1_' . $id; unset($_POST[$ind]); $ind = 'precio2_' . $id; unset($_POST[$ind]); $ind = 'precio3_' . $id; unset($_POST[$ind]); $ind = 'precio4_' . $id; unset($_POST[$ind]); $ind = 'itiva_' . $id; unset($_POST[$ind]); $ind = 'sinvpeso_' . $id; unset($_POST[$ind]); $ind = 'sinvtipo_' . $id; unset($_POST[$ind]); } if (!empty($placa)) { if (isset($_POST['codigoa_1'])) { $ind = 'detalle_1'; $_POST[$ind] = 'ESTACIONAMIENTO PLACA ' . $placa; } else { $ind = 'detalle_0'; $_POST[$ind] = 'ESTACIONAMIENTO PLACA ' . $placa; } } //Forma de pago $_POST['tipo_0'] = 'EF'; $_POST['sfpafecha_0'] = ''; $_POST['num_ref_0'] = ''; $_POST['banco_0'] = ''; $_POST['monto_0'] = $monto * (1 + $sinvr['iva'] / 100); if ($monto <= 0) { $rt = array('status' => 'B', 'mensaje' => 'Monto cero', 'pk' => null); echo json_encode($rt); } ob_start(); parent::dataedit(); $rt = ob_get_contents(); @ob_end_clean(); echo $rt; } else { echo $form->output; } if ($form->on_error()) { } }
function dataform() { //dataform// $this->rapyd->load("dataform"); $form = new DataForm("rapyd/datam/dataform/process", null); $form->title = new inputField("Title", "title"); $form->title->rule = "trim|required|max_length[20]"; $form->body = new editorField("Body", "body"); $form->body->rule = "required"; $form->body->rows = 10; $form->checkbox = new checkboxField("Public", "public", "y", "n"); $form->submit("btnsubmit", "SUBMIT"); $form->build_form(); if ($form->on_show()) { $data["form_status"] = "Form displayed correctly"; } if ($form->on_success()) { $posted_data = nl2br(var_export($_POST, true)); $data["form_status"] = "Successful post:<br/>" . $posted_data; } if ($form->on_error()) { $data["form_status"] = "There are errors"; } $data["form"] = $form->output; //enddataform// $content["content"] = $this->load->view('rapyd/dataform', $data, true); $content["rapyd_head"] = $this->rapyd->get_head(); $content["code"] = highlight_code_file(THISFILE, "//dataform//", "//enddataform//"); $this->load->view('rapyd/template', $content); }
function cobrorep($id) { $id = intval($id); if ($id <= 0) { return false; } $tipo = $this->datasis->dameval("SELECT tipo FROM reparto WHERE id={$id}"); if ($tipo != 'F' && $tipo != 'C' && $tipo != 'E') { echo 'Reparto no se puede cobrar con tipo ' . $tipo; return false; } $this->rapyd->load('dataform'); $edit = new DataForm($this->url . 'cobrorep/' . $id . '/insert'); $edit->monto = new inputField('Monto total recibido', 'monto'); $edit->monto->rule = 'required|numeric'; $edit->monto->type = 'inputhidden'; $edit->monto->insertValue = '0.0'; $edit->monto->css_class = 'inputnum'; $edit->build_form(); if ($edit->on_success()) { $errno = ''; $itpago = $this->input->post('itpago'); if (is_array($itpago)) { $error = 0; foreach ($itpago as $itid => $repcob) { $itid = intval($itid); if ($repcob == 'EF' || $repcob == 'CH' || $repcob == 'MI' || $repcob == 'FP') { $dbrepcob = $this->db->escape($repcob); if ($itid > 0) { $sql = "SELECT a.repcob, c.id AS idcli,a.cod_cli,b.numero,b.tipo_doc,b.fecha,b.monto-b.abonos AS saldo,b.monto\n\t\t\t\t\t\t\t\tFROM sfac AS a\n\t\t\t\t\t\t\t\tJOIN smov AS b ON a.transac=b.transac AND a.numero=b.numero\n\t\t\t\t\t\t\t\tJOIN scli AS c ON a.cod_cli=c.cliente\n\t\t\t\t\t\t\t\tWHERE a.id={$itid}"; $row = $this->datasis->damerow($sql); if (empty($row)) { continue; } if ($row['repcob'] != $repcob) { $mSQL = "UPDATE sfac SET repcob={$dbrepcob}, entregado = NOW() WHERE id={$itid}"; $ban = $this->db->simple_query($mSQL); if (!$ban) { $error++; } } if ($repcob == 'EF') { $chofer = trim($this->datasis->dameval("SELECT b.nombre FROM reparto AS a JOIN chofer AS b ON b.codigo=a.chofer WHERE a.id={$id}")); $_POST = array('cod_cli' => $row['cod_cli'], 'tipo_doc' => 'AB', 'codigo' => '', 'vd' => '', 'fecdoc' => dbdate_to_human(date('y-m-d')), 'tipo_doc_0' => $row['tipo_doc'], 'numero_0' => $row['numero'], 'fecha_0' => dbdate_to_human(date($row['fecha'])), 'monto_0' => $row['monto'], 'abono_0' => $row['saldo'], 'ppago_0' => '', 'monto' => $row['saldo'], 'nroex' => '', 'tipo_0' => 'EF', 'sfpafecha_0' => '', 'num_ref_0' => '', 'banco_0' => '', 'itmonto_0' => $row['saldo'], 'observa1' => 'PAGA ' . $row['tipo_doc'] . $row['numero'] . ' DESDE REPARTO ' . $id . ' ', 'observa2' => 'CHOFER ' . $chofer); $this->genesal = false; ob_start(); $this->ccli($row['idcli']); $rt = ob_get_contents(); @ob_end_clean(); $rt = json_decode($rt); if ($rt->status == 'B') { $error++; $errno = br() . $rt->mensaje; } } } } } if ($error > 0) { $rt = array('status' => 'B', 'mensaje' => 'Problemas guardado ' . $errno, 'pk' => null); } else { $rt = array('status' => 'A', 'mensaje' => 'Cambio exitoso', 'pk' => null); } } else { $rt = array('status' => 'B', 'mensaje' => 'No hubo cambios', 'pk' => null); } echo json_encode($rt); } if ($edit->on_error()) { $rt = array('status' => 'B', 'mensaje' => preg_replace('/<[^>]*>/', '', $edit->error_string), 'pk' => null); echo json_encode($rt); $act = false; return true; } if ($edit->on_show()) { $conten['id'] = $id; $conten['form'] =& $edit; $this->load->view('view_repartocobro', $conten); } }
function tablas() { $this->datasis->modulo_id('900', 1); $this->rapyd->load("dataform", "datatable"); $tables = $this->db->list_tables(); $form = new DataForm("supervisor/mantenimiento/tablas/process"); $form->free = new freeField("Lista de Tablas", "free", "Chequear|Reparar|Optimizar"); foreach ($tables as $tabla) { $che = "chequea_" . $tabla; $re = "repara_" . $tabla; $op = "optimi_" . $tabla; $ob1 = "con_" . $tabla; $ob2 = "con2_" . $tabla; $form->{$che} = new checkboxField("{$tabla}", "{$che}", "CHECK TABLE {$tabla}", "no"); $form->{$ob1} = new containerField("", " "); $form->{$ob1}->in = "{$che}"; $form->{$re} = new checkboxField("", "{$re}", "REPAIR TABLE {$tabla}", "no"); $form->{$re}->in = "{$che}"; $form->{$ob2} = new containerField("", " "); $form->{$ob2}->in = "{$che}"; $form->{$op} = new checkboxField("", "{$op}", "OPTIMIZE TABLE {$tabla}", "no"); $form->{$op}->in = "{$che}"; } $form->submit("btnsubmit", "Aceptar"); $form->build_form(); if ($form->on_show() || $form->on_error()) { $data["content"] = $form->output; } if ($form->on_success()) { $data["content"] = "<h1>Procesos y Consultas generadas</h1><br>"; $atras = anchor('supervisor/mantenimiento/tablas', 'Atras'); //print_R($_POST); foreach ($_POST as $nom => $val) { if ($this->db->simple_query($val)) { $data["content"] .= "Se Proceso:" . $nom . " Con la consulta:(" . $val . ")<br>"; } else { if ($val == "Aceptar") { break; } $data["content"] .= "Error en consulta:" . $val . "<br>"; } } $data["content"] .= $atras; } $data['title'] = "Mantenimiento de tablas"; $data["rapyd_head"] = $this->rapyd->get_head(); $this->load->view("view_ventanas", $data); }