PHP Management::Custom Examples

Example #1

File: User.php Project: indra012patel/gventure_framework

 public function GetTariff()
 {
     if (LEVEL <= 5) {
         $this->sql = "(SELECT u.`idtariff`,'Base Tariff' `name` FROM `user` u WHERE id=" . USERID . ") UNION (SELECT t.`id`,`name` FROM tariff_name t JOIN tariff_user tu ON t.id=tu.id_tariffname WHERE iduser="******")";
     } else {
         $this->sql = "SELECT t.`id` `idtariff`,`name` FROM tariff_name t join tariff_user tu on t.id=tu.id_tariffname WHERE iduser="******"";
     }
     $data = parent::Custom();
     foreach ($data as $val) {
         $tmp[$val["idtariff"]] = $val["name"];
     }
     return $tmp;
 }