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