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
***************************************************************************/
?>