コード例 #1
0
ファイル: callcenter.php プロジェクト: codethics/proteoerp
 function dataedit($sta, $id)
 {
     $this->rapyd->load('dataedit', 'datagrid');
     $edit = new DataEdit('Ficha del cliente', 'scli');
     $edit->back_url = site_url($this->url . 'filteredgrid');
     $edit->cliente = new inputField('Cliente', 'cliente');
     $edit->cliente->rule = 'trim|required|existesprv';
     $edit->cliente->maxlength = 5;
     $edit->cliente->size = 7;
     $edit->cliente->mode = 'autohide';
     $edit->nombre = new inputField('Nombre', 'nombre');
     $edit->nombre->rule = 'trim';
     $edit->nombre->maxlength = 40;
     $edit->nombre->size = 40;
     $edit->nombre->mode = 'autohide';
     $edit->nombre->in = 'cliente';
     $edit->rifci = new inputField('RIF/CI', 'rifci');
     $edit->rifci->rule = 'trim';
     $edit->rifci->maxlength = 40;
     $edit->rifci->size = 40;
     $edit->rifci->mode = 'autohide';
     $edit->telefono = new inputField('Teléfono', 'telefono');
     $edit->telefono->rule = 'trim';
     $edit->telefono->maxlength = 40;
     $edit->telefono->size = 40;
     $edit->telefono->mode = 'autohide';
     $edit->buttons('undo', 'back');
     $edit->build();
     $data['content'] = $edit->output;
     $crm = $edit->_dataobject->get('crm');
     if (empty($crm)) {
         $dbdata['usuario'] = $this->secu->usuario();
         $dbdata['status'] = 'A';
         $dbdata['fecha'] = date('Ymd');
         $dbdata['titulo'] = 'Callcenter';
         $dbdata['cliente'] = $edit->_dataobject->get('cliente');
         $dbdata['descripcion'] = '';
         $mSQL = $this->db->insert_string('crm_contenedor', $dbdata);
         $this->db->simple_query($mSQL);
         $crm = $this->db->insert_id();
         $mSQL = "UPDATE scli SET crm = {$crm} WHERE id={$id}";
         $this->db->simple_query($mSQL);
     }
     $this->crm_back = site_url("crm/callcenter/dataedit/{$sta}/{$id}");
     $adici = array($edit->_dataobject->pk['id']);
     $this->prefijo = 'crm_';
     $data['content'] .= Contenedor::_showAdjuntos($crm, 'crm/callcenter/adjuntos', $adici);
     $data['content'] .= Contenedor::_showEventos($crm, 'crm/callcenter/eventos', $adici);
     $data['content'] .= Contenedor::_showComentarios($crm, 'crm/callcenter/comentarios', $adici);
     $data['style'] = style('redmond/jquery-ui.css');
     $data['script'] = script('jquery.js');
     $data['script'] .= script('jquery-ui.js');
     $data['script'] .= script('plugins/jquery.floatnumber.js');
     $data['script'] .= script('plugins/jquery.numeric.pack.js');
     $data['script'] .= script('plugins/jquery.ui.autocomplete.autoSelectOne.js');
     $data['script'] .= phpscript('nformat.js');
     $data['head'] = $this->rapyd->get_head();
     $data['title'] = heading('Callcenter');
     $this->load->view('view_ventanas', $data);
 }
コード例 #2
0
ファイル: index.php プロジェクト: Rubentxu/PtuitBundle
<?php

require_once 'php/Contenedor.php';
$contenedor = new Contenedor();
$contenedor->iniciar();
コード例 #3
0
ファイル: ordi.php プロジェクト: codethics/proteoerp
 function dataedit()
 {
     $this->rapyd->load('dataobject', 'datadetails');
     $monedalocal = 'Bs';
     $modbus = array('tabla' => 'sinv', 'columnas' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripci&oacute;n'), 'filtro' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripci&oacute;n'), 'retornar' => array('codigo' => 'codigo_<#i#>', 'descrip' => 'descrip_<#i#>'), 'p_uri' => array(4 => '<#i#>'), 'titulo' => 'Buscar Producto en inventario', 'script' => array('post_sinv_modbus("<#i#>")'));
     $btn = $this->datasis->p_modbus($modbus, '<#i#>');
     $sprv = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;digo Proveedor', 'nombre' => 'Nombre', 'rif' => 'RIF'), 'filtro' => array('proveed' => 'C&oacute;digo Proveedor', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'proveed', 'nombre' => 'nombre'), 'titulo' => 'Buscar Proveedor', 'where' => 'tipo IN (3,4)', 'script' => array('post_sprv_modbus()'));
     $boton = $this->datasis->modbus($sprv);
     $aran = array('tabla' => 'aran', 'columnas' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripci&oacute;n', 'tarifa' => 'Tarifas'), 'filtro' => array('codigo' => 'C&oacute;digo', 'descrip' => 'Descripci&oacute;n'), 'retornar' => array('codigo' => 'codaran_<#i#>', 'tarifa' => 'arancel_<#i#>'), 'p_uri' => array(4 => '<#i#>'), 'titulo' => 'Buscar Aranceles', 'script' => array('aranpresis(<#i#>)'));
     $aran = $this->datasis->p_modbus($aran, '<#i#>');
     $asprv = array('tabla' => 'sprv', 'columnas' => array('proveed' => 'C&oacute;digo Proveedor', 'nombre' => 'Nombre', 'rif' => 'RIF'), 'filtro' => array('proveed' => 'C&oacute;digo Proveedor', 'nombre' => 'Nombre'), 'retornar' => array('proveed' => 'agente', 'nombre' => 'nomage'), 'titulo' => 'Buscar Proveedor', 'script' => array('post_sprv_modbus()'));
     $aboton = $this->datasis->modbus($asprv, 'agsprv');
     $script = "\n\t\tfunction post_add_itstra(id){\n\t\t\t\$('#cantidad_'+id).numeric(" . ");\n\t\t\treturn true;\n\t\t}\n\t\tfunction formato(row) {\n\t\t\treturn row[0] + " - " + row[1];\n\t\t}";
     $do = new DataObject('ordi');
     $do->rel_one_to_many('itordi', 'itordi', 'numero');
     $edit = new DataDetails('ordi', $do);
     $_status = $do->get('status');
     $_control = $do->get('control');
     if ($_status == 'C') {
         $dbcontrol = $this->db->escape($_control);
         $scstcana = $this->datasis->dameval('SELECT COUNT(*) FROM scst WHERE tipo_doc<>\'XX\' AND control=' . $dbcontrol);
         if (empty($scstcana)) {
             $_id = $do->get('id');
             $this->db->simple_query('UPDATE ordi SET status="A", control=NULL WHERE id=' . $_id);
             $do->set('control', '');
             $do->set('status', 'A');
         }
     }
     $edit->back_url = site_url('import/ordi/filteredgrid');
     $edit->set_rel_title('itstra', 'Producto <#o#>');
     $edit->script($script, 'create');
     $edit->script($script, 'modify');
     $edit->pre_process('insert', '_pre_insert');
     $edit->pre_process('delete', '_pre_delete');
     $edit->post_process('insert', '_post_insert');
     $edit->post_process('update', '_post_update');
     $edit->post_process('delete', '_post_delete');
     $edit->numero = new inputField('N&uacute;mero', 'numero');
     $edit->numero->mode = 'autohide';
     $edit->numero->size = 10;
     //$edit->numero->apply_rules=false; //necesario cuando el campo es clave y no se pide al usuario
     $edit->numero->when = array('show', 'modify');
     $edit->dua = new inputField('Declaraci&oacute;n &uacute;nica de aduana', 'dua');
     $edit->dua->size = 10;
     $edit->fecha = new dateonlyField('Fecha de Factura', 'fecha');
     $edit->fecha->insertValue = date('Y-m-d');
     $edit->fecha->maxlength = 8;
     $edit->fecha->size = 10;
     /*$edit->status = new dropdownField('Estatus', 'status');
     		$edit->status->option('A','Abierto');
     		$edit->status->option('C','Cerrado');
     		$edit->status->option('E','Eliminado');
     		$edit->status->rule  = 'required';
     		$edit->status->style = 'width:120px';*/
     $edit->proveed = new inputField('Proveedor', 'proveed');
     $edit->proveed->rule = 'trim|required|existesprv';
     $edit->proveed->maxlength = 5;
     $edit->proveed->size = 7;
     $edit->proveed->append($boton);
     $edit->nombre = new inputField('Nombre', 'nombre');
     $edit->nombre->rule = 'trim';
     $edit->nombre->maxlength = 40;
     $edit->nombre->size = 40;
     $edit->nombre->type = 'inputhidden';
     $edit->agente = new inputField('Agente aduanal', 'agente');
     $edit->agente->rule = 'trim|existesprv|required';
     $edit->agente->maxlength = 5;
     $edit->agente->size = 7;
     $edit->agente->append($aboton);
     $edit->nomage = new inputField('Nombre de agente', 'nomage');
     $edit->nomage->rule = 'trim';
     $edit->nomage->maxlength = 40;
     $edit->nomage->size = 40;
     $edit->nomage->type = 'inputhidden';
     $arr = array('montofob' => 'Total factura extranjera $');
     foreach ($arr as $obj => $etiq) {
         $edit->{$obj} = new inputField($etiq, $obj);
         $edit->{$obj}->rule = 'trim';
         $edit->{$obj}->maxlength = 20;
         $edit->{$obj}->size = 10;
         $edit->{$obj}->css_class = 'inputnum';
         $edit->{$obj}->autocomplete = false;
         $edit->{$obj}->showformat = 'decimal';
         $edit->{$obj}->type = 'inputhidden';
     }
     $arr = array('gastosi' => 'Gastos Internacionales $', 'montocif' => 'Monto FOB+gastos Internacionales $', 'gastosn' => 'Gastos Nacionales ' . $monedalocal, 'montotot' => 'Monto CIF + Gastos Nacionales ' . $monedalocal, 'montoiva' => 'Monto del iva ' . $monedalocal);
     foreach ($arr as $obj => $etiq) {
         $edit->{$obj} = new inputField($etiq, $obj);
         $edit->{$obj}->rule = 'trim';
         $edit->{$obj}->maxlength = 20;
         $edit->{$obj}->size = 10;
         $edit->{$obj}->css_class = 'inputnum';
         $edit->{$obj}->autocomplete = false;
         $edit->{$obj}->showformat = 'decimal';
         $edit->{$obj}->when = array('show');
     }
     $edit->arribo = new dateonlyField('Fecha de Llegada', 'arribo');
     $edit->arribo->rule = 'chfecha';
     $edit->arribo->maxlength = 8;
     $edit->arribo->size = 10;
     $edit->factura = new inputField('Nro. Factura', 'factura');
     $edit->factura->rule = 'trim';
     $edit->factura->maxlength = 20;
     $edit->factura->size = 10;
     $edit->factura->autocomplete = false;
     $edit->cambioofi = new inputField('Cambio Oficial', 'cambioofi');
     $edit->cambioofi->css_class = 'inputnum';
     $edit->cambioofi->rule = 'trim|required';
     $edit->cambioofi->maxlength = 17;
     $edit->cambioofi->size = 10;
     $edit->cambioofi->autocomplete = false;
     $edit->cambioofi->insertValue = 6.3;
     $edit->cambioofi->showformat = 'decimal';
     $edit->cambioreal = new inputField('Cambio Real', 'cambioreal');
     $edit->cambioreal->css_class = 'inputnum';
     $edit->cambioreal->rule = 'trim|required';
     $edit->cambioreal->maxlength = 17;
     $edit->cambioreal->size = 10;
     $edit->cambioreal->autocomplete = false;
     $edit->cambioreal->showformat = 'decimal';
     $edit->peso = new inputField('Peso Total', 'peso');
     $edit->peso->css_class = 'inputnum';
     $edit->peso->rule = 'trim';
     $edit->peso->maxlength = 12;
     $edit->peso->size = 10;
     $edit->peso->showformat = 'decimal';
     $edit->peso->when = array('show');
     $edit->condicion = new textareaField('Condiciones', 'condicion');
     $edit->condicion->rule = 'trim';
     $edit->condicion->cols = 37;
     $edit->condicion->rows = 3;
     $edit->estimadif = new inputField('Diferencia en estimaci&oacute;n', 'estimadif');
     $edit->estimadif->css_class = 'inputnum';
     $edit->estimadif->maxlength = 12;
     $edit->estimadif->size = 10;
     $edit->estimadif->showformat = 'decimal';
     $edit->estimadif->when = array('show');
     //*********************
     //comienza el detalle
     //*********************
     $edit->codigo = new inputField('C&oacute;digo <#o#>', 'codigo_<#i#>');
     $edit->codigo->db_name = 'codigo';
     $edit->codigo->rule = 'trim|required|existesinv';
     $edit->codigo->rel_id = 'itordi';
     $edit->codigo->maxlength = 15;
     $edit->codigo->size = 10;
     $edit->codigo->append($btn);
     $edit->codigo->autocomplete = false;
     $edit->descrip = new inputField('Descripci&oacute;n <#o#>', 'descrip_<#i#>');
     $edit->descrip->db_name = 'descrip';
     $edit->descrip->rel_id = 'itordi';
     $edit->descrip->maxlength = 35;
     $edit->descrip->size = 30;
     $edit->descrip->autocomplete = false;
     $edit->descrip->type = 'inputhidden';
     $edit->cantidad = new inputField('Cantidad <#o#>', 'cantidad_<#i#>');
     $edit->cantidad->db_name = 'cantidad';
     $edit->cantidad->css_class = 'inputnum';
     $edit->cantidad->rel_id = 'itordi';
     $edit->cantidad->rule = 'numeric|mayorcero|required';
     $edit->cantidad->maxlength = 10;
     $edit->cantidad->size = 7;
     $edit->cantidad->autocomplete = false;
     $edit->cantidad->showformat = 'decimal';
     $arr = array('costofob' => 'costofob', 'importefob' => 'importefob');
     foreach ($arr as $obj => $db) {
         $edit->{$obj} = new inputField(ucfirst("{$obj} <#o#>"), "{$obj}_<#i#>");
         $edit->{$obj}->db_name = $db;
         $edit->{$obj}->css_class = 'inputnum';
         $edit->{$obj}->rel_id = 'itordi';
         $edit->{$obj}->rule = 'trim|mayorcero|required';
         $edit->{$obj}->maxlength = 20;
         $edit->{$obj}->size = 10;
         $edit->{$obj}->autocomplete = false;
         $edit->{$obj}->showformat = 'decimal';
         if ($obj == 'importefob') {
             $edit->{$obj}->type = 'inputhidden';
         }
     }
     $edit->codaran = new inputField('Codaran <#o#>', 'codaran_<#i#>');
     $edit->codaran->db_name = 'codaran';
     $edit->codaran->rel_id = 'itordi';
     $edit->codaran->rule = 'trim|required';
     $edit->codaran->maxlength = 15;
     $edit->codaran->size = 10;
     //$edit->codaran->readonly = true;
     $edit->codaran->append($aran);
     $edit->arancel = new inputField('arancel <#o#>', 'arancel_<#i#>');
     $edit->arancel->db_name = 'arancel';
     $edit->arancel->css_class = 'inputnum';
     $edit->arancel->rel_id = 'itordi';
     $edit->arancel->rule = 'trim';
     $edit->arancel->maxlength = 7;
     $edit->arancel->size = 5;
     $edit->arancel->readonly = true;
     $edit->arancel->autocomplete = false;
     $edit->arancel->showformat = 'decimal';
     $edit->arancel->type = 'inputhidden';
     //Termina el detalle
     $edit->ordeni = new autoUpdateField('status', 'A', 'A');
     $stat = $edit->_dataobject->get('status');
     if ($stat != 'C') {
         $accion = "javascript:window.location='" . site_url('import/ordi/cargarordi/' . $edit->_dataobject->pk['numero']) . "'";
         $edit->button_status('btn_cargar', 'Cargar', $accion, 'BR', 'show');
         $action = "javascript:window.location='" . site_url('import/ordi/calcula/' . $edit->_dataobject->pk['numero']) . "'";
         $edit->button_status('btn_recalculo', 'Calcular valores', $action, 'BR', 'show');
         $action = "javascript:window.location='" . site_url('import/ordi/arancif/' . $edit->_dataobject->pk['numero']) . "'";
         $edit->button_status('btn_arancif', 'Reajustar los aranceles', $action, 'BR', 'show');
         $edit->buttons('modify', 'save', 'delete', 'add_rel');
     } else {
         $id = $edit->get_from_dataobjetct('numero');
         $this->db->where('ordeni', $id);
         $this->db->from('ordiestima');
         if ($this->db->count_all_results() > 0) {
             $accion = "javascript:window.location='" . site_url('import/ordi/gserestima' . $edit->pk_URI()) . "'";
             $edit->button_status('btn_ginpo', 'Agregar gasto real', $accion, 'BR', 'show');
         }
     }
     $accion = "javascript:window.location='" . site_url('import/limport/liqui/' . $edit->_dataobject->pk['numero']) . "'";
     $edit->button_status('btn_liqui', 'Descargar Caldeco', $accion, 'BR', 'show');
     $accion = "javascript:window.location='" . site_url('formatos/ver/ORDI' . $edit->pk_URI()) . "'";
     $edit->button_status('btn_imprime', 'Imprimir', $accion, 'BR', 'show');
     $edit->buttons('undo', 'back');
     $edit->build();
     $auto_aran = site_url('import/ordi/autocomplete/codaran');
     //$this->rapyd->jquery[]='$(".inputnum").numeric(".");';
     if ($edit->_status == 'show') {
         $conten['peroles'][] = $this->_showgeri($edit->_dataobject->pk['numero'], $stat);
         $conten['peroles'][] = $this->_showgeser($edit->_dataobject->pk['numero'], $stat);
         $conten['peroles'][] = $this->_showordiva($edit->_dataobject->pk['numero'], $stat);
         //$conten['peroles'][] = $this->_showordiestima($edit->_dataobject->pk['numero'],$stat);
         $crm = $edit->_dataobject->get('crm');
         if (!empty($crm)) {
             $adici = array($edit->_dataobject->pk['numero']);
             $this->prefijo = 'crm_';
             $conten['peroles'][] = Contenedor::_showAdjuntos($crm, 'import/ordi/adjuntos', $adici);
             $conten['peroles'][] = Contenedor::_showEventos($crm, 'import/ordi/eventos', $adici);
             $conten['peroles'][] = Contenedor::_showComentarios($crm, 'import/ordi/comentarios', $adici);
         }
     }
     $conten['form'] =& $edit;
     $data['content'] = $this->load->view('view_ordi', $conten, true);
     $data['style'] = style('redmond/jquery-ui.css');
     $data['script'] = script('jquery.js');
     $data['script'] .= script('jquery-ui.js');
     $data['script'] .= script('plugins/jquery.floatnumber.js');
     $data['script'] .= script('plugins/jquery.numeric.pack.js');
     $data['script'] .= script('plugins/jquery.ui.autocomplete.autoSelectOne.js');
     $data['script'] .= phpscript('nformat.js');
     $data['head'] = $this->rapyd->get_head();
     $data['title'] = heading('Importaciones');
     $this->load->view('view_ventanas', $data);
 }