Esempio n. 1
0
 function add($data)
 {
     if (!isset($data['course_id']) || !isset($data['user_id']) || !isset($data['request_id']) && !isset($data['plan_id'])) {
         throw new Exception("No data", self::NO_DATA);
     }
     $data['created'] = date('Y-m-d H:i:s', time());
     return parent::add($data);
 }
Esempio n. 2
0
 function add($data)
 {
     if (!isset($data['question_id']) || !isset($data['training_id'])) {
         throw new Exception("No data", self::NO_DATA);
     }
     $db = new DB();
     $db->select("SELECT * FROM {$this->tablename} WHERE question_id=\$1 AND training_id=\$2", array($data['question_id'], $data['training_id']));
     if ($db->valid()) {
         throw new Exception("Exam exists", self::EXISTS);
     }
     return parent::add($data);
 }
Esempio n. 3
0
 function add($data)
 {
     if (!isset($data['name']) || !isset($data['email'])) {
         throw new Exception("No data", self::NO_DATA);
     }
     $db = new DB();
     $db->select("SELECT * FROM {$this->tablename} WHERE name=\$1", array($data['name']));
     if ($db->valid()) {
         throw new Exception("Trainer exists", self::EXISTS);
     }
     return parent::add($data);
 }
Esempio n. 4
0
 function add($data)
 {
     if (!isset($data['course_id']) || !isset($data['type_id']) || !isset($data['data']) || !isset($data['answer'])) {
         throw new Exception("No data", self::NO_DATA);
     }
     $db = new DB();
     $db->select("SELECT * FROM {$this->tablename} WHERE data=\$1 AND type_id=\$2", array($data['data'], $data['type_id']));
     if ($db->valid() && 0) {
         throw new Exception("Question exists", self::EXISTS);
     }
     $data['created'] = date('Y-m-d H:i:s', time());
     return parent::add($data);
 }
Esempio n. 5
0
 function add($data)
 {
     if (!isset($data['name']) || !isset($data['category_id']) || !isset($data['format_id']) || !isset($data['language']) || !isset($data['describe'])) {
         throw new Exception("No data", self::NO_DATA);
     }
     $db = new DB();
     $db->select("SELECT * FROM {$this->tablename} WHERE name=\$1 AND category_id=\$2 AND language=\$3", array($data['name'], $data['category_id'], $data['language']));
     if ($db->valid()) {
         throw new Exception("Course exists", self::EXISTS);
     }
     $data['created'] = date('Y-m-d H:i:s', time());
     $data['author_id'] = $_SESSION['user_id'];
     $data['category_name'] = $this->getCategoryName($data['category_id']);
     return parent::add($data);
 }
Esempio n. 6
0
 function add($data)
 {
     if (!isset($data['first_name']) || !isset($data['last_name']) || !isset($data['email']) || !isset($data['password']) || !isset($data['company']) || !isset($data['position']) || !isset($data['country']) || !isset($data['city']) || !isset($data['phone'])) {
         throw new Exception("No data", self::NO_DATA);
     }
     if (sizeof($data['password']) < 6 && $data['password'] != $data['password_confirmation']) {
         throw new Exception('Bad password', self::BAD_PASSWORD);
     }
     $db = new DB();
     $db->select("SELECT * FROM {$this->tablename} WHERE email=\$1", array($data['email']));
     if ($db->valid()) {
         throw new Exception("User exists", self::EXISTS);
     }
     $data['name'] = $data['last_name'] . ' ' . $data['first_name'];
     $data['created'] = date('Y-m-d H:i:s', time());
     $data['active'] = 'true';
     if (auto_user_approve == 'y') {
         $data['role_id'] = self::USER;
     }
     return parent::add($data);
 }