function load_stories($topic)
{
if ($topic == "headlines") {
$url = "http://feeds.bbci.co.uk/news/rss.xml";
} else {
$url = "http://feeds.bbci.co.uk/news/{$topic}/rss.xml";
}
$data = load_data($url);
$xml = simplexml_load_string($data);
$items = array();
foreach ($xml->channel->item as $object) {
$item['title'] = (string) $object->title;
$item['description'] = (string) $object->description;
$item['link'] = (string) $object->link;
$item['published'] = strtotime((string) $object->pubDate);
$namespaces = $object->getNamespaces(true);
$media = $object->children($namespaces["media"]);
foreach ($media->thumbnail as $thumbnail) {
// Thumbnail in XML namespace
$thumbnailAttributes = $thumbnail->attributes();
// Return biggest thumbnail
if ($thumbnailAttributes->width > 140) {
$item['thumbnail'] = (string) $thumbnailAttributes->url;
}
}
array_push($items, $item);
}
return $items;
}
public function index()
{
if (!$this->session->userdata('islogged')) {
$this->load->model('login_model');
$data = array('page_title' => 'Login');
$projects = array('project_list' => $this->login_model->project_list());
$this->load->view('modules/login', load_data(array_merge($data, $projects)));
$this->load->view('parts/footer');
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Reports', 'page_title' => 'Sales and Expense');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$this->load->view('modules/sales_expense');
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Reports', 'page_title' => 'Summary');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$this->load->view('modules/summary');
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => '', 'page_title' => '');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$this->load->view('modules/account_settings');
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Administrator', 'page_title' => 'Audit Trail');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$this->load->view('modules/audit_trail');
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
$this->load->model('management_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Reports', 'page_title' => 'Management');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$this->load->view('modules/management');
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Administrator', 'page_title' => 'User Access');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$data = array('user_access_type' => $this->user_access_model->show_user_type()->result(), 'u_id' => $this->user_access_model->get_last_record(), 'user_access' => $this->user_access_model->show_user_access()->result(), 'project_list' => $this->user_access_model->project_list());
$this->load->view('modules/user_access', $data);
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Ledger', 'page_title' => 'Trial Balance');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$viewData = array('charts_account' => $this->trial_balance_model->get_charts_title());
$this->load->view('modules/trial_balance', $viewData, true);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Master Account');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$this->load->model('master_account_model');
$account_title = array('account_title' => $this->master_account_model->get_title());
$this->load->view('modules/master_account', $account_title);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
$this->load->model('general_ledger_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Ledger', 'page_title' => 'General Ledger');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$viewData = array('account_title' => $this->general_ledger_model->get_accounts());
$this->load->view('modules/general_ledger', $viewData);
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
$this->load->model('audit_trail_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Administrator', 'page_title' => 'Audit Trail');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$data = array('audit_data' => $this->audit_trail_model->load_records(), 'user' => $this->audit_trail_model->load_users());
$this->load->view('modules/audit_trail', $data);
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public static function fieldType($field)
{
$field_name = "`{$field['name']}`";
$field_types = load_data('field_types');
$db_type = $field['dtype'];
$ftype = $field_name . ' ';
switch ($db_type) {
case 'int':
if ($field['length'] <= 8) {
$db_type = 'tinyint';
}
$ftype .= "{$db_type}({$field['length']})";
break;
case 'varchar':
if (empty($field['length'])) {
$field['length'] = 128;
}
$ftype .= "{$db_type}({$field['length']})";
break;
case 'upload':
if (empty($field['length'])) {
$field['length'] = 64;
}
$ftype .= "{$db_type}({$field['length']})";
break;
case 'resource':
return '';
case 'url':
if (empty($field['length'])) {
$field['length'] = 64;
}
$ftype .= "{$db_type}({$field['length']})";
break;
case 'htmltext':
$ftype .= "mediumtext";
break;
default:
$ftype .= "{$db_type}";
break;
}
if ($field['ifnull']) {
$ftype .= " NULL";
} else {
$ftype .= " NOT NULL";
}
if (!empty($field['defaultvalue'])) {
$ftype .= " DEFAULT '{$field['defaultvalue']}'";
}
return $ftype;
}
public function index()
{
$this->load->model('subsidiary_account_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Journal', 'page_title' => 'General Journal');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$viewData = array('account_title' => $this->subsidiary_account_model->get_accounts());
$this->load->view('modules/general_journal', $viewData);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
$this->load->model("main_account_model");
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Subsidiary Account');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$master_name = array('master_name' => $this->main_account_model->show_master_name()->result());
$this->load->view('modules/subsidiary_account', $master_name);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
function aggregate_old_data()
{
global $ss;
$after = $ss->options['aggregate_after'];
if ($after == 0) {
return;
}
// start from the earliest month to aggregate
$yr = intval(date('Y'));
$mo = intval(date('n')) - $after - 1;
while ($mo < 1) {
$yr--;
$mo += 12;
}
if ($ss->options['last_aggregated']['yr'] >= $yr && $ss->options['last_aggregated']['mo'] >= $mo) {
return;
}
// we're already up to date
$ss->update_option('last_aggregated', array('yr' => $yr, 'mo' => $mo));
$result = $ss->query("SELECT MIN(`date`) FROM {$ss->tables['visits']} LIMIT 1");
if (!$result) {
return;
}
$earliest = mysql_fetch_row($result);
preg_match('/^(\\d{4})-(\\d{2})/', $earliest[0], $matches);
$min_yr = intval($matches[1]);
$min_mo = intval($matches[2]);
// is the earliest data within cutoff range?
if (gmmktime(0, 0, 0, $mo, 1, $yr) < gmmktime(0, 0, 0, $min_mo, 1, $min_yr)) {
return;
}
while (true) {
$data = load_data(array('yr' => $yr, 'mo' => $mo));
$data = $ss->esc(gzdeflate(serialize($data)));
// put into archive
$ss->query("INSERT INTO `{$ss->tables['archive']}` (`yr`, `mo`, `data`) VALUES ( '{$yr}', '{$mo}', '{$data}' )");
$endofmonth = "{$yr}-{$mo}-" . days_in_month($mo, $yr);
// delete raw data
$ss->query("DELETE FROM `{$ss->tables['visits']}` WHERE `date` >= '{$yr}-{$mo}-01' AND `date` <= '{$endofmonth}'");
if ($yr == $min_yr && $mo == $min_mo) {
break;
}
$mo--;
if ($mo < 1) {
$yr--;
$mo += 12;
}
}
$ss->query("OPTIMIZE TABLE `{$ss->tables['visits']}`");
}
public function index()
{
$this->load->model("main_account_model");
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Subsidiary Account');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$data = array('master_name' => $this->main_account_model->show_master_name()->result(), 'sub_code' => $this->subsidiary_account_model->get_last_subnum());
$this->load->view('modules/subsidiary_account', $data);
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
$this->load->model('accounts_receivable_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Ledger', 'page_title' => 'Accounts Receivable');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$viewData = array('accounts_receivable' => $this->accounts_receivable_model->show_customer_name());
$this->load->view('modules/accounts_receivable', $viewData);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
$this->load->model('bank_recon_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Bank Recon');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$bank_recon = array('bank_recon' => $this->bank_recon_model->show_bank());
$this->load->view('modules/bank_recon', $bank_recon);
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Administrator', 'page_title' => 'User Access');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$user_access_type = array('user_access_type' => $this->user_access_model->show_user_type()->result());
$user_access = array('user_access' => $this->user_access_model->show_user_access()->result());
$projects = array('project_list' => $this->user_access_model->project_list());
$this->load->view('modules/user_access', array_merge($user_access, $projects, $user_access_type));
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
$this->load->model("main_account_model");
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Main Account');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$account_group = array('account_group' => $this->system_settings_model->account_group_get('Assets')->result());
//$master_name = array('master_name' => $this->main_account_model->show_master_name()->result());
$this->load->view('modules/main_account', $account_group);
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
$this->load->model('journal_cr_model');
$this->load->model('subsidiary_account_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Journal', 'page_title' => 'Cash Receipts');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$viewData = array('journal_cr_customer' => $this->journal_cr_model->show_customer(), 'journal_cr_bank' => $this->journal_cr_model->show_bank(), 'account_title' => $this->subsidiary_account_model->get_accounts());
$this->load->view('modules/cash_receipts', $viewData);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
$this->load->model('journal_cd_model');
$this->load->model('subsidiary_account_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Journal', 'page_title' => 'Check Disbursement');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$viewData = array('journal_cd' => $this->journal_cd_model->show_bank(), 'account_title' => $this->subsidiary_account_model->get_accounts());
$this->load->view('modules/check_dis', $viewData);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
public function index()
{
$this->load->model("system_settings_model");
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Administrator', 'page_title' => 'System Settings');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$copyright = array('copyright' => $this->system_settings_model->copyrights_show()->result_array());
$account_group = array('account_group' => $this->system_settings_model->account_group_show()->result());
$this->load->view('modules/system_settings', array_merge($copyright, $account_group));
$this->load->view('parts/footer');
} else {
echo jcode(array('success' => 1));
}
}
public function index()
{
$this->load->model('journal_ap_model');
$this->load->model('bank_recon_model');
if ($this->session->userdata('islogged')) {
$page_info = array('page_tab' => 'Journal', 'page_title' => 'Accounts Payable');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$viewData = array('accounts_payable' => $this->journal_ap_model->show_expense_name(), 'bank_recon' => $this->bank_recon_model->show_supplier());
$this->load->view('modules/accounts_payable', $viewData);
$this->load->view('parts/footer');
} else {
redirect('login');
}
}
/**
* get_data
* returns the data read from api
* if data is not cached yet or if cached data is expired (older than 1h)
* fresh data is requested and cached.
*
* @param str file
* @param str request_url
* @return str data
*/
function get_data($file, $request_url)
{
if (!is_dir(CACHE_DIR)) {
mkdir(CACHE_DIR);
}
$current_time = time();
$expire_time = $current_time - 1 * 60 * 60;
$file_time = file_exists($file) ? filemtime($file) : 0;
if ($file_time < $expire_time) {
$content = load_data($request_url);
file_put_contents($file, $content);
} else {
$content = file_get_contents($file);
}
return $content;
}
/**
* Send & request to VIES site and interprets results
*
* @access public
* @param string
* @return boolean
*/
function oos_validate_is_vatid($sVatno)
{
$sVatno = trim($sVatno);
$sVatno = strtoupper($sVatno);
$aRemove = array(' ', '-', '/', '.', ':', ',', ';', '#');
for ($i = 0, $n = count($aRemove); $i < $n; $i++) {
$sVatno = str_replace($aRemove[$i], '', $sVatno);
}
$sViesMS = substr($sVatno, 0, 2);
$sVatno = substr($sVatno, 2);
$urlVies = 'http://ec.europa.eu/taxation_customs/vies/cgi-bin/viesquer/?VAT=' . $sVatno . '&MS=' . $sViesMS . '&Lang=EN';
$DataHTML = load_data($urlVies);
if (!$DataHTML) {
return false;
}
$ViesOk = 'YES, VALID VAT NUMBER';
$ViesEr = 'NO, INVALID VAT NUMBER';
$DataHTML = '#' . strtoupper($DataHTML);
return strPos($DataHTML, $ViesOk) > 0 ? true : false;
}
public function index()
{
if ($this->session->userdata('islogged')) {
switch ($this->session->userdata('current_page')) {
case 'system_settings':
$this->load->model("system_settings_model");
$this->session->set_userdata('page_tab', 'Administrator');
$this->session->set_userdata('page_title', 'System Settings');
$this->session->set_userdata('current_page', 'system_settings');
$page_info = array('page_tab' => 'Administrator', 'page_title' => 'System Settings');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$copyright = array('copyright' => $this->system_settings_model->copyrights_show()->result_array());
$account_group = array('account_group' => $this->system_settings_model->account_group_show()->result());
$this->load->view('modules/system_settings', array_merge($copyright, $account_group));
$this->load->view('parts/footer');
break;
case 'main_account':
$this->load->model("system_settings_model");
$this->session->set_userdata('page_tab', 'Set Up');
$this->session->set_userdata('page_title', 'Main Account');
$this->session->set_userdata('current_page', 'main_account');
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Main Account');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$account_group = array('account_group' => $this->system_settings_model->account_group_get('Assets')->result());
$this->load->view('modules/main_account', $account_group);
$this->load->view('parts/footer');
break;
case 'subsidiary_account':
$this->load->model("system_settings_model");
$this->load->model("subsidiary_account_model");
$this->session->set_userdata('page_tab', 'Set Up');
$this->session->set_userdata('page_title', 'Subsidiary Account');
$this->session->set_userdata('current_page', 'subsidiary_account');
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Subsidiary Account');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$account_list = array('account_list' => $this->system_settings_model->account_group_get('Assets')->result());
$account_title = array('account_title' => $this->subsidiary_account_model->get_accounts()->result());
$this->load->view('modules/subsidiary_account', array_merge($account_list, $account_title));
$this->load->view('parts/footer');
break;
case 'user_access':
$this->load->model('user_access_model');
$page_info = array('page_tab' => 'Administrator', 'page_title' => 'User Access');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$user_access_type = array('user_access_type' => $this->user_access_model->show_user_type()->result());
$user_access = array('user_access' => $this->user_access_model->show_user_access()->result());
$projects = array('project_list' => $this->user_access_model->project_list());
$this->load->view('modules/user_access', array_merge($user_access, $projects, $user_access_type));
$this->load->view('parts/footer');
break;
// Use to show the Bank name in the bank recon module under select field
// Use to show the Bank name in the bank recon module under select field
case 'bank_recon':
$this->load->model('bank_recon_model');
$page_info = array('page_tab' => 'Set Up', 'page_title' => 'Bank Recon');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$bank_recon = array('bank_recon' => $this->bank_recon_model->show_bank());
$this->load->view('modules/bank_recon', $bank_recon);
$this->load->view('parts/footer');
break;
// Use to show the Expenses name in the accounts payable module under select field
// Use to show the Expenses name in the accounts payable module under select field
case 'accounts_payable':
$this->load->model('journal_ap_model');
$this->load->model('bank_recon_model');
$page_info = array('page_tab' => 'Journal', 'page_title' => 'Accounts Payable');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$viewData = array('accounts_payable' => $this->journal_ap_model->show_expense_name(), 'bank_recon' => $this->bank_recon_model->show_supplier());
$this->load->view('modules/accounts_payable', $viewData);
$this->load->view('parts/footer');
break;
// Use to show the Bank name in the check dis module under select field
// Use to show the Bank name in the check dis module under select field
case 'journal_cd':
$this->load->model('journal_cd_model');
$page_info = array('page_tab' => 'Journal', 'page_title' => 'Check Disbursement');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$viewData = array('journal_cd' => $this->journal_cd_model->show_bank());
$this->load->view('modules/check_dis', $viewData);
$this->load->view('parts/footer');
break;
// Use to show the Customer name in the sales journal module under select field
// Use to show the Customer name in the sales journal module under select field
case 'journal_sj':
$this->load->model('journal_sj_model');
$page_info = array('page_tab' => 'Journal', 'page_title' => 'Sales Journal');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$viewData = array('journal_sj' => $this->journal_sj_model->show_customer());
$this->load->view('modules/sales_journal', $viewData);
$this->load->view('parts/footer');
break;
// Use to show the Customer name and bank name in the cash receipts module under select field
// Use to show the Customer name and bank name in the cash receipts module under select field
case 'journal_cr':
$this->load->model('journal_cr_model');
$page_info = array('page_tab' => 'Journal', 'page_title' => 'Cash Receipts');
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar');
$viewData = array('journal_cr_customer' => $this->journal_cr_model->show_customer(), 'journal_cr_bank' => $this->journal_cr_model->show_bank());
$this->load->view('modules/cash_receipts', $viewData);
$this->load->view('parts/footer');
break;
default:
$page_info = array('page_tab' => $this->session->userdata('page_tab'), 'page_title' => $this->session->userdata('page_title'));
$this->load->view('parts/header', load_data($page_info));
$this->load->view('parts/sidebar', load_data($page_info));
$this->load->view('modules/' . $this->session->userdata('current_page'));
$this->load->view('parts/footer');
break;
}
} else {
redirect('login');
}
}
// insert entry that this machine might need an update
set_mach_outdated($_POST["e_id"], $db);
} else {
$stmt = $db->prepare("INSERT INTO `macs`.`mach` (`name`,`mach_nr`,`desc`,`active`) VALUE (:name,:mach_nr,:desc,1)");
$execute = 1;
}
// insert
}
}
// if check ok
if ($execute == 1) {
$stmt->bindParam(":name", $_POST["e_name"], PDO::PARAM_STR);
$stmt->bindParam(":mach_nr", $_POST["e_mach_nr"], PDO::PARAM_STR);
$stmt->bindParam(":desc", $_POST["e_desc"], PDO::PARAM_STR);
$stmt->execute();
load_data();
// reload as user has changed
if ($_POST["e_id"] != 0) {
add_log($_POST["e_id"], "-", "Machine updated", "-");
show_info("machine updated");
} else {
$stmt = $db->prepare("SELECT ID FROM `macs`.`mach` ORDER BY ID desc LIMIT 0,1");
$stmt->execute();
foreach ($stmt as $row) {
add_log($row["ID"], "-", "Machine created", "-");
}
show_info("machine created");
}
}
}
// add update
<?php
/**
* Created by JetBrains PhpStorm.
* User: ron
* Date: 7/4/15
* Time: 4:14 AM
* To change this template use File | Settings | File Templates.
*/
require_once 'functions.php';
$data = sort_data(load_data('testdata.tsv'), 'id', SORT_DESC);
print_r($data);
