{
global $selected_year;
$_usage_q = $obj_db->query('SELECT COUNT(*) FROM loan AS l
WHERE l.item_code=\'' . $array_data[0] . '\' AND l.loan_date LIKE \'' . $selected_year . '-' . $array_data[$int_current_field_num] . '%\'');
$_usage_d = $_usage_q->fetch_row();
return $_usage_d[0] == '0' ? '<span style="color: #ff0000;">0</span>' : '<strong>' . $_usage_d[0] . '</strong>';
}
// modify column value
$reportgrid->modifyColumnContent(2, 'callback{showUsage}');
$reportgrid->modifyColumnContent(3, 'callback{showUsage}');
$reportgrid->modifyColumnContent(4, 'callback{showUsage}');
$reportgrid->modifyColumnContent(5, 'callback{showUsage}');
$reportgrid->modifyColumnContent(6, 'callback{showUsage}');
$reportgrid->modifyColumnContent(7, 'callback{showUsage}');
$reportgrid->modifyColumnContent(8, 'callback{showUsage}');
$reportgrid->modifyColumnContent(9, 'callback{showUsage}');
$reportgrid->modifyColumnContent(10, 'callback{showUsage}');
$reportgrid->modifyColumnContent(11, 'callback{showUsage}');
$reportgrid->modifyColumnContent(12, 'callback{showUsage}');
$reportgrid->modifyColumnContent(13, 'callback{showUsage}');
// no sort column
$reportgrid->disableSort(__('Jan'), __('Feb'), __('Mar'), __('Apr'), __('May'), __('Jun'), __('Jul'), __('Aug'), __('Sep'), __('Oct'), __('Nov'), __('Dec'));
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, 20);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'#pagingBox\').html(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$content = ob_get_clean();
// include the page template
require SENAYAN_BASE_DIR . '/admin/' . $sysconf['admin_template']['dir'] . '/printed_page_tpl.php';
}
WHERE l.item_code=\'' . $array_data[0] . '\' AND l.loan_date LIKE \'' . $selected_year . '-' . $array_data[$int_current_field_num] . '%\'');
$_usage_d = $_usage_q->fetch_row();
return $_usage_d[0] == '0' ? '<span style="color: #ff0000;">0</span>' : '<strong>' . $_usage_d[0] . '</strong>';
}
// modify column value
$reportgrid->modifyColumnContent(2, 'callback{showUsage}');
$reportgrid->modifyColumnContent(3, 'callback{showUsage}');
$reportgrid->modifyColumnContent(4, 'callback{showUsage}');
$reportgrid->modifyColumnContent(5, 'callback{showUsage}');
$reportgrid->modifyColumnContent(6, 'callback{showUsage}');
$reportgrid->modifyColumnContent(7, 'callback{showUsage}');
$reportgrid->modifyColumnContent(8, 'callback{showUsage}');
$reportgrid->modifyColumnContent(9, 'callback{showUsage}');
$reportgrid->modifyColumnContent(10, 'callback{showUsage}');
$reportgrid->modifyColumnContent(11, 'callback{showUsage}');
$reportgrid->modifyColumnContent(12, 'callback{showUsage}');
$reportgrid->modifyColumnContent(13, 'callback{showUsage}');
// no sort column
$reportgrid->disableSort(lang_sys_common_month_short_01, lang_sys_common_month_short_02, lang_sys_common_month_short_03, lang_sys_common_month_short_04, lang_sys_common_month_short_05, lang_sys_common_month_short_06, lang_sys_common_month_short_07, lang_sys_common_month_short_08, lang_sys_common_month_short_09, lang_sys_common_month_short_10, lang_sys_common_month_short_11, lang_sys_common_month_short_12);
// set table and table header attributes
$reportgrid->table_attr = 'align="center" id="dataListPrinted" cellpadding="3" cellspacing="1"';
$reportgrid->table_header_attr = 'class="dataListHeaderPrinted"';
// put the result into variables
echo $reportgrid->createDataGrid($dbs, $table_spec, 20);
echo '<script type="text/javascript">' . "\n";
echo 'parent.$(\'pagingBox\').update(\'' . str_replace(array("\n", "\r", "\t"), '', $reportgrid->paging_set) . '\');' . "\n";
echo '</script>';
$content = ob_get_clean();
// include the page template
require SENAYAN_BASE_DIR . '/admin/' . $sysconf['admin_template']['dir'] . '/notemplate_page_tpl.php';
}
