Exemplo n.º 1
0
 public static function getMethodsByProfileGateway($profile_id, $gateway_id)
 {
     if (!$profile_id) {
         return array();
     }
     $db = self::$_msql = SafeMySQL::getInstance();
     $sql = "SELECT \n\t\t\t\t  pg.method_id\n\t\t\t\t, m.method_name\n\t\t\tFROM \n\t\t\t\tprofiles_gateways as pg\n\t\t\t\tleft join methods as m using(method_id)\n\t\t\tWHERE \n\t\t\t  \tpg.profile_id = ?i\n\t\t\t\tand pg.gateway_id = ?i";
     return $db->getAll($sql, $profile_id, $gateway_id);
 }