static function get_option($selectedvalue, $tablename="pays", $colvaluename="id", $colvuename="nom", $where=1) {
$option = "";
$result = CTable::select($colvaluename . " , " . $colvuename, $tablename, $where, $colvuename);
while($array = mysql_fetch_array($result)) {
$selected = CForm::get_selected($selectedvalue, $array[$colvaluename]);
$option = $option . "<option value='" . $array[$colvaluename] . "'" . $selected . ">" . ucfirst(utf8_encode(substr($array[$colvuename], 0, 25))) . "</option>\n";
}
return $option;
}
static function get_option($selectedvalue, $tablename, $colvaluename="id", $colvuename="nom", $where=1, $order = null) {
$option = "";
if(!$order) {
$order = $colvuename;
}
$result = CTable::select($colvaluename . " , " . $colvuename, $tablename, $where, $order);
while($array = mysql_fetch_array($result)) {
$selected = CForm::get_selected($selectedvalue, $array[$colvaluename]);
$option = $option . "<option value='" . $array[$colvaluename] . "'" . $selected . ">" . $array[$colvuename] . "</option>\n";
}
return $option;
}
static function fetchAll($select="*", $where="1", $order="mlt_zMail, mlt_zDateCreation") {
$oRes = parent::select($select, 'moul_tables', $where, COrder::formate($order));
$toResults = array() ;
if ($oRes){
while ($toRes = mysql_fetch_assoc($oRes)){
$toResults[] = $toRes ;
}
}
return $toResults ;
}
static function select($select="*", $where="1", $order="rang") {
return parent::select($select, 'categorie_user', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="id") {
return parent::select($select, 'image', $where, COrder::formate($order));
}
static function select($select="*", $where, $order="id") {
if(empty($order)) $order = "id";
return parent::select($select, 'rdvContact', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="id") {
if(empty($order)) $order = "id";
// return parent::select($select, 'gr_rdv_user', $where, COrder::formate($order));
return parent::select($select, 'gr_rdv', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="rang") {
return parent::select($select, 'domaine', $where, $order="rang");
}
static function select($select="*", $where="1", $order="nomart, rang") {
return parent::select($select, 'page_art', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="nom") {
return parent::select($select, 'departement', $where, $order);
}
static function select($select="*", $where="id_campagne < 1", $order="id") {
return parent::select($select, 'gr_email', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="id") {
return parent::select($select, 'opportuniteContact', $where, $order);
}
static function select($select="*", $where="1", $order="rang") {
return parent::select($select, 'article_cat', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="id") {
return parent::select($select, 'groupeUtilitaire', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="nom_com"){
return parent::select($select, 'commune', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="id desc") {
if(empty($order)) $order = "id desc";
return parent::select($select, 'user', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="DESC") {
if(empty($order)) $order = "DESC";
return parent::select($select, 'entreprise', $where, COrder::formate($order));
}
static function select($select="*", $where="1", $order="nom") {
return parent::select($select, 'configuration', $where, $order="nom");
}
