File Manager

X7ROOT File Manager

Current Path: /home/jurarevi/beta.jurareview.ro/application/models

home / jurarevi / beta.jurareview.ro / application / models /

📁 ..
📄 announcements_model.php(1.01 KB)
📄 chapters_model.php(5.22 KB)
📄 headerfooter_model.php(1.05 KB)
📄 index.html(114 B)
📄 menu_model.php(2.28 KB)
📄 miscconfig_model.php(1.98 KB)
📄 pagini_model.php(1.22 KB)
📄 sidebars_model.php(873 B)
📄 volumes_model.php(3.9 KB)

Editing: volumes_model.php

<?php

class Volumes_Model extends MY_Model {

public function get_volumes_list(){

$sql = "SELECT * FROM Volumes WHERE Deleted = 0 ORDER BY `Id` DESC";

$query = $this->db->query($sql);

return $query->result_array();

}

public function get_volume($id){

$sql = "SELECT * FROM Volumes WHERE Id = ".$id;

$query = $this->db->query($sql);

return $query->result_array();

}

public function get_last_volume(){

$sql = "

SELECT

Volumes.Id,

Volumes.Title,

Volumes.Foreword,

Volumes.Reviews,

Volumes.Corrigendum,

Volumes.File

FROM Volumes

WHERE Deleted = 0

ORDER BY Id DESC

LIMIT 1

$query = $this->db->query($sql);

$volume =  $query->row_array();

$sql = "SELECT * FROM VolumesChapters WHERE VolumeId = ".$volume['Id']." AND Deleted = 0";

$query = $this->db->query($sql);

$volume['Chapters'] = $query->result_array();

return $volume;

}

public function view_content_online(){

$sql = "

SELECT

Volumes.Id,

Volumes.Title,

Volumes.Foreword,

Volumes.Reviews,

Volumes.Corrigendum,

Volumes.File

FROM Volumes

WHERE Deleted = 0

ORDER BY Id DESC

$query = $this->db->query($sql);

$volumes =  $query->result_array();

if(!empty($volumes)){

// 			$kyes = array_keys($volumes);

// 			$latest_volume_key = reset($kyes);

// 			unset($volumes[$latest_volume_key]);

foreach ($volumes as $key => $volume){

$sql = "SELECT * FROM VolumesChapters WHERE VolumeId = ".$volume['Id']." AND Deleted = 0";

$query = $this->db->query($sql);

$volumes[$key]['Chapters'] = $query->result_array();

}

return $volumes;

}

public function get_volume_and_chapters($id){

$sql = "

SELECT *

FROM Volumes

WHERE Id = ".$id."

AND Deleted = 0

LIMIT 1

$query = $this->db->query($sql);

$volume =  $query->row_array();

if (!empty($volume)) {

$sql = "SELECT * FROM VolumesChapters WHERE VolumeId = ".$volume['Id']." AND Deleted = 0";

$query = $this->db->query($sql);

$volume['Chapters'] = $query->result_array();

}

return $volume;

}

public function search($term = null){

$filters = "";

if ($term != null) {

$filters .= "AND LOWER(Title) like '%" . $term . "%'";

}

$sql = "

SELECT *

FROM Volumes

WHERE Deleted = 0 " . $filters . "

$query = $this->db->query($sql);

$volumes =  $query->result_array();

$response = array();
		if (!empty($volumes)) {

foreach ($volumes as $volume_key => $volume) {

$sql = "SELECT * FROM VolumesChapters WHERE VolumeId = ".$volume['Id']." AND Deleted = 0";

$query = $this->db->query($sql);

$volume['Chapters'] = $query->result_array();
                $response[$volume['Id']] = $volume;

}

return $response;

}

public function insert($title, $files){

$sql = "

INSERT INTO Volumes (Title, Foreword, Reviews, Corrigendum, File, Deleted)

VALUES ('".mysql_real_escape_string($title)."', '".(isset($files['foreword']) ? $files['foreword'] : '')."', '".(isset($files['reviews']) ? $files['reviews'] : '')."', '".(isset($files['corrigendum']) ? $files['corrigendum'] : '')."', '".(isset($files['file']) ? $files['file'] : '')."', 0)

$query = $this->db->query($sql);

return true;

}

public function update_volume($id, $title, $foreword, $reviews, $corrigendum, $pdf) {

$sql = "

UPDATE Volumes

SET Title = '".mysql_real_escape_string($title)."',

Foreword = '".$foreword."',

Reviews = '".$reviews."',

Corrigendum = '".$corrigendum."',

File = '".$pdf."'

WHERE Id = ".$id."

$query = $this->db->query($sql);

return true;

}

public function delete_volume($id){

$sql = "UPDATE Volumes SET Deleted = 1 WHERE Id = ".$id;

$query = $this->db->query($sql);

return true;

}

X7ROOT File Manager

Editing: volumes_model.php

Upload File

Create Folder