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);
}
