Fichier application/helpers/album_helper.php

<?php

/*
 * Created by generator
 *
 */

/**
 * Recupere la liste des enregistrements
 * @param object $db database object
 * @return array of data
 */
if (!function_exists('getAllAlbumsFromDB')) {
	function getAllAlbumsFromDB($db, $orderBy = null, $asc = null, $limit = null, $offset = null) {
		if( $orderBy != null ){
			if($asc != null) {
				$db->order_by($orderBy, $asc);
			}else {
				$db->order_by($orderBy, "asc");
			}
		}
		if( $limit == null ) {
			$query = $db->get("bibalb");
		} else {
			$query = $db->limit($limit, $offset)->get("bibalb");
		}
		// recuperer les enregistrements
		$records = array();
		foreach ($query->result_array() as $row) {
			$records[] = $row;
		}
		return $records;
	}
}

/**
 * Recupere le nombre d'enregistrements
 * @param object $db database object
 * @return int
 */
if (!function_exists('getCountAlbumsFromDB')) {
	function getCountAlbumsFromDB($db) {
		return $db->count_all("bibalb");
	}
}

/**
 * Insere un nouvel enregistrement
 */
if (!function_exists('insertNewAlbum')) {
	function insertNewAlbum($db, $alblbtit, $albreext, $albiddes, $albidsce, $albidgen) {
		$data=array( 'alblbtit'=>$alblbtit, 'albreext'=>$albreext, 'albiddes'=>$albiddes, 'albidsce'=>$albidsce, 'albidgen'=>$albidgen);
		log_message('debug','[album_helper.php] : insertNewAlbum with data:'. print_r($data, true) );
		$db->insert('bibalb',$data);
		return $db->insert_id();
	}
}


/**
 * Mise a jour d'un enregistrement
 */
if (!function_exists('updateAlbum')) {
	function updateAlbum($db, $albidalb , $alblbtit, $albreext, $albiddes, $albidsce, $albidgen) {
		$data = array('alblbtit'=>$alblbtit, 'albreext'=>$albreext, 'albiddes'=>$albiddes, 'albidsce'=>$albidsce, 'albidgen'=>$albidgen);
		$db->where('albidalb', $albidalb);
		log_message('debug','[album_helper.php] : updateAlbum with data:'. print_r($data, true) );
		$db->update('bibalb', $data);
	}
}


/**
 * Suppression d'un enregistrement
 */
if (!function_exists('deleteAlbum')) {
	function deleteAlbum($db, $albidalb) {
		$db->delete('bibalb', array('albidalb'=>$albidalb)); 
	}
}


/**
 * Recupere les informations d'un enregistrement
 * @param object $db database object
 * @param int id de l'enregistrement
 * @return array
 */
if (!function_exists('getAlbumRow')) {
	function getAlbumRow($db, $albidalb) {
		$query = $db->get_where('bibalb', array('albidalb' => $albidalb));
		if ($query->num_rows() != 1) {
			return null;
		}
		return $query->row_array();
	}
}



/**
 * Recupere la liste des enregistrements depuis une valeur du champ alblbtit
 * @param object $db database object
 * @return array of data
 */
if (!function_exists('getAllAlbumsFromDBBy_alblbtit')) {
	function getAllAlbumsFromDBBy_alblbtit($db, $alblbtit, $limit = null, $offset = null) {
		$query = $db->from("bibalb")->limit($limit, $offset)->like('alblbtit', $alblbtit)->get();
		// recuperer les enregistrements
		$records = array();
		foreach ($query->result_array() as $row) {
			$records[] = $row;
		}
		return $records;
	}
}

/**
 * Recupere la liste des enregistrements depuis une valeur du champ albreext
 * @param object $db database object
 * @return array of data
 */
if (!function_exists('getAllAlbumsFromDBBy_albreext')) {
	function getAllAlbumsFromDBBy_albreext($db, $albreext, $limit = null, $offset = null) {
		$query = $db->from("bibalb")->limit($limit, $offset)->like('albreext', $albreext)->get();
		// recuperer les enregistrements
		$records = array();
		foreach ($query->result_array() as $row) {
			$records[] = $row;
		}
		return $records;
	}
}

/**
 * Recupere la liste des enregistrements depuis la cle etrangere Album->albiddes ==> Auteur->autidaut
 * @param object $db database object
 * @return array of data
 */
if (!function_exists('getAllAlbumsForAuteurFromDBBy_albiddes')) {
	function getAllAlbumsForAuteurFromDBBy_albiddes($db, $autidaut, $orderBy = null, $asc = null, $limit = null, $offset = null) {
		if( $orderBy != null ){
			if($asc != null) {
				$db->order_by($orderBy, $asc);
			}else {
				$db->order_by($orderBy, "asc");
			}
		}
		if( $limit == null ) {
			$query = $db->get_where("bibalb", array('albiddes' => $autidaut));
		} else {
			$query = $db->limit($limit, $offset)->get_where("bibalb", array('albiddes' => $autidaut));
		}
		// recuperer les enregistrements
		$records = array();
		foreach ($query->result_array() as $row) {
			$records[] = $row;
		}
		return $records;
	}
}

/**
 * Recupere la liste des enregistrements depuis la cle etrangere Album->albidsce ==> Auteur->autidaut
 * @param object $db database object
 * @return array of data
 */
if (!function_exists('getAllAlbumsForAuteurFromDBBy_albidsce')) {
	function getAllAlbumsForAuteurFromDBBy_albidsce($db, $autidaut, $orderBy = null, $asc = null, $limit = null, $offset = null) {
		if( $orderBy != null ){
			if($asc != null) {
				$db->order_by($orderBy, $asc);
			}else {
				$db->order_by($orderBy, "asc");
			}
		}
		if( $limit == null ) {
			$query = $db->get_where("bibalb", array('albidsce' => $autidaut));
		} else {
			$query = $db->limit($limit, $offset)->get_where("bibalb", array('albidsce' => $autidaut));
		}
		// recuperer les enregistrements
		$records = array();
		foreach ($query->result_array() as $row) {
			$records[] = $row;
		}
		return $records;
	}
}

/**
 * Recupere la liste des enregistrements depuis la cle etrangere Album->albidgen ==> Genre->genidgen
 * @param object $db database object
 * @return array of data
 */
if (!function_exists('getAllAlbumsForGenreFromDBBy_albidgen')) {
	function getAllAlbumsForGenreFromDBBy_albidgen($db, $genidgen, $orderBy = null, $asc = null, $limit = null, $offset = null) {
		if( $orderBy != null ){
			if($asc != null) {
				$db->order_by($orderBy, $asc);
			}else {
				$db->order_by($orderBy, "asc");
			}
		}
		if( $limit == null ) {
			$query = $db->get_where("bibalb", array('albidgen' => $genidgen));
		} else {
			$query = $db->limit($limit, $offset)->get_where("bibalb", array('albidgen' => $genidgen));
		}
		// recuperer les enregistrements
		$records = array();
		foreach ($query->result_array() as $row) {
			$records[] = $row;
		}
		return $records;
	}
}



	/***************************************************************************
	 * USER DEFINED FUNCTIONS
	 ***************************************************************************/


?>