Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- class Uredi_podjetje extends Controller {
- function Uredi_podjetje()
- {
- parent::Controller();
- $this->load->library('form_validation');
- $this->load->helper('string');
- $this->load->helper('custom');
- $this->load->library('session');
- $this->load->library('email');
- }
- function index()
- {
- $this->form_validation->set_message('required', 'Prosimo, vpišite %s!');
- $this->form_validation->set_message('max_length', 'V polje %s lahko vpišete največ %s znakov!');
- $this->form_validation->set_rules('title', 'naziv', 'required|max_length[255]');
- $this->form_validation->set_error_delimiters('<span style="color: red;">', '</span>');
- if ($this->form_validation->run() == FALSE)
- {
- //preberemo regije
- $query_r = $this->db->query("SELECT * FROM regije");
- $data['regije'] = $query_r->result_array();
- //preberemo področja
- $query_r = $this->db->query("SELECT * FROM podrocja");
- $data['podrocja'] = $query_r->result_array();
- //preberemo podatke o podjetju
- $query_ad = $this->db->query("SELECT * FROM podjetja WHERE podjetje_id = '".$this->uri->segment(4)."'");
- $data['podjetje_content'] = $query_ad->result_array();
- $data['podjetje_id'] = $this->uri->segment(4);
- //povemo, da še ni ok
- $data['ok'] = false;
- //prikažemo
- $this->load->view('admin/header');
- $this->load->view('admin/uredi_podjetje', $data);
- $this->load->view('admin/footer');
- }
- else
- {
- //zgeneriramo url iz naziva podjetja
- $url = mb_strtolower($_POST['title'], 'UTF-8');
- $search = array("č", "ć", "š", "ž", " ", "@", "&", "/", "\\", ".");
- $replace = array("c", "c", "s", "z", "-", "-", "-", "-", "-", "-");
- $url = str_replace($search, $replace, $url);
- $url = generate_url($url);
- //preverimo, če slučajno tak naslov ni že v bazi
- $url_check = $this->db->query("SELECT * FROM podjetja WHERE podjetje_url = '".$url."' AND podjetje_id != '".$this->uri->segment(4)."'");
- if($url_check->num_rows($url_check) > 0)
- {
- $url = $url."-2";
- //za vsak slučaj preverimo še za eno cifro
- $url_check = $this->db->query("SELECT * FROM podjetja WHERE podjetje_url = '".$url."' AND podjetje_id != '".$this->uri->segment(4)."'");
- if($url_check->num_rows($url_check) > 0)
- {
- $url = substr($url, 0, strlen($url)-2)."-3";
- //za vsak slučaj preverimo še za eno cifro
- $url_check = $this->db->query("SELECT * FROM podjetja WHERE podjetje_url = '".$url."' AND podjetje_id != '".$this->uri->segment(4)."'");
- if($url_check->num_rows($url_check) > 0)
- {
- $url = substr($url, 0, strlen($url)-2)."-4";
- //za vsak slučaj preverimo še za eno cifro
- $url_check = $this->db->query("SELECT * FROM podjetja WHERE podjetje_url = '".$url."' AND podjetje_id != '".$this->uri->segment(4)."'");
- if($url_check->num_rows($url_check) > 0)
- {
- $url = substr($url, 0, strlen($url)-2)."-5";
- //za vsak slučaj preverimo še za eno cifro
- $url_check = $this->db->query("SELECT * FROM podjetja WHERE podjetje_url = '".$url."' AND podjetje_id != '".$this->uri->segment(4)."'");
- if($url_check->num_rows($url_check) > 0)
- {
- $url = substr($url, 0, strlen($url)-2)."-6";
- //za vsak slučaj preverimo še za eno cifro
- $url_check = $this->db->query("SELECT * FROM podjetja WHERE podjetje_url = '".$url."' AND podjetje_id != '".$this->uri->segment(4)."'");
- if($url_check->num_rows($url_check) > 0)
- {
- $url = substr($url, 0, strlen($url)-2)."-7";
- }
- }
- }
- }
- }
- }
- //če je izbrano brisanje logotipa al pa če je izbran nov logotip, izvedemo upload. Če je izbrano brisanje in ni novga logotipa, bo $logo prazen in se pobriše
- if(@$_POST['delete_logo'] == '1' || @$_FILES['logo']['tmp_name'] != '')
- {
- //naložimo datoteko
- $config['upload_path'] = './uvoz_podjetij/logotipi/';
- $config['allowed_types'] = 'gif|jpg|jpeg|png';
- $this->load->library('upload', $config);
- if ( ! $this->upload->do_upload('logo'))
- {
- $logo = '';
- }
- else
- {
- $logo_info = $this->upload->data();
- $logo = $logo_info['file_name'];
- }
- //spremenimo poti pri fotkah
- //$opis = str_replace("../tiny_upload/", BASE_URL."/tiny_upload/", $_POST['opis']);
- $opis = str_replace("../../../domains/racunovodski-servisi.org/public_html/tiny_upload/", BASE_URL."/tiny_upload/", $_POST['opis']);
- //zapišemo v bazo
- $data_update = array(
- 'podjetje_url' => $url,
- 'podjetje_naziv' => $_POST['title'],
- 'ulica' => $_POST['ulica'],
- 'h_stevilka' => $_POST['h_stevilka'],
- 'p_stevilka' => $_POST['p_stevilka'],
- 'kraj' => $_POST['kraj'],
- 'telefon' => $_POST['telefon'],
- 'telefon2' => $_POST['telefon2'],
- 'faks' => $_POST['faks'],
- 'mail' => $_POST['mail'],
- 'www' => $_POST['www'],
- 'www2' => $_POST['www2'],
- 'davcna_st' => $_POST['davcna_st'],
- 'direktor' => $_POST['direktor'],
- 'opis' => $opis,
- 'logo' => $logo
- );
- $this->db->update('podjetja', $data_update, "podjetje_id = ".$this->uri->segment(4));
- //najprej poiščemo trenutno pozicijo
- $result_poz = mysql_query("SELECT * FROM ppr WHERE podjetje_id = '".$this->uri->segment(4)."'") or die(mysql_error());
- $row_poz = mysql_fetch_array($result_poz);
- //nato pobrišemo obstoječe zapise v povezovalni tabeli za dotično podjetje
- mysql_query("DELETE FROM ppr WHERE podjetje_id = '".$this->uri->segment(4)."'") or die(mysql_error());
- //nato vstavimo nove podatke
- for($i = 0; $i < count($_POST['podrocja']); $i++)
- {
- for($j = 0; $j < count($_POST['regije']); $j++)
- {
- mysql_query("INSERT INTO ppr (podjetje_id, podrocje_id, regija_id, poz) VALUES (".$this->uri->segment(4).", ".$_POST['podrocja'][$i].", ".$_POST['regije'][$j].", ".$row_poz['poz'].")") or die(mysql_error());
- }
- }
- }
- else
- {
- //spremenimo poti pri fotkah
- $opis = str_replace("../../../domains/racunovodski-servisi.org/public_html/tiny_upload/", BASE_URL."/tiny_upload/", $_POST['opis']);
- //$opis = str_replace("../tiny_upload/", BASE_URL."/tiny_upload/", $_POST['opis']);
- //zapišemo v bazo
- $data_update = array(
- 'podjetje_url' => $url,
- 'podjetje_naziv' => $_POST['title'],
- 'ulica' => $_POST['ulica'],
- 'h_stevilka' => $_POST['h_stevilka'],
- 'p_stevilka' => $_POST['p_stevilka'],
- 'kraj' => $_POST['kraj'],
- 'telefon' => $_POST['telefon'],
- 'telefon2' => $_POST['telefon2'],
- 'faks' => $_POST['faks'],
- 'mail' => $_POST['mail'],
- 'www' => $_POST['www'],
- 'www2' => $_POST['www2'],
- 'davcna_st' => $_POST['davcna_st'],
- 'direktor' => $_POST['direktor'],
- 'opis' => $opis
- );
- $this->db->update('podjetja', $data_update, "podjetje_id = ".$this->uri->segment(4));
- //najprej poiščemo trenutno pozicijo
- $result_poz = mysql_query("SELECT * FROM ppr WHERE podjetje_id = '".$this->uri->segment(4)."'") or die(mysql_error());
- $row_poz = mysql_fetch_array($result_poz);
- //nato pobrišemo obstoječe zapise v povezovalni tabeli za dotično podjetje
- mysql_query("DELETE FROM ppr WHERE podjetje_id = '".$this->uri->segment(4)."'") or die(mysql_error());
- //nato vstavimo nove podatke
- for($i = 0; $i < count($_POST['podrocja']); $i++)
- {
- for($j = 0; $j < count($_POST['regije']); $j++)
- {
- mysql_query("INSERT INTO ppr (podjetje_id, podrocje_id, regija_id, poz) VALUES (".$this->uri->segment(4).", ".$_POST['podrocja'][$i].", ".$_POST['regije'][$j].", ".$row_poz['poz'].")") or die(mysql_error());
- }
- }
- }
- //če gre vse vredu, prikažemo sporočilo
- $data['ok'] = true;
- $this->load->view('admin/header');
- $this->load->view('admin/uredi_podjetje', $data);
- $this->load->view('admin/footer');
- }
- }
- function izbrisi()
- {
- if($this->session->userdata('admin_logedin') == true)
- {
- //izbrišemo skupino
- $query_news = $this->db->query("DELETE FROM podjetja WHERE podjetje_id = '".$this->uri->segment(4)."'");
- header("Location: ".BASE_URL."/admin/podjetja");
- }
- else
- {
- header("Location: ".BASE_URL."/admin/home");
- }
- }
- }
- /* End of file uredi_oglas.php */
- /* Location: ./system/application/controllers/uredi_oglas.php */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement