PHP ActiveRecord::insert方法代码示例

 public function GuardarAlbaranes()
 {
     $db = new db();
     $db->connect();
     $C = new ActiveRecord('albaranes');
     $C->fields["fecha"] = $this->fecha;
     $C->fields["operacion"] = $this->operacion;
     $C->fields["guia"] = $this->guia;
     $C->fields["remitente"] = $this->remitente;
     $C->fields["beneficiario"] = $this->beneficiario;
     $C->fields["documento"] = $this->documento;
     $C->fields["pais"] = $this->pais;
     $C->fields["direccion"] = $this->direccion;
     $C->fields["ciudad"] = $this->ciudad;
     $C->fields["telefono"] = $this->telefono;
     $C->fields["descripcion"] = $this->descripcion;
     $C->fields["peso"] = $this->peso;
     $C->fields["comision"] = $this->comision;
     $C->fields["seguro"] = $this->seguro;
     $C->fields["iv"] = $this->iv;
     $C->fields["total"] = $this->total;
     $C->fields["direccion_agencia"] = $this->direccion_agencia;
     $C->insert();
     $db->close();
 }

 public function importToDB()
 {
     $GLOBALS['FORCE_INSERT_ID'] = true;
     $rows = fk_post('rows');
     $Ar = new ActiveRecord($this->tableName);
     $tot_importados = 0;
     if (count($rows) > 0) {
         foreach ($rows as $lineNo) {
             $cols = fk_post('txt_' . $lineNo);
             // Campos importados
             foreach ($cols as $colNo => $colVal) {
                 // procesar reglas
                 $fieldName = fk_post('col-' . $colNo);
                 $colVal = $this->getVal($colVal, $fieldName);
                 if ($fieldName != '') {
                     $Ar->fields[$fieldName] = utf8_decode($colVal);
                     //echo $colVal;
                 }
             }
             // Campos fijos [SOBRE ESCRIBE]
             foreach ($this->fixedC as $fixedColNo => $FixedColVal) {
                 $Ar->fields[$fixedColNo] = $FixedColVal;
             }
             if ($Ar->insert()) {
                 $this->registros_importados++;
             }
         }
         return true;
     } else {
         $this->result_message = 'No se importo ningun registro';
         return false;
     }
 }

 public function CrearPerfilPriv()
 {
     $db = new db();
     $db->connect();
     $C = new ActiveRecord('fk_perfiles_privs');
     $C->fields['id_usuario'] = $this->id_perfil;
     $C->fields['id_priv'] = $this->id_priv;
     $C->fields['access'] = $this->access;
     $C->insert();
     $db->close();
 }

 /**
  *@package AppForm
  *@method createSelectRecords()
  *@desc allows adding records to a select list from appform
  *@since v0.3.4
  **/
 private function createSelectRecords($operation)
 {
     //crear opciones de <select> nuevas
     if ($operation == 'save') {
         foreach ($this->DbRecord->form_fields as $field => $properties) {
             $post_field_name = $this->encode_fields ? encode($field) : $field;
             if ($properties['Type'] == 'select' && fk_post($post_field_name) == 'new') {
                 // if allows adding new
                 if (isset($properties['add_new'])) {
                     //
                     $Ar = new ActiveRecord($properties['add_new']['table_name']);
                     foreach ($properties['add_new']['field'] as $new_field => $new_val) {
                         $Ar->fields[$new_field] = utf8_decode($new_val);
                     }
                     $Ar->insert();
                     $_POST[$post_field_name] = $Ar->inserted_id();
                 }
             }
             // if allows adding new
         }
         // foreach field
     }
     // if save
 }

 private function saveLines()
 {
     $tableId = $this->tableId;
     $total = fk_post($tableId . '_tot');
     for ($i = 1; $i <= $total; $i++) {
         $id_rec = fk_post($tableId . '_recId-' . $i);
         $Ar = new ActiveRecord($this->table_name);
         if ($id_rec > 0) {
             //UPDATE
             //procesar fields to save
             foreach ($this->fields_to_save as $key => $value_from) {
                 $arr_src = array('{table-id}', '{row-id}');
                 $arr_repl = array($tableId . '_', '-' . $i);
                 $value = str_replace($arr_src, $arr_repl, $value_from);
                 $Ar->fields[$key] = fk_post($value);
             }
             $Ar->fields[$this->record_id_name] = $id_rec;
             $Ar->display_queries = true;
             $Ar->update();
         } else {
             //INSERT
             //procesar fields to save
             foreach ($this->fields_to_save as $key => $value_from) {
                 $arr_src = array('{table-id}', '{row-id}');
                 $arr_repl = array($tableId . '_', '-' . $i);
                 $value = str_replace($arr_src, $arr_repl, $value_from);
                 $Ar->fields[$key] = fk_post($value);
             }
             $Ar->insert();
         }
     }
 }

 public static function generarConsecutivo($codigo, $increment = true)
 {
     // GenerarConsecutivo
     $Configsys = new ActiveRecord('config_sys');
     $tot_contador = $Configsys->find_where('config_code = "' . $codigo . '" ');
     if ($tot_contador == 0) {
         // No existe
         $numero_consecutivo = 1;
         if ($increment == true) {
             $Configsys->fields['config_code'] = $codigo;
             $Configsys->fields['config_value'] = $numero_consecutivo;
             $Configsys->insert();
         }
     } else {
         // Si existe
         $numero_consecutivo = $Configsys->fields['config_value'] + 1;
         // INCREMENTA
         if ($increment == true) {
             $Configsys->fields['config_value'] = $numero_consecutivo;
             $numero_consecutivo = $Configsys->fields['config_value'];
             $Configsys->update();
         }
     }
     return $numero_consecutivo;
 }

 protected function insert()
 {
     $this->executePlugins($this, 'before-insert');
     $res = parent::insert();
     $this->executePlugins($this, 'insert');
     $this->executePlugins($this, 'save');
     return $res;
 }