PHP report_datagrid Examples

Example #1

File: loan_history.php Project: sulfan/SENAYAN-3-Stable-jQuery

    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'loan AS l
    LEFT JOIN member AS m ON l.member_id=m.member_id
    LEFT JOIN item AS i ON l.item_code=i.item_code
    LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('m.member_id AS \'' . __('Member ID') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'l.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', 'l.loan_date AS \'' . __('Loan Date') . '\'', 'l.due_date AS \'' . __('Due Date') . '\'', 'l.is_return AS \'' . __('Loan Status') . '\'');
    $reportgrid->setSQLorder('l.loan_date DESC');
    $criteria = 'm.member_id IS NOT NULL ';
    if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {
        $id_name = $dbs->escape_string($_GET['id_name']);
        $criteria .= ' AND (m.member_id LIKE \'%' . $id_name . '%\' OR m.member_name LIKE \'%' . $id_name . '%\')';
    }
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%') AND";
            }

Example #2

File: loan_history.php Project: purwoko/SENAYAN-3-Stable

    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'loan AS l
    LEFT JOIN member AS m ON l.member_id=m.member_id
    LEFT JOIN item AS i ON l.item_code=i.item_code
    LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('m.member_id AS \'' . lang_mod_membership_field_member_id . '\'', 'm.member_name AS \'' . lang_mod_membership_field_name . '\'', 'l.item_code AS \'' . lang_mod_biblio_item_field_itemcode . '\'', 'b.title AS \'' . lang_mod_biblio_field_title . '\'', 'l.loan_date AS \'' . lang_mod_circ_tblheader_loan_date . '\'', 'l.due_date AS \'' . lang_mod_circ_tblheader_due_date . '\'', 'l.is_return AS \'' . lang_mod_biblio_item_common_status_description . '\'');
    $reportgrid->setSQLorder('l.loan_date DESC');
    $criteria = 'm.member_id IS NOT NULL ';
    if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {
        $id_name = $dbs->escape_string($_GET['id_name']);
        $criteria .= ' AND (m.member_id LIKE \'%' . $id_name . '%\' OR m.member_name LIKE \'%' . $id_name . '%\')';
    }
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%') AND";
            }

Example #3

File: staff_act.php Project: ridorido/s3st15_matoa

    </div>
    </form>
    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'user AS u';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('u.realname AS \'' . __('Real Name') . '\'', 'u.username AS \'' . __('Login Username') . '\'', 'u.user_id AS \'' . __('Bibliography Data Entry') . '\'', 'u.user_id AS \'' . __('Item Data Entry') . '\'', 'u.user_id AS \'' . __('Member Data Entry') . '\'', 'u.user_id AS \'' . __('Circulation Tasks') . '\'');
    $reportgrid->setSQLorder('realname ASC');
    // is there any search
    $criteria = 'user_id IS NOT NULL ';
    $reportgrid->setSQLCriteria($criteria);
    $start_date = '2000-01-01';
    if (isset($_GET['startDate'])) {
        $start_date = $_GET['startDate'];
    }
    $until_date = date('Y-m-d');
    if (isset($_GET['untilDate'])) {
        $until_date = $_GET['untilDate'];
    }
    // callbacks
    function showBiblioEntries($obj_db, $array_data)

Example #4

File: overdued_list.php Project: ridorido/s3st15_matoa

    </form>
    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'member AS m
        LEFT JOIN loan AS l ON m.member_id=l.member_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('m.member_id AS \'' . __('Member ID') . '\'');
    $reportgrid->setSQLorder('l.due_date DESC');
    $reportgrid->sql_group_by = 'm.member_id';
    $overdue_criteria = ' (l.is_lent=1 AND l.is_return=0 AND TO_DAYS(due_date) < TO_DAYS(\'' . date('Y-m-d') . '\')) ';
    // is there any search
    if (isset($_GET['id_name']) and $_GET['id_name']) {
        $keyword = $dbs->escape_string(trim($_GET['id_name']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' (';
            foreach ($words as $word) {
                $concat_sql .= " (m.member_id LIKE '%{$word}%' OR m.member_name LIKE '%{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);

Example #5

File: reserve_list.php Project: purwoko/SENAYAN-3-Stable

" style="margin-top: 9px; margin-left: 5px; margin-right: 5px;"
    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'reserve AS r
        LEFT JOIN biblio AS b ON r.biblio_id=b.biblio_id
        LEFT JOIN member AS m ON r.member_id=m.member_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('r.item_code AS \'' . lang_mod_biblio_item_field_itemcode . '\'', 'b.title AS \'' . lang_mod_biblio_field_title . '\'', 'm.member_name AS \'' . lang_mod_membership_field_name . '\'', 'r.reserve_date AS \'' . lang_mod_circ_tblheader_reserve_date . '\'');
    $reportgrid->setSQLorder('r.reserve_date DESC');
    // is there any search
    $criteria = 'r.reserve_id IS NOT NULL ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);
            $concat_sql .= ') ';

Example #6

File: item_titles_list.php Project: edikriting/SENAYAN-3-Stable

    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'item AS i
        LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id
        LEFT JOIN mst_coll_type AS ct ON i.coll_type_id=ct.coll_type_id
        LEFT JOIN mst_item_status AS s ON i.item_status_id=s.item_status_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('i.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', 'ct.coll_type_name AS \'' . __('Collection Type') . '\'', 's.item_status_name AS \'' . __('Item Status') . '\'', 'b.call_number AS \'' . __('Call Number') . '\'', 'i.biblio_id');
    $reportgrid->setSQLorder('b.title ASC');
    // is there any search
    $criteria = 'b.biblio_id IS NOT NULL ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%' OR b.isbn_issn LIKE '%{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);
            $concat_sql .= ') ';

Example #7

File: lost_item_list.php Project: indonesia/slims5_meranti

    </form>
    </div>
    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader reportHeader"><span id="pagingBox"></span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'stock_take_item AS i';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('item_code AS \'' . __('Item Code') . '\'', 'title AS \'' . __('Title') . '\'', 'gmd_name AS \'' . __('GMD') . '\'', 'classification AS \'' . __('Classification') . '\'', 'coll_type_name AS \'' . __('Collection Type') . '\'', 'call_number AS \'' . __('Call Number') . '\'');
    $reportgrid->setSQLorder('title ASC');
    // is there any search
    $criteria = 'status=\'m\' ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%' OR b.isbn_issn LIKE '%{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);
            $concat_sql .= ') ';

Example #8

File: reserve_list.php Project: indonesia/slims5_meranti

    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'reserve AS r
        LEFT JOIN biblio AS b ON r.biblio_id=b.biblio_id
        LEFT JOIN member AS m ON r.member_id=m.member_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('r.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'r.reserve_date AS \'' . __('Reserve Date') . '\'');
    $reportgrid->setSQLorder('r.reserve_date DESC');
    // is there any search
    $criteria = 'r.reserve_id IS NOT NULL ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);
            $concat_sql .= ') ';

Example #9

File: item_usage.php Project: purwoko/SENAYAN-3-Stable

    ?>
" style="margin-top: 9px; margin-left: 5px; margin-right: 5px;"
    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'item AS i
        LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('i.item_code AS \'' . lang_mod_biblio_item_field_itemcode . '\'', 'b.title AS \'' . lang_mod_biblio_field_title . '\'', '\'01\' AS \'' . lang_sys_common_month_short_01 . '\'', '\'02\' AS \'' . lang_sys_common_month_short_02 . '\'', '\'03\' AS \'' . lang_sys_common_month_short_03 . '\'', '\'04\' AS \'' . lang_sys_common_month_short_04 . '\'', '\'05\' AS \'' . lang_sys_common_month_short_05 . '\'', '\'06\' AS \'' . lang_sys_common_month_short_06 . '\'', '\'07\' AS \'' . lang_sys_common_month_short_07 . '\'', '\'08\' AS \'' . lang_sys_common_month_short_08 . '\'', '\'09\' AS \'' . lang_sys_common_month_short_09 . '\'', '\'10\' AS \'' . lang_sys_common_month_short_10 . '\'', '\'11\' AS \'' . lang_sys_common_month_short_11 . '\'', '\'12\' AS \'' . lang_sys_common_month_short_12 . '\'');
    $reportgrid->setSQLorder('b.title ASC');
    // is there any search
    $criteria = 'b.biblio_id IS NOT NULL ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%' OR b.isbn_issn LIKE '{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);
            $concat_sql .= ') ';

Example #10

File: staff_act.php Project: purwoko/SENAYAN-3-Stable

    echo lang_mod_reporting_form_button_print;
    ?>
" style="margin-top: 9px; margin-left: 5px; margin-right: 5px;"
    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'user AS u';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('u.realname AS \'' . lang_sys_user_field_realname . '\'', 'u.username AS \'' . lang_sys_user_field_login_username . '\'', 'u.user_id AS \'' . lang_mod_report_staffactivity_tblheader_bibliography . '\'', 'u.user_id AS \'' . lang_mod_report_staffactivity_tblheader_items . '\'', 'u.user_id AS \'' . lang_mod_report_staffactivity_tblheader_members . '\'', 'u.user_id AS \'' . lang_mod_report_staffactivity_tblheader_circulation . '\'');
    $reportgrid->setSQLorder('realname ASC');
    // is there any search
    $criteria = 'user_id IS NOT NULL ';
    $reportgrid->setSQLCriteria($criteria);
    $start_date = '2000-01-01';
    if (isset($_GET['startDate'])) {
        $start_date = $_GET['startDate'];
    }
    $until_date = date('Y-m-d');
    if (isset($_GET['untilDate'])) {
        $until_date = $_GET['untilDate'];
    }
    // callbacks
    function showBiblioEntries($obj_db, $array_data)

Example #11

File: member_loan_list.php Project: purwoko/SENAYAN-3-Stable

    echo lang_mod_reporting_form_button_print;
    ?>
" style="margin-top: 9px; margin-left: 5px; margin-right: 5px;"
    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'member AS m LEFT JOIN loan AS l ON m.member_id=l.member_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('m.member_id AS \'' . lang_mod_membership_field_member_id . '\'');
    $reportgrid->setSQLorder('l.due_date DESC');
    $reportgrid->sql_group_by = 'm.member_id';
    $overdue_criteria = ' (l.is_lent=1 AND l.is_return=0) ';
    // is there any search
    if (isset($_GET['id_name']) and $_GET['id_name']) {
        $keyword = $dbs->escape_string(trim($_GET['id_name']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' (';
            foreach ($words as $word) {
                $concat_sql .= " (m.member_id LIKE '%{$word}%' OR m.member_name LIKE '%{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);

Example #12

File: member_list.php Project: purwoko/SENAYAN-3-Stable

    ?>
" style="margin-top: 9px; margin-left: 5px; margin-right: 5px;"
    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'member AS m
        LEFT JOIN mst_member_type AS mt ON m.member_type_id=mt.member_type_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('m.member_id AS \'' . lang_mod_membership_field_member_id . '\'', 'm.member_name AS \'' . lang_mod_membership_field_name . '\'', 'mt.member_type_name AS \'' . lang_mod_membership_field_membership_type . '\'');
    $reportgrid->setSQLorder('member_name ASC');
    // is there any search
    $criteria = 'm.member_id IS NOT NULL ';
    if (isset($_GET['member_type']) and !empty($_GET['member_type'])) {
        $mtype = intval($_GET['member_type']);
        $criteria .= ' AND m.member_type_id=' . $mtype;
    }
    if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {
        $id_name = $dbs->escape_string($_GET['id_name']);
        $criteria .= ' AND (m.member_id LIKE \'%' . $id_name . '%\' OR m.member_name LIKE \'%' . $id_name . '%\')';
    }
    if (isset($_GET['gender']) and $_GET['gender'] != 'ALL') {
        $gender = intval($_GET['gender']);
        $criteria .= ' AND m.gender=' . $gender;

Example #13

File: staff_act.php Project: mucill/slims8_akasia

    </form>
    </div>
    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'user AS u';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('u.realname AS \'' . __('Real Name') . '\'', 'u.username AS \'' . __('Login Username') . '\'', 'u.user_id AS \'' . __('Bibliography Data Entry') . '\'', 'u.user_id AS \'' . __('Item Data Entry') . '\'', 'u.user_id AS \'' . __('Member Data Entry') . '\'', 'u.user_id AS \'' . __('Peminjaman') . '\'', 'u.user_id AS \'' . __('Pengembalian') . '\'', 'u.user_id AS \'' . __('Perpanjang') . '\'');
    $reportgrid->setSQLorder('realname ASC');
    // is there any search
    $criteria = 'user_id IS NOT NULL ';
    $reportgrid->setSQLCriteria($criteria);
    $start_date = '2000-01-01';
    if (isset($_GET['startDate'])) {
        $start_date = $_GET['startDate'];
    }
    $until_date = date('Y-m-d');
    if (isset($_GET['untilDate'])) {
        $until_date = $_GET['untilDate'];
    }
    // callbacks
    function showBiblioEntries($obj_db, $array_data)

Example #14

File: item_usage.php Project: slims/s3st15_matoa

    </form>
    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'item AS i
        LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('i.item_code AS \'' . __('Item Code') . '\'', 'b.title AS \'' . __('Title') . '\'', '\'01\' AS \'' . __('Jan') . '\'', '\'02\' AS \'' . __('Feb') . '\'', '\'03\' AS \'' . __('Mar') . '\'', '\'04\' AS \'' . __('Apr') . '\'', '\'05\' AS \'' . __('May') . '\'', '\'06\' AS \'' . __('Jun') . '\'', '\'07\' AS \'' . __('Jul') . '\'', '\'08\' AS \'' . __('Aug') . '\'', '\'09\' AS \'' . __('Sep') . '\'', '\'10\' AS \'' . __('Oct') . '\'', '\'11\' AS \'' . __('Nov') . '\'', '\'12\' AS \'' . __('Dec') . '\'');
    $reportgrid->setSQLorder('b.title ASC');
    // is there any search
    $criteria = 'b.biblio_id IS NOT NULL ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%' OR b.isbn_issn LIKE '{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);
            $concat_sql .= ') ';

Example #15

File: visitor_list.php Project: banumelody/slims7_cendana

    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'visitor_count AS vc
        LEFT JOIN (member AS m LEFT JOIN mst_member_type AS mt ON m.member_type_id=mt.member_type_id)
        ON vc.member_id=m.member_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('IF(vc.member_id IS NOT NULL, vc.member_id, \'NON-MEMBER\')  AS \'' . __('Member ID') . '\'', 'vc.member_name AS \'' . __('Visitor Name') . '\'', 'IF(mt.member_type_name IS NOT NULL, mt.member_type_name, \'NON-MEMBER\') AS \'' . __('Membership Type') . '\'', 'vc.institution AS \'' . __('Institution') . '\'', 'vc.checkin_date AS \'' . __('Visit Date') . '\'');
    $reportgrid->setSQLorder('vc.member_id ASC');
    // is there any search
    $criteria = 'vc.visitor_id IS NOT NULL ';
    if (isset($_GET['member_type']) and !empty($_GET['member_type'])) {
        $mtype = $_GET['member_type'];
        if (intval($mtype) < 0) {
            $criteria .= ' AND (vc.member_id IS NULL OR vc.member_id=\'\')';
        } else {
            if (intval($mtype) > 0) {
                $criteria .= ' AND mt.member_type_id=' . $mtype;
            }
        }
    }
    if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {

Example #16

File: titles_list.php Project: mucill/slims8_akasia

    <input type="hidden" name="reportView" value="true" />
    </div>
    </form>
	</div>
    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('b.biblio_id', 'b.title AS \'' . __('Title') . '\'', 'COUNT(item_id) AS \'' . __('Copies') . '\'', 'pl.place_name AS \'' . __('Publishing Place') . '\'', 'pb.publisher_name AS \'' . __('Publisher') . '\'', 'b.isbn_issn AS \'' . __('ISBN/ISSN') . '\'', 'b.call_number AS \'' . __('Call Number') . '\'');
    $reportgrid->setSQLorder('b.title ASC');
    $reportgrid->invisible_fields = array(0);
    // is there any search
    $criteria = 'bsub.biblio_id IS NOT NULL ';
    $outer_criteria = 'b.biblio_id > 0 ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (bsub.title LIKE '%{$word}%' OR bsub.isbn_issn LIKE '%{$word}%') AND";
            }
            // remove the last AND

Example #17

File: item_titles_list.php Project: purwoko/SENAYAN-3-Stable

    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'item AS i
        LEFT JOIN biblio AS b ON i.biblio_id=b.biblio_id
        LEFT JOIN mst_coll_type AS ct ON i.coll_type_id=ct.coll_type_id
        LEFT JOIN mst_item_status AS s ON i.item_status_id=s.item_status_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('i.item_code AS \'' . lang_mod_biblio_item_field_itemcode . '\'', 'b.title AS \'' . lang_mod_biblio_field_title . '\'', 'ct.coll_type_name AS \'' . lang_mod_masterfile_colltype_form_field_colltype . '\'', 's.item_status_name AS \'' . lang_mod_biblio_item_field_item_status . '\'', 'b.call_number AS \'' . lang_mod_biblio_field_call_number . '\'', 'i.biblio_id');
    $reportgrid->setSQLorder('b.title ASC');
    // is there any search
    $criteria = 'b.biblio_id IS NOT NULL ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (b.title LIKE '%{$word}%' OR b.isbn_issn LIKE '%{$word}%') AND";
            }
            // remove the last AND
            $concat_sql = substr_replace($concat_sql, '', -3);
            $concat_sql .= ') ';

Example #18

File: member_list.php Project: banumelody/slims7_cendana

	</div>
    </fieldset>
    <!-- filter end -->
    <div class="dataListHeader" style="padding: 3px;"><span id="pagingBox"></span></div>
    <iframe name="reportView" id="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // table spec
    $table_spec = 'member AS m
        LEFT JOIN mst_member_type AS mt ON m.member_type_id=mt.member_type_id';
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('m.member_id AS \'' . __('Member ID') . '\'', 'm.member_name AS \'' . __('Member Name') . '\'', 'mt.member_type_name AS \'' . __('Membership Type') . '\'');
    $reportgrid->setSQLorder('member_name ASC');
    // is there any search
    $criteria = 'm.member_id IS NOT NULL ';
    if (isset($_GET['member_type']) and !empty($_GET['member_type'])) {
        $mtype = intval($_GET['member_type']);
        $criteria .= ' AND m.member_type_id=' . $mtype;
    }
    if (isset($_GET['id_name']) and !empty($_GET['id_name'])) {
        $id_name = $dbs->escape_string($_GET['id_name']);
        $criteria .= ' AND (m.member_id LIKE \'%' . $id_name . '%\' OR m.member_name LIKE \'%' . $id_name . '%\')';
    }
    if (isset($_GET['gender']) and $_GET['gender'] != 'ALL') {
        $gender = intval($_GET['gender']);
        $criteria .= ' AND m.gender=' . $gender;

Example #19

File: titles_list.php Project: purwoko/SENAYAN-3-Stable

    <div class="dataListHeader" style="height: 35px;">
    <input type="button" value="<?php 
    echo lang_mod_reporting_form_button_print;
    ?>
" style="margin-top: 9px; margin-left: 5px; margin-right: 5px;"
    onclick="javascript: reportView.print();" />
    &nbsp;<span id="pagingBox">&nbsp;</span></div>
    <iframe name="reportView" src="<?php 
    echo $_SERVER['PHP_SELF'] . '?reportView=true';
    ?>
" frameborder="0" style="width: 100%; height: 500px;"></iframe>
<?php 
} else {
    ob_start();
    // create datagrid
    $reportgrid = new report_datagrid();
    $reportgrid->setSQLColumn('b.biblio_id', 'b.title AS \'' . lang_mod_biblio_field_title . '\'', 'COUNT(item_id) AS ' . lang_mod_biblio_field_copies . '', 'b.isbn_issn AS \'' . lang_mod_biblio_field_isbn . '\'', 'b.call_number AS \'' . lang_mod_biblio_field_call_number . '\'');
    $reportgrid->setSQLorder('b.title ASC');
    $reportgrid->invisible_fields = array(0);
    // is there any search
    $criteria = 'bsub.biblio_id IS NOT NULL ';
    $outer_criteria = 'b.biblio_id > 0 ';
    if (isset($_GET['title']) and !empty($_GET['title'])) {
        $keyword = $dbs->escape_string(trim($_GET['title']));
        $words = explode(' ', $keyword);
        if (count($words) > 1) {
            $concat_sql = ' AND (';
            foreach ($words as $word) {
                $concat_sql .= " (bsub.title LIKE '%{$word}%' OR bsub.isbn_issn LIKE '%{$word}%') AND";
            }
            // remove the last AND