function AllInflowProject()
{
global $db;
$keyword = be("get", "keyword");
// $from= be("get","playfrom");
// $project = be("get","cj_vod_projects");
$where = " status=1 ";
if (!isN($keyword)) {
$keyword = trim($keyword);
$where .= " AND (package_name like '%" . $keyword . "%' or app_name like '%" . $keyword . "%') ";
}
$status = be("all", "status");
if (!isNum($status)) {
$status = 0;
} else {
$status = intval($status);
}
if ($status != 0) {
$where .= " and status=" . $status;
}
$state = be("all", "state");
if (!isNum($state)) {
$state = 0;
} else {
$state = intval($state);
}
if ($state != 0) {
$where .= " and state=" . $state;
}
//var_dump($where);
$count = $db->getOne("Select count(id) as cc from apk_master_temp where " . $where);
$sql = "select * from apk_master_temp where " . $where;
MovieInflow($sql, $count);
}
function noInflow()
{
global $db;
$count = $db->getOne("Select count(m_id) as cc from {pre}cj_art where m_zt=0 and m_typeid>0");
$sql = "select * from {pre}cj_art where m_zt=0 and m_typeid>0";
MovieInflow($sql, $count);
}
function collect($crontab)
{
writetofile("crawler_collect.sql", 'collect start.');
global $db;
$time = date("Y-m-d");
$count = $db->getOne("SELECT count(*) FROM mac_cj_zhuiju where status=0 and crontab_desc like'%" . $crontab . "%' ");
$sql = "select a.* from {pre}cj_vod as a , mac_cj_zhuiju as b where a.m_id= b.m_id and b.crontab_desc like'%" . $crontab . "%' and a.m_typeid>0 and a.m_name IS NOT NULL AND a.m_addtime like'%" . $time . "%' and a.m_name != '' and a.m_playfrom not in ('tudou','kankan','cntv','wasu')";
MovieInflow($sql, $count, true);
writetofile("crawler_collect.sql", 'collect stop.');
}
function noInflowProject()
{
global $db;
$keyword = be("get", "keyword");
$from = be("get", "playfrom");
$project = be("get", "cj_vod_projects");
$where = " and m_playfrom not in ('tudou','kankan','cntv','wasu') ";
if ($keyword != "") {
$where = $where . " and m_name like '%" . $keyword . "%' ";
}
if ($project != "") {
$where = $where . " and m_pid = " . $project;
}
if ($from != "") {
$where = $where . " and m_playfrom ='" . $from . "' ";
}
$count = $db->getOne("Select count(m_id) as cc from {pre}cj_vod where m_zt=0 and m_typeid>0 and m_name IS NOT NULL AND m_name != '' " . $where);
$sql = "select * from {pre}cj_vod where m_zt=0 and m_typeid>0 and m_name IS NOT NULL AND m_name != '' " . $where;
//var_dump($count); var_dump($sql);
MovieInflow($sql, $count, false);
}
