public function __toString()
{
/**
* poa = product options atributes
*/
// echo Kohana::debug(@$_POST);
$opa = new fpp_product_has_attributes_product_Model();
$orm = $opa->db2cls();
$uri = URI::Instance();
$id = (int) $uri->segment("edit");
if (request::method() == 'post' and is_array(@$_POST['opt'])) {
$orm->delete(array('product_id_product' => $id));
foreach ($_POST['opt'] as $key => $value) {
$orm = $opa->db2cls();
$data['product_id_product'] = $id;
// $data['ap_id_attributes_product'] = @$_POST['atr'][$key];
$data['prefix'] = @$_POST['prefix'][$key];
$data['vap_id_values_atributtes_product'] = @$_POST['opt'][$key];
$data['value'] = @$_POST['val'][$key];
$data['extra'] = @$_POST['extra'][$key];
$orm->set_fields($data);
$orm->save();
}
}
$results = $this->GetAttr($id);
// fetch_where(array('product_id_product'=> ) );
$atr_p = new fpp_attributes_product_Model();
$orm_atrp = $atr_p->db2cls();
$attributes = form::dropdown("poa_id", $orm_atrp->select_list('id_attributes_product', 'name_attributes_product'));
$string = View::factory("extras/ajaxattributes")->set("attributes", $attributes)->set("results", $results)->render();
return $string;
}
function detailnews($id)
{
$uri = URI::Instance();
// $id = (int) $uri->segment("detailnews");
// $this->_NoTemplate();
$orm = new fpp_news_Model();
$orm = $orm->db2cls($id);
$title_news = Basic::TransVar("title_news");
$content_news = Basic::TransVar("content_news");
$this->title = $orm->{$title_news};
$this->content = View::factory("main/page")->set("title", __("Eventos", false))->set("content", "<h4>" . $orm->{$title_news} . "</h4>" . $orm->{$content_news})->render();
// $this->content = View::factory("webservices/news_detail")
// ->set("news",$orm)
// ->render();
}
public function blockfields($id = null)
{
$idorigin = $id;
if ($id != null) {
settype($id, 'integer');
}
if ($id === 0 and $idorigin != 'LOOK') {
return NULL;
}
$msg = null;
$types = new fpp_fieldtype_Model($this->meta);
$types->SetPkID($id);
$types->AddAttributes('NameModel', get_class($this));
$types->AddAttributes('Primary', $this->_FirstPrimary);
$fields =& $types->fields;
$this->_apply_php($types);
$arrayWhere = null;
$select = null;
$arrayTables[] = $this->_Table;
$first = null;
$items = $this->show;
$OneToMany = array();
//construccion de qu campos se van a mostrar
if ($items == "AUTO") {
$items = array();
foreach ($this->meta as $fieldname => $props) {
$items[] = $fieldname;
}
}
//cargando las propiedades de cada campo
$OTMSelect = array();
foreach ($items as $fieldname) {
if ($first == null) {
$first = $fieldname;
}
$object = $fields->{$fieldname};
$db_field = "{$this->_Table}.{$fieldname}";
if ($object->typefield != 'OneToMany') {
$select[] = $db_field;
} else {
$OTMSelect[] = $fieldname;
}
$titles[$fieldname] = $this->_File_i18n == null ? $object->verbose : Kohana::lang($this->_File_i18n . '.' . $object->verbose);
$choice[$fieldname] = $object->choices;
}
if ($this->_AddField != null) {
foreach ($this->_AddField as $data) {
$table = $data['table'];
$db_field = "{$table}.{$data['field']}";
$select[] = $db_field;
$arrayTables[$table] = $table;
}
}
//si es post , grabara los cambios
if (request::method() == 'post' and $this->_OnlyRead == FALSE) {
$save = $this->save;
if ($save == 'AUTO') {
$save = array();
foreach ($this->meta as $fieldname => $props) {
$save[] = $fieldname;
}
}
$input = Input::instance();
foreach ($save as $field) {
$foreach_typefield =& $types->fields->{$field}->typefield;
if ($types->fields->{$field}->typefield == 'CheckField' and @$_POST[$field] == '') {
$_POST[$field] = FALSE;
}
if ($foreach_typefield == 'PasswordField') {
$_POST[$field] = fpp::cryptme($_POST[$field]);
}
if ($input->post($field) !== null and $types->fields->{$field}->typefield != 'OneToMany' and $types->fields->{$field}->typefield != 'TabularModel') {
$inp = $input->post($field);
$tmp_inp = $inp;
if ($types->fields->{$field}->post_exec != null and request::method() == 'post') {
$value = $input->post($field);
eval($types->fields->{$field}->post_exec . ';');
$inp = $value;
}
$update_fields[$field] = $inp;
}
//Preparando los Uno a muchos, y muchos a muchos
if ($types->fields->{$field}->typefield == 'OneToMany' or $types->fields->{$field}->typefield == 'TabularModel') {
$modtable = substr($types->fields->{$field}->model, 4);
$metaOTM = fpp::GetOTM($modtable, $this->_Table);
$metaOTM['fieldhtml'] = $input->post($field);
$metaOTM['pk'] = $field;
$OneToMany[$field] = $metaOTM;
$this->db->delete($modtable, array($metaOTM['primary'] => $id));
}
}
/**/
if ($this->_AddKeyField != null) {
foreach ($this->_AddKeyField as $field => $FValue) {
$update_fields[$field] = $FValue;
}
}
if (isset($_FILES)) {
foreach ($_FILES as $key => $value) {
// Checking Files (Upload Only Images)
$this->file_type = $_FILES[$key]['type'];
if (!($this->file_type != 'image/jpg' && $this->file_type != 'image/x-png' && $this->file_type != 'image/pjpeg' && $this->file_type != 'image/jpeg' && $this->file_type != 'image/gif' && $this->file_type != 'video/avi' && $this->file_type != 'video/msvideo' && $this->file_type != 'video/x-msvideo' && $this->file_type != 'image/png')) {
//Execute IF statment
try {
$retupload = upload::save($_FILES[$key]);
} catch (Exception $e) {
echo Kohana::debug('Error: ' . "\n" . $e->getMessage() . "\n");
die;
}
$retupload = explode('upload/', $retupload);
if (count($retupload) > 1) {
$retupload = $retupload[1];
$update_fields[$key] = $retupload;
$value = $retupload;
if ($types->fields->{$key}->post_exec != null and request::method() == 'post') {
eval($types->fields->{$key}->post_exec . ';');
}
}
}
}
}
if ($id != null) {
try {
$status = $this->db->update($this->_Table, $update_fields, array($first => $id));
} catch (Exception $e) {
echo Kohana::debug('Error: ' . "\n" . $e->getMessage() . "\n");
die;
}
} else {
try {
$status = $this->db->insert($this->_Table, $update_fields);
$id = $status->insert_id();
} catch (Exception $e) {
echo Kohana::debug('Error: ' . "\n" . $e->getMessage() . "\n");
die;
}
}
if (@$_SESSION['PKID'] != "" and @$_GET['AJAX_NO_LOAD'] == TRUE) {
$_SESSION['PKID_OTM'] = $id;
}
if (is_array($OneToMany)) {
foreach ($OneToMany as $valueOTM) {
if (is_array($valueOTM['fieldhtml'])) {
foreach ($valueOTM['fieldhtml'] as $value) {
$arrOTMnew = array($valueOTM['primary'] => $id, $valueOTM['secondary'] => $value);
$this->db->insert($valueOTM['table'], $arrOTMnew);
}
}
}
}
$this->_Response = TRUE;
$msg = fpp::fppmsg('Guardo Correctamente');
}
if ($id != null or $idorigin == 'LOOK') {
//Inicializacion del query (construccion & carga)
$strinTables = implode(',', $arrayTables);
$select = implode(',', $select);
$query = $this->db->select($select)->from($strinTables)->limit(1, 0);
if (is_array($arrayWhere)) {
$stringWhere = implode(' AND ', $arrayWhere);
$query = $query->where($stringWhere);
}
if ($idorigin != 'LOOK') {
$wherearray[] = "{$first} = {$id}";
}
if ($this->_AddKeyField != null) {
foreach ($this->_AddKeyField as $Fkey => $FValue) {
$wherearray[] = "{$Fkey} = {$FValue}";
}
}
if ($this->_FilterActive != null) {
foreach ($this->_FilterActiveByInfo as $filter => $value) {
$wherearray[] = "{$this->_Table}.{$filter} = {$value}";
}
}
$where_string = implode(' AND ', $wherearray);
$query = $query->where($where_string);
try {
$rows = $query->get();
} catch (Exception $e) {
echo Kohana::debug('Error: ' . "\n" . $e->getMessage() . "\n");
die;
}
//escribiendo los campos de acuerdo a sus propiedades
$data = new StdClass();
$types->base_uri = $this->base_uri;
$valid_count = FALSE;
foreach ($rows as $row) {
foreach ($OTMSelect as $nameOTM) {
$row->{$nameOTM} = 'null';
}
foreach ($row as $name => $value) {
$valid_count = TRUE;
if ($this->_OnlyRead == TRUE) {
$data->{$name} = $value;
} else {
$types->field_value = $value;
// Si el campo es un "OneToMany"
if ($types->fields->{$name}->typefield == 'OneToMany' or $types->fields->{$name}->typefield == 'TabularModel') {
if (@$OneToMany[$name]['table'] == '') {
$modtable = substr($types->fields->{$name}->model, 4);
$OneToMany[$name] = fpp::GetOTM($modtable, $this->_Table);
}
$OTMArr = null;
// Tomo el campo primario y secundario
$OTMdb_field = $OneToMany[$name]['secondary'];
$OTMdb_pk = $OneToMany[$name]['primary'];
$valuelistOTM = null;
try {
$valuelistOTM = $this->db->from($OneToMany[$name]['table'])->select($OTMdb_field)->where(array($OTMdb_pk => $id))->get();
} catch (Exception $e) {
echo Kohana::debug('Error: ' . "\n" . $e->getMessage() . "\n");
die;
}
foreach ($valuelistOTM as $rowOTM) {
$OTMArr[] = $rowOTM->{$OTMdb_field};
}
$types->field_value = $OTMArr;
}
$types->field_name = $name;
$arrayorder[$name] = $types->ObjectField($name);
}
}
foreach ($this->meta as $fieldname => $props) {
$data->{$fieldname} = $arrayorder[$fieldname];
}
}
} else {
foreach ($items as $name) {
$valid_count = TRUE;
$types->field_name = $name;
$types->field_value = NULL;
$data->{$name} = $types->ObjectField($name);
}
}
//VIRTUAL
if ($this->virtual != null) {
$dirf = dirname(__FILE__);
include_once $dirf . '/types/' . $this->virtual . '.php';
$data->virtualfield = new $this->virtual();
$data->virtualfield->id_table = $id;
$titles['virtualfield'] = $data->virtualfield->title;
}
if ($this->virtualclone != null) {
$dirf = dirname(__FILE__);
include_once $dirf . '/types/' . $this->virtualclone . '.php';
$data->virtualfieldc = new $this->virtualclone();
$data->virtualfieldc->id_table = $id;
$titles['virtualfieldc'] = $data->virtualfieldc->title;
}
//VIRTUAL
if ($valid_count == FALSE) {
return NULL;
}
$this->retfields = $data;
//Setting Ajax
$form = null;
$attrform = null;
if (@$_GET['AJAX_NO_LOAD'] == TRUE) {
$form .= '<script>$(document).ready(function(){$(".FORM_AJAX").submit(function(){ return post_ajax(this); })});</script>';
$attrform = array("class" => 'FORM_AJAX');
}
$urlform = NULL;
if ($id > 0) {
$this->uri = URI::Instance();
$urlform = str_replace("add", "edit/" . $id, $this->uri);
}
$form .= form::open_multipart($urlform, $attrform);
if ($this->GetFieldAjax != NULL) {
$FAjax = $this->GetFieldAjax;
return $data->{$FAjax};
}
$view_info = $this->_TabView == TRUE ? 'tabmodel' : 'info';
$str = View::factory($this->templatedir . $view_info)->set('msg', $msg)->set('data', $data)->set('form', $form)->set('only_read', $this->_OnlyRead)->set('titles', $titles)->set('tblname', $this->_Table)->render();
return $str;
}
