PHP Companynewses::findCount Examples

Example #1

File: news.php Project: vuong93st/w-game

            $res = $companynews->read("Companynews.id AS ID,title AS Title,content AS Content,type_id,created AS CreateDate", $id);
            setvar("item", $res);
            setvar("ShowCaption", "none");
        }
        $tpl_file = "news_edit";
        template($tpl_file);
        exit;
    }
}
if (isset($_POST['save'])) {
    pb_submit_check('title');
    $vals = null;
    $vals['title'] = trim($_POST['title']);
    $vals['content'] = trim($_POST['content']);
    $vals['type_id'] = $_POST['type_id'];
    $now_companynews_amount = $companynews->findCount(null, "created>" . $today_start . " AND member_id=" . $_SESSION['MemberID']);
    if ($g['companynews_check']) {
        $vals['status'] = 0;
        $msg = 'msg_wait_check';
    } else {
        $vals['status'] = 1;
        $msg = 'success';
    }
    if (!empty($_POST['newsid'])) {
        $vals['modified'] = $time_stamp;
        $companynews->save($vals, "update", $_POST['newsid'], null, "member_id=" . $_SESSION['MemberID']);
        pheader("location:news.php?action=list");
    } else {
        if ($g['max_companynews'] && $now_companynews_amount >= $g['max_companynews']) {
            flash('one_day_max');
        }

Example #2

File: news.php Project: reboxhost/phpb2b

            $res = $companynews->read("Companynews.id AS ID,title AS Title,content AS Content,type_id,created AS CreateDate", $id);
            setvar("item", $res);
            setvar("ShowCaption", "none");
        }
        $tpl_file = "news_edit";
        vtemplate($tpl_file);
        exit;
    }
}
if (isset($_POST['save'])) {
    pb_submit_check('title');
    $vals = null;
    $vals['title'] = trim($_POST['title']);
    $vals['content'] = trim($_POST['content']);
    $vals['type_id'] = $_POST['type_id'];
    $now_companynews_amount = $companynews->findCount(null, "created>" . $today_start . " AND member_id=" . $the_memberid);
    if ($g['companynews_check']) {
        $vals['status'] = 0;
        $msg = 'msg_wait_check';
    } else {
        $vals['status'] = 1;
        $msg = 'success';
    }
    if (!empty($_POST['newsid'])) {
        $vals['modified'] = $time_stamp;
        unset($vals['created']);
        $companynews->save($vals, "update", $_POST['newsid'], null, "member_id=" . $the_memberid);
        pheader("location:news.php?action=list");
    } else {
        if ($g['max_companynews'] && $now_companynews_amount >= $g['max_companynews']) {
            flash('one_day_max');

Example #3

File: companynews.php Project: reboxhost/phpb2b

        if (!empty($_GET['companyname'])) {
            $conditions[] = "Company.company_name like '%" . $_GET['companyname'] . "%'";
        }
    }
    if ($do == "view") {
        if ($id) {
            $news_info = $pdb->GetRow("SELECT cn.*,c.name companyname FROM {$tb_prefix}companynewses cn LEFT JOIN {$tb_prefix}companies c ON c.id=cn.company_id WHERE cn.id=" . $id);
            setvar("item", $news_info);
        }
        $tpl_file = "companynews.view";
        template($tpl_file);
        exit;
    }
}
if (isset($_GET['q'])) {
    $conditions[] = "title like '%" . $_GET['q'] . "%'";
}
$fields = "company_id,Companynews.id,Companynews.title,Companynews.status,Companynews.status as CompanynewsStatus,Companynews.created,Companynews.clicked,c.name AS companyname";
$amount = $companynews->findCount(null, $conditions, "Companynews.id");
$page->setPagenav($amount);
$joins[] = "LEFT JOIN {$tb_prefix}companies c ON c.id=Companynews.company_id";
$result = $companynews->findAll($fields, $joins, $conditions, "Companynews.id DESC ", $page->firstcount, $page->displaypg);
if (!empty($result)) {
    for ($i = 0; $i < count($result); $i++) {
        $result[$i]['pubdate'] = df($result[$i]['created']);
        $result[$i]['common_status'] = $common_status[$result[$i]['status']];
    }
    setvar("Items", $result);
}
uaAssign(array("ByPages" => $page->pagenav, "TotalAmount" => $amount));
template($tpl_file);