function modify()
{
if (!isset($_POST['submit_modify'])) {
//Mostrar plantilla vacía
return 0;
} else {
//Introducir los datos de post.
//Si se modificó la foto
if ($_SESSION['ruta_temporal'] != "") {
$file = new upload_file($_SESSION['nombre_photo'], $_SESSION['ruta_temporal'], $_SESSION['tamanno_photo'], $this->id_service, $this->path_photo);
$result = $file->upload("images/services/");
}
$this->get_fields_from_post();
//$this->insert_post();
//Validacion
//Modificamos los todos los valores del objeto fields con los nuevos datos del objeto product, exceptuando path_photo que eso se deberia hacer mediante la clase upload.
$this->fields_list->modify_value($this->ddbb_id_service, $this->id_service);
$this->fields_list->modify_value($this->ddbb_id_corp, $this->id_corp);
$this->fields_list->modify_value($this->ddbb_descrip, $this->descrip);
$this->fields_list->modify_value($this->ddbb_name, $this->name);
$this->fields_list->modify_value($this->ddbb_name_web, $this->name_web);
$this->fields_list->modify_value($this->ddbb_pvp, $this->pvp);
$this->fields_list->modify_value($this->ddbb_tax, $this->tax);
$this->fields_list->modify_value($this->ddbb_pvp_tax, $this->pvp_tax);
//validamos
$return = $this->fields_list->validate();
//En caso de que la validacion haya sido fallida se muestra la plantilla
//con los campos erroneos marcados con un *
// $return=true; //Para pruebas dejar esta linea sin comentar
if (!$return) {
//Mostrar plantilla con datos erroneos
} else {
$ADODB_FETCH_MODE = ADODB_FETCH_BOTH;
//crea una nueva conexin con una bbdd (mysql)
$this->db = NewADOConnection($this->db_type);
//le dice que no salgan los errores de conexin de la ddbb por pantalla
$this->db->debug = false;
//realiza una conexin permanente con la bbdd
$this->db->Connect($this->db_ip, $this->db_user, $this->db_passwd, $this->db_name);
//mete la consulta para coger los campos de la bbdd
$this->sql = "SELECT * FROM " . $this->table_prefix . $this->table_name . " WHERE " . $this->ddbb_id_service . " = \"" . $this->id_service . "\"";
//la ejecuta y guarda los resultados
$this->result = $this->db->Execute($this->sql);
//si falla
if ($this->result === false) {
$this->error = 1;
$this->db->close();
return 0;
}
//rellenamos el array con los datos de los atributos de la clase
$record = array();
$record[$this->ddbb_id_service] = $this->id_service;
$record[$this->ddbb_id_corp] = $this->id_corp;
$record[$this->ddbb_name] = $this->name;
$record[$this->ddbb_name_web] = $this->name_web;
$record[$this->ddbb_pvp] = $this->pvp;
$record[$this->ddbb_tax] = $this->tax;
$record[$this->ddbb_pvp_tax] = $this->pvp_tax;
$record[$this->ddbb_descrip] = $this->descrip;
//calculamos la sql de insercin respecto a los atributos
$this->sql = $this->db->GetUpdateSQL($this->result, $record);
//insertamos el registro
$this->db->Execute($this->sql);
//si se ha insertado una fila
$Affected_Rows = $this->db->Affected_Rows();
$return_categories = $this->modify_categories();
if ($Affected_Rows == 1 || $this->sql == "" || $return_categories == 1) {
//capturammos el id de la linea insertada
$this->db->close();
//devolvemos el id de la tabla ya que todo ha ido bien
return $this->id_service;
} else {
//devolvemos 0 ya que no se ha insertado el registro
$this->error = -1;
$this->db->close();
return 0;
}
}
}
}
$_POST[idx] += 0;
$_POST['mini_url'] = trim($_POST['mini_url']);
if ($_POST['mini_url'] != '' && $_POST['mini_url'] != 'http://') {
$src = $_POST['mini_url'];
} else {
//$dir = "data/";
$dir = "../../data/editor/";
if (!preg_match("/^image/", $_FILES[mini_file][type])) {
echo "<script>alert('이미지 파일만 업로드가 가능합니다');</script>";
exit;
}
if (is_uploaded_file($_FILES[mini_file][tmp_name])) {
$div = explode(".", $_FILES[mini_file][name]);
$filename = time() . "." . $div[count($div) - 1];
$upload = new upload_file($_FILES['mini_file'], $dir . $filename, 'image');
if (!$upload->upload()) {
echo "<script>alert('이미지 파일만 업로드가 가능합니다');</script>";
exit;
}
setDu('editor');
# 계정용량 계산
}
$src = dirname($_SERVER[PHP_SELF]) . "/" . $dir . $filename;
}
if ($_POST[imgWidth] && $_POST[imgHeight]) {
$size = " width='{$_POST['imgWidth']}' height='{$_POST['imgHeight']}'";
}
if ($src) {
echo "<script>parent.opener.mini_set_html({$_POST['idx']},\"<img src='{$src}' {$size}>\");</script>";
}
echo "<script>parent.window.close();</script>";
//沒有找到要上傳的檔案 UPLOAD_ERR_NO_FILE
$this->upfile_error = "沒有找到要上傳的檔案";
break;
case 5:
//伺服器臨時檔案遺失
$this->upfile_error = "伺服器臨時檔案遺失";
break;
case 6:
//檔案寫入到站存資料夾錯誤 UPLOAD_ERR_NO_TMP_DIR
$this->upfile_error = "檔案寫入到暫存資料夾錯誤";
break;
case 7:
//無法寫入硬碟 UPLOAD_ERR_CANT_WRITE
$this->upfile_error = "無法寫入硬碟";
break;
case 8:
//UPLOAD_ERR_EXTENSION
$this->upfile_error = "PHP擴充功能影響上傳";
break;
}
echo $this->upfile_error;
}
}
}
if (@$_POST['submit']) {
$upload = new upload_file();
$upload->upload();
}
?>
</body>
</html>
function modify()
{
if (!isset($_POST['submit_modify'])) {
return 0;
} else {
//Introducir los datos de post.
//Si se modificó la foto
if ($_SESSION['ruta_temporal'] != "") {
$file = new upload_file($_SESSION['nombre_photo'], $_SESSION['ruta_temporal'], $_SESSION['tamanno_photo'], $this->id_vehicle, $this->path_photo);
$result = $file->upload("images/vehicles/");
if ($result == 1) {
//modificar ruta de la foto
$this->modify_photo($this->id_vehicle);
}
}
$this->get_fields_from_post();
//$this->insert_post();
$this->fields_list->modify_value($this->ddbb_id_vehicle, $this->id_vehicle);
$this->fields_list->modify_value($this->ddbb_id_corp, $this->id_corp);
$this->fields_list->modify_value($this->ddbb_number_plate, $this->number_plate);
$this->fields_list->modify_value($this->ddbb_alias, $this->alias);
//validamos
$return = $this->fields_list->validate();
//Validacion
//$return=validate_fields();
//En caso de que la validacion haya sido fallida se muestra la plantilla
//con los campos erroneos marcados con un *
if (!$return) {
//Mostrar plantilla con datos erroneos
return -1;
} else {
$ADODB_FETCH_MODE = ADODB_FETCH_BOTH;
//crea una nueva conexin con una bbdd (mysql)
$this->db = NewADOConnection($this->db_type);
//le dice que no salgan los errores de conexin de la ddbb por pantalla
$this->db->debug = false;
//realiza una conexin permanente con la bbdd
$this->db->Connect($this->db_ip, $this->db_user, $this->db_passwd, $this->db_name);
//mete la consulta para coger los campos de la bbdd
$this->sql = "SELECT * FROM " . $this->table_prefix . $this->table_name . " WHERE " . $this->ddbb_id_vehicle . " = \"" . $this->id_vehicle . "\"";
//la ejecuta y guarda los resultados
$this->result = $this->db->Execute($this->sql);
//si falla
if ($this->result === false) {
$this->error = 1;
$this->db->close();
return 0;
}
//rellenamos el array con los datos de los atributos de la clase
$record = array();
$record[$this->ddbb_id_vehicle] = $this->id_vehicle;
$record[$this->ddbb_id_corp] = $this->id_corp;
$record[$this->ddbb_alias] = $this->alias;
$record[$this->ddbb_number_plate] = $this->number_plate;
$record[$this->ddbb_path_photo] = $this->path_photo;
//calculamos la sql de insercin respecto a los atributos
$this->sql = $this->db->GetUpdateSQL($this->result, $record);
//insertamos el registro
$this->db->Execute($this->sql);
//si se ha insertado una fila
$Affected_Rows = $this->db->Affected_Rows();
/*Al hacer la modificacion de categorias antes del siguiente "if"
se debe de guardar en una variable el contenido de las filas afectadas y hacer
la condicion del if con esa variable ya que al hacer las modificaciones ese valor varía.
*/
/*
$return_category=$this->modify_category($this->id_emp);
if(($Affected_Rows==1)||($user_changed!=0)||($this->sql=="")||($return_category!=0))
{
//capturammos el id de la linea insertada
$this->db->close();
//devolvemos el id de la tabla ya que todo ha ido bien
return $this->id_vehicle;
}
else
{
//devolvemos 0 ya que no se ha insertado el registro
$this->error=-1;
$this->db->close();
return 0;
}*/
$return_categories = $this->modify_categories();
if ($Affected_Rows == 1 || $this->sql == "" || $return_categories == 1) {
//capturammos el id de la linea insertada
$this->db->close();
//devolvemos el id de la tabla ya que todo ha ido bien
return $this->id_vehicle;
} else {
//devolvemos 0 ya que no se ha insertado el registro
$this->error = -1;
$this->db->close();
return 0;
}
}
}
}
