function reset($_oh, $_aid)
{
$c = new Query();
$c->value("apply_id", "");
$c->where_eq("oh_id", $_oh);
$c->where_eq("apply_id", $_aid);
$this->update($c);
}
function del_by_user($_cid, $_uid)
{
$this->debug();
$c = new Query();
$c->where_eq("user_id", $_uid);
$c->where_eq("id", $_cid);
$this->delete_cond($c);
}
function get_by_form($_aid, $_eid)
{
// $this->debug();
$c = new Query();
$c->where_eq("apply_id", $_aid);
$c->where_eq("form_id", $_eid);
$res = $this->fetch_one("*", $c);
return $res;
}
function get_follower($_type = '', $_id = '')
{
// $this->debug();
$c = new Query();
$c->where_eq("follower", $_id);
if ($_type) {
$c->where_eq("type", $_type);
}
$res = $this->fetch("*", $c);
return $res;
}
function edit_by_fb($_arr)
{
$c = new Query();
$c->value("ids", $_arr["ids"]);
$c->value("secret", $_arr["secret"]);
$c->value("date_created", "now()", 1);
if ($_arr["public"]) {
$c->value("public", $_arr["public"]);
}
$c->where_eq("user_id", $_arr["user_id"]);
$c->where_eq("type", $_arr["type"]);
$this->update($c);
}
function cnt_by_opt($_tid, $_cid, $_where = '')
{
// $this->debug();
$c = new Query();
$c->from = "recruit r, recruit_opt ro";
$c->where("ro.recruit_id = r.id");
$c->where_eq("code_type", $_tid);
$c->where_eq("code_id", $_cid);
if ($_where) {
$c->where($_where);
}
$res = $this->counts($c);
return $res;
}
function check($_type)
{
$c = new Query();
$c->where_eq("name", $_type);
$res = $this->fetch_one("id", $c);
return $res;
}
function edit($_id, $_state)
{
$c = new Query();
$c->value("visible", $_state);
$c->where_eq("id", $_id);
$this->update($c);
}
function del_form_res($_aid)
{
$c = new Query();
$c->from = "competitions_form_res";
$c->where_eq("apply_id", $_aid);
$this->delete_cond($c);
}
function add($_arr)
{
// $this->debug();
$c = new Query();
$c->value("dates", $_arr["dates"]);
$c->value("times", $_arr["times"]);
$c->value("url", $_arr["url"]);
$c->value("img", $_arr["img"]);
$c->value("title", str_replace('\'', '\'', $_arr["title"]));
$c->value("subtitle", str_replace('\'', '\'', $_arr["subtitle"]));
$c->value("author", str_replace('\'', '\'', $_arr["author"]));
$c->value("publisher", str_replace('\'', '\'', $_arr["publisher"]));
$c->value("c_date", $_arr["c_date"]);
$c->value("tags", str_replace('\'', '\'', $_arr["tags"]));
$c->value("mento_img", $_arr["mento_img"]);
$c->value("mento_name", str_replace('\'', '\'', $_arr["mento_name"]));
$c->value("mento_endor", str_replace('\'', '\'', $_arr["mento_endor"]));
if ($_arr["id"]) {
$c->where_eq("id", $_arr["id"]);
$this->update($c);
$id = $_REQUEST["id"];
} else {
$this->insert($c);
$id = $this->last_id();
}
return $id;
}
function add_error($_id)
{
$c = new Query();
$c->where_eq('id', $_id);
$c->value('error_cnt', 'error_cnt+1', true);
$this->update($c);
}
function get_by_mento($_id)
{
// $this->debug();
$c = new Query();
$c->where_eq("mento_id", $_id);
$res = $this->fetch("*", $c);
return $res;
}
function edit($_id, $_type, $_cid)
{
$c = new Query();
$c->value("type", $_type);
$c->value("cid", $_cid);
$c->where_eq("id", $_id);
$this->update($c);
}
function get_by_mento($_id)
{
$c = new Query();
$c->where_eq("mento_id", $_id);
$c->order = "id ASC";
$res = $this->fetch("*", $c);
return $res;
}
function get_by_apply($_id)
{
$c = new Query();
$c->where_eq("apply_id", $_id);
$c->order = "id ASC";
$res = $this->fetch("file", $c);
return $res;
}
function get_by_comp($_id)
{
// $this->debug();
$c = new Query();
$c->where_eq("competition_id", $_id);
$c->order = "id ASC";
$res = $this->fetch("*", $c);
return $res;
}
function add($_label)
{
// $this->debug();
$c = new Query();
$c->where_eq("label", $_label);
$res = $this->fetch_one("id", $c);
$id = $res["id"];
if (!$res) {
$d = new Query();
$d->value("label", $_label);
$this->insert($d);
$id = $this->last_id();
}
return $id;
}
function add($_arr)
{
$c = new Query();
$c->value("type", $_arr["type"]);
$c->value("name", $_arr["name"]);
$c->value("opt", $_arr["opt"]);
$c->value("start", $_arr["start"]);
$c->value("end", $_arr["end"]);
$c->value("days", $_arr["days"]);
$c->value("visible", $_arr["visible"]);
if ($_REQUEST["id"]) {
$c->where_eq("id", $_REQUEST["id"]);
$this->update($c);
} else {
$c->value("date_created", "now()", 1);
$this->insert($c);
}
}
function signout($_id)
{
$c = new Query();
$c->from = "office_hours h, office_mento m";
$c->where("m.id = h.mento_id");
$c->where_eq("m.user_id", $_id);
$this->delete_cond($c);
}
function get_one($_id)
{
$c = new Query();
$c->where_eq("type", $_id);
return $this->fetch_one("*", $c);
}
function signout($_id)
{
$c = new Query();
$c->where_eq("user_id", $_id);
$this->delete_cond($c);
}
function check_cat_u($_id, $_cat = '')
{
// $this->debug();
$c = new Query();
$c->from = "faq_category";
$c->where_eq("user_id", $_id);
if ($_cat) {
$c->where_eq("id", $_cat);
}
$res = $this->fetch_one("id", $c);
return $res["id"];
}
function add_login($_id)
{
$c = new Query();
$c->value("last_login", "now()", 1);
$c->where_eq("id", $_id);
$this->update($c);
}
function del_cont($_id)
{
// $this->debug();
$c = new Query();
$c->from = "newsletter_cont";
$c->where_eq("newsl_id", $_id);
$this->delete_cond($c);
}
function check_first($_uid)
{
$this->debug();
$c = new Query();
$c->where_eq("is_mailed", 1);
$c->where_eq("user_id", $_uid);
$res = $this->fetch_one("id", $c);
return $res["id"];
}
function delete_by_id_user($id_user)
{
$c = new Query();
$c->where_eq('user_id', $id_user);
return $this->delete($c);
}
function del($_user)
{
$c = new Query();
$c->where_eq("startup_id", $_user);
$this->delete_cond($c);
}
function del_file($_cid)
{
$c = new Query();
$c->where_eq("competition_id", $_cid);
$this->delete_cond($c);
}
function del_article($_id)
{
$c = new Query();
$c->from = "startup_service_article";
$c->where_eq("service_id", $_id);
$this->delete_cond($c);
}
function del_file_res($_cid)
{
$c = new Query();
$c->from = "program_file_res";
$c->where_eq("apply_id", $_cid);
$this->delete_cond($c);
}
