public function update_image_students() { $this->use->use_model('data_base'); $this->use->use_lib('table/tpl_students'); $this->use->use_lib('system/image/class_upload_image'); $tpl = new tpl_students(); $image = new class_upload_image('image_students_update', 'include/img/student'); if ($image->get_type() == 'image/png' || $image->get_type() == 'image/jpeg') { if ($image->get_error()) { $image_path = $image->move_file(); if ($image_path == false) { echo json_encode(array('valid' => false)); } else { $db = new data_base($tpl->table(), array($tpl->image() => $image_path), array($tpl->id() => $_POST['id_image_update'])); if ($db->change()) { echo json_encode(array('valid' => true, 'image' => $image_path)); } else { echo json_encode(array('valid' => false)); } } } else { echo json_encode(array('valid' => false)); } } else { echo json_encode(array('valid' => false)); } }
public function get_more_election() { $this->use->use_model('data_base'); $this->use->use_lib('table/tpl_students'); $this->use->use_lib('table/tpl_election'); $this->use->use_lib('table/tpl_specialty'); $this->use->use_lib('table/tpl_college'); $tpl = new tpl_students(); $tpl_college = new tpl_college(); $tpl_specialty = new tpl_specialty(); $tpl_election = new tpl_election(); $db = new data_base($tpl->table(), array($tpl->id(), $tpl->last_name(), $tpl->first_name(), '( select ' . $tpl_college->name() . ' from ' . $tpl_college->table() . ' where ' . $tpl_college->id() . ' = ' . $tpl->table() . '.' . $tpl->id_college() . ' ) ' . $tpl->id_college(), '( select ' . $tpl_specialty->name() . ' from ' . $tpl_specialty->table() . ' where ' . $tpl_specialty->id() . ' = ' . $tpl->table() . '.' . $tpl->id_specialty() . ' ) ' . $tpl->id_specialty(), '( select COUNT(' . $tpl_election->id() . ') from ' . $tpl_election->table() . ' where ' . $tpl_election->id_elect() . ' = ' . $tpl->table() . '.' . $tpl->id() . ' ) sum', $tpl->id_students(), $tpl->image()), array($tpl->elect() => 1), '', array('sum' => 'DESC')); return $db->get_where_order(); }