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: chapters_model.php

<?php

class Chapters_Model extends MY_Model {
	
	public function get_chapters_list(){
		$sql = "
			SELECT
				* ,
				Volumes.Title as 'Volume'
			FROM VolumesChapters 
			LEFT JOIN Volumes ON VolumesChapters.VolumeId = Volumes.Id
			WHERE VolumesChapters.Deleted = 0
			ORDER BY VolumeId DESC, Id ASC
		";
		$query = $this->db->query($sql);
		return $query->result_array();
	}

public function getOnlineFirst()
    {
        $sql = "
			SELECT
				* 
			FROM VolumesChapters 
			WHERE VolumeId = -1 AND Deleted = 0
			ORDER BY Id DESC
		";
        $query = $this->db->query($sql);
        return $query->result_array();
	}
	
	public function search($term = null){
		
		$filters = "";
		if (null != $term) {
			$filters .= "AND (LOWER(`VolumesChapters`.`Title`) like '%".$term."%' OR LOWER(`VolumesChapters`.`Authors`) like '%".$term."%' OR LOWER(`VolumesChapters`.`Abstract`) like '%".$term."%' OR LOWER(`VolumesChapters`.`KeyWords`) like '%".$term."%')";
		}
		
		$sql = "
			SELECT
				* ,
				Volumes.Id as 'VolumeId',
				Volumes.Title as 'VolumeTitle',
				Volumes.Foreword as 'VolumeForeword',
				Volumes.Reviews as 'VolumeReviews',
				Volumes.Corrigendum as 'VolumeCorrigendum',
				Volumes.File as 'VolumeFile',
				VolumesChapters.Title as 'Title',
				VolumesChapters.Authors as 'Authors',
				VolumesChapters.Abstract as 'Abstract',
				VolumesChapters.KeyWords as 'KeyWords',
				VolumesChapters.PdfFile as 'PdfFile'

FROM VolumesChapters 
			LEFT JOIN Volumes ON VolumesChapters.VolumeId = Volumes.Id
			WHERE `VolumesChapters`.`Deleted` = 0 AND `Volumes`.`Deleted` = 0 ".$filters."
			ORDER BY VolumesChapters.VolumeId DESC, VolumesChapters.Id ASC
		";
		$query = $this->db->query($sql);
		$chapters =  $query->result_array();
		
		$volumes = array();
		foreach ($chapters as $chapter) {
			if (isset($volumes[$chapter['VolumeId']])) {
				$insert = array();
				$insert['Id'] = $chapter['Id'];
				$insert['VolumeId'] = $chapter['VolumeId'];
				$insert['Title'] = $chapter['Title'];
				$insert['Authors'] = $chapter['Authors'];
				$insert['Abstract'] = $chapter['Abstract'];
				$insert['KeyWords'] = $chapter['KeyWords'];
				$insert['PdfFile'] = $chapter['PdfFile'];
				
				$volumes[$chapter['VolumeId']]['Chapters'][] = $insert;
			} else {
				$volume = array();
				$volume['Id'] = $chapter['VolumeId'];
				$volume['Title'] = $chapter['VolumeTitle'];
				if (isset($chapter['VolumeForeword']) && strlen($chapter['VolumeForeword']) > 2) {
					$volume['IdForeword'] = '/' . $chapter['VolumeForeword'];
				}
				
				if (isset($chapter['VolumeReviews']) && strlen($chapter['VolumeReviews']) > 2) {
					$volume['Reviews'] = '/' . $chapter['VolumeReviews'];
				}					
				if (isset($chapter['VolumeCorrigendum']) && strlen($chapter['VolumeCorrigendum']) > 2) {
					$volume['Corrigendum'] =  '/' . $chapter['VolumeCorrigendum'];
				}
				
				if (isset($chapter['VolumeFile']) && strlen($chapter['VolumeFile']) > 2) {
					$volume['File'] = '/' . $chapter['VolumeFile'];
				}
				
				
				$insert = array();
				$insert['Id'] = $chapter['Id']; 
				$insert['VolumeId'] = $chapter['VolumeId'];
				$insert['Title'] = $chapter['Title'];
				$insert['Authors'] = $chapter['Authors'];
				$insert['Abstract'] = $chapter['Abstract'];
				$insert['KeyWords'] = $chapter['KeyWords'];
				$insert['PdfFile'] = $chapter['PdfFile'];
				
				$volume['Chapters'] = array();
				$volume['Chapters'][] = $insert;
				$volumes[$volume['Id']] = $volume;
			}
		}

return $volumes;
		
	}
	
	public function get_chapter($id){
		$sql = "
			SELECT 
				VolumesChapters.Id,
				VolumesChapters.VolumeId,
				VolumesChapters.Title,
				VolumesChapters.Authors,
				VolumesChapters.Abstract,
				VolumesChapters.KeyWords,
				VolumesChapters.PdfFile,
				Volumes.Title as 'Volume'
			FROM VolumesChapters 
			LEFT JOIN Volumes ON VolumesChapters.VolumeId = Volumes.Id
			WHERE VolumesChapters.Id = ".$id."
		";
		$query = $this->db->query($sql);
		return $query->row_array();
	}
	
	public function update_chapter($id, $volume_id, $title, $authors, $abstract, $keywords, $pdf){
		$sql = "
			UPDATE VolumesChapters 
			SET VolumeId = ".$volume_id.",
				Title = '".mysql_real_escape_string($title)."',
				Authors = '".mysql_real_escape_string($authors)."',
				Abstract = '".mysql_real_escape_string($abstract)."',
				KeyWords = '".mysql_real_escape_string($keywords)."',
				PdfFile = '".mysql_real_escape_string($pdf)."'
			WHERE Id = ".$id."
		";
		$query = $this->db->query($sql);
		return true;
	}
	
	public function insert_chapter($volume_id, $title, $authors, $abstract, $keywords, $pdf){
		$sql = "
			INSERT INTO VolumesChapters (VolumeId, Title, Authors, Abstract, KeyWords, PdfFile, Deleted)
			VALUES (".$volume_id.", '".mysql_real_escape_string($title)."', '".mysql_real_escape_string($authors)."', '".mysql_real_escape_string($abstract)."', '".mysql_real_escape_string($keywords)."', '".mysql_real_escape_string($pdf)."', 0)
		";
		$query = $this->db->query($sql);
		return true;
	}
	
	public function delete_chapter($id){
		$sql = "UPDATE VolumesChapters SET Deleted = 1 WHERE Id = ".$id;
		$query = $this->db->query($sql);
		return true;
	}
}

X7ROOT File Manager

Editing: chapters_model.php

Upload File

Create Folder