Beispiel #1
0
 static function for_query($query)
 {
     $db = Get::db('songwork');
     $res = array();
     $db->query($query);
     while ($x = $db->next_record()) {
         $res[$x['id']] = new Consultation($x);
     }
     return $res;
 }
Beispiel #2
0
 static function popular()
 {
     $db = Get::db('songwork');
     $res = array();
     $db->query("SELECT id, name, COUNT(*) FROM documents_tags LEFT JOIN tags ON documents_tags.tag_id=tags.id GROUP BY id, name ORDER BY COUNT(*) DESC");
     while ($x = $db->next_record()) {
         $res[$x['id']] = new Tag($x);
     }
     return $res;
 }
Beispiel #3
0
 static function get_by_person($p)
 {
     if (!is_a($p, 'Person') || intval($p->id) == 0) {
         return false;
     }
     $db = Get::db('songwork');
     $db->query("SELECT * FROM admins WHERE person_id=" . $p->id);
     if ($db->num_rows() == 0) {
         return false;
     }
     $x = new Administrator($db->next_record());
     $x->set_person($p);
     return $x;
 }
Beispiel #4
0
 function __construct($id_or_array)
 {
     $this->db = Get::db($this->dbname);
     if (is_array($id_or_array)) {
         $this->me = $id_or_array;
         $this->id = intval($id_or_array['id']);
     } elseif (is_int($id_or_array) || is_string($id_or_array) && ctype_digit($id_or_array)) {
         $this->id = intval($id_or_array);
         $this->db->query("SELECT * FROM {$this->tablename} WHERE id=" . $this->id);
         if ($this->db->num_rows() == 0) {
             $this->failed = true;
         }
         $this->me = $this->db->next_record();
     }
 }
Beispiel #5
0
 function testCookie()
 {
     $p = new Person(3);
     $p->set_auth();
     # get what the cookie would have been
     $db = Get::db('songwork');
     $db->query("SELECT * FROM logins WHERE person_id=3");
     $x = $db->next_record();
     $cookie_value = $x['cookie_id'] . ':' . $x['cookie_tok'];
     $_COOKIE['ok'] = $cookie_value;
     $p = Person::get_by_cookie();
     $this->assertType('Person', $p);
     $this->assertEquals(3, $p->id);
     $this->assertEquals('Yoko', $p->firstname());
     $_COOKIE['ok'] = $cookie_value . 'x';
     $p = Person::get_by_cookie();
     $this->assertFalse($p);
 }
Beispiel #6
0
 static function with_ids($array_of_ids)
 {
     # clean incoming array, just in case of bad info
     $real_ids = array();
     foreach ($array_of_ids as $maybe_id) {
         if (is_integer($maybe_id) || is_string($maybe_id) && ctype_digit($maybe_id)) {
             $real_ids[] = intval($maybe_id);
         }
     }
     if (count($real_ids) == 0) {
         return array();
     }
     $db = Get::db('songwork');
     $res = array();
     $db->query("SELECT * FROM persons WHERE id IN (" . join(',', $real_ids) . ")");
     while ($x = $db->next_record()) {
         $res[$x['id']] = new Person($x);
     }
     return $res;
 }
Beispiel #7
0
 static function pulldown_for_currency($currency)
 {
     if (!Currency::is_valid($currency)) {
         return false;
     }
     $res = array();
     $db = Get::db('songwork');
     $db->query("SELECT code, millicents FROM pricerefs WHERE currency='{$currency}' ORDER BY millicents ASC");
     while ($x = $db->next_record()) {
         $m = new Money($x['millicents'], $currency);
         $res[$x['code']] = $m->show_with_code();
     }
     return $res;
 }
Beispiel #8
0
 static function consultable()
 {
     $db = Get::db('songwork');
     $res = array();
     $db->query("SELECT * FROM teachers WHERE available='t' ORDER BY id ASC");
     while ($x = $db->next_record()) {
         $res[$x['id']] = new Teacher($x);
     }
     return $res;
 }
Beispiel #9
0
 static function all()
 {
     $db = Get::db('songwork');
     $res = array();
     $db->query("SELECT * FROM students ORDER BY id DESC");
     while ($x = $db->next_record()) {
         $res[$x['id']] = new Student($x);
     }
     return $res;
 }