コード例 #1
0
ファイル: contact.php プロジェクト: rahmanazhar/imperium
<?php

/**
 */
namespace Edoceo\Imperium;

use Edoceo\Radix\DB\SQL;
$sql = 'SELECT name AS id,name FROM base_enum WHERE link = ? ORDER BY sort';
$this->KindList = SQL::fetch_mix($sql, array('contact-kind'));
$this->StatusList = SQL::fetch_mix($sql, array('contact-status'));
// function createAction()
// {
// 	$_ENV['title'] = array('Contact','Create');
// 	$P = new Contact(intval($_GET['parent']));
// 	if ($P->id) {
// 		$this->view->Contact['parent_id'] = $P['id'];
// 		$this->view->Contact['company'] = $P['company'];
// 		$this->view->Contact['phone'] = $P['phone'];
// 		$this->view->Contact['url'] = $P['url'];
// 	}
// 	$this->render('view');
// }
//
コード例 #2
0
ファイル: view.php プロジェクト: rahmanazhar/imperium
namespace Edoceo\Imperium;

use Edoceo\Radix\Session;
use Edoceo\Radix\DB\SQL;
$id = intval($_GET['i']);
$this->Invoice = new Invoice($id);
if (!empty($_GET['sent']) && $_GET['sent'] == 'good') {
    Radix\Session::flash('info', 'Invoice Status updated');
    $this->Invoice['status'] = 'Sent';
    $this->Invoice->setFlag(Invoice::FLAG_SENT);
    $this->Invoice->save();
    // Base_Diff::note($this->Invoice, $this->_s->info);
}
$_ENV['invoice']['id'] = $this->Invoice['id'];
$this->Contact = new Contact($this->Invoice['contact_id']);
$this->ContactAddressList = SQL::fetch_mix('select id,address from contact_address where contact_id = ?', array($this->Invoice['contact_id']));
$this->InvoiceItemList = $this->Invoice->getInvoiceItems();
$this->InvoiceNoteList = $this->Invoice->getNotes();
$this->InvoiceFileList = $this->Invoice->getFiles();
$this->InvoiceHistoryList = $this->Invoice->getHistory();
$this->InvoiceTransactionList = $this->Invoice->getTransactions();
// Add Prev / Next Links
$this->jump_list = array();
if (!empty($this->Invoice['id'])) {
    // Previous Ones
    $s = sprintf('SELECT id FROM invoice where id < %d order by id desc limit 5', $this->Invoice['id']);
    $r = SQL::fetch_all($s);
    $r = array_reverse($r);
    foreach ($r as $x) {
        $this->jump_list[] = array('controller' => 'invoice', 'action' => 'view', 'id' => $x['id']);
    }
コード例 #3
0
ファイル: invoice.php プロジェクト: rahmanazhar/imperium
<?php

/**
	WorkorderController init
	Sets the ACL for this Controller
*/
namespace Edoceo\Imperium;

use Edoceo\Radix\DB\SQL;
//$acl = Zend_Registry::get('acl');
//if ($acl->has('workorder') == false) {
//	$acl->add( new Zend_Acl_Resource('workorder') );
//}
//$acl->allow('user','workorder');
// parent::init();
$sql = 'SELECT name AS id,name FROM base_enum WHERE link = ? ORDER BY sort';
$this->StatusList = SQL::fetch_mix($sql, array('invoice-status'));
$this->ItemStatusList = SQL::fetch_mix($sql, array('invoice-item-status'));
$this->UnitList = Base_Unit::getList();
コード例 #4
0
ファイル: Unit.php プロジェクト: rahmanazhar/imperium
 static function getList()
 {
     $sql = 'select id,name from base_unit order by name';
     return SQL::fetch_mix($sql);
 }
コード例 #5
0
ファイル: reconcile.php プロジェクト: rahmanazhar/imperium
     $_ENV['mode'] = 'view';
     if ($_FILES['file']['error'] == 0) {
         $this->Account = new Account($_POST['account_id']);
         $_ENV['title'] = array('Account', 'Reconcile', $this->Account['full_name'], 'Preview');
         // Read File
         $arg = array('kind' => $_POST['format'], 'file' => $_FILES['file']['tmp_name'], 'account_id' => $_POST['upload_id']);
         $this->JournalEntryList = Account_Reconcile::parse($arg);
     } else {
         Session::flash('fail', 'Failed to Upload');
     }
     // @todo If the Target Account is Asset then Other Side Only (and vice-versa)
     $sql = 'SELECT id,full_name ';
     $sql .= 'FROM account ';
     // $sql.= "WHERE kind like 'Expense%' ";
     $sql .= 'ORDER BY full_code ASC, code ASC';
     $this->AccountPairList = SQL::fetch_mix($sql);
     $_SESSION['reconcile_upload_id'] = $_POST['upload_id'];
     $_SESSION['reconcile_offset_id'] = $_POST['offset_id'];
     $_ENV['upload_account_id'] = $_SESSION['reconcile_upload_id'];
     $_ENV['offset_account_id'] = $_POST['offset_id'];
     break;
 case 'save':
     // Save the Uploaded Transactions
     $_ENV['upload_account_id'] = $_SESSION['reconcile_upload_id'];
     Radix::dump($_POST);
     return 0;
     $c = ceil(count($_POST) / 4);
     for ($i = 1; $i <= $c; $i++) {
         // Skip Entries Missing Date (or the last of the count)
         if (empty($_POST[sprintf('je%ddate', $i)])) {
             continue;
コード例 #6
0
ファイル: workorder.php プロジェクト: rahmanazhar/imperium
<?php

/**
	WorkorderController init
	Sets the ACL for this Controller
*/
namespace Edoceo\Imperium;

use Edoceo\Radix\DB\SQL;
//$acl = Zend_Registry::get('acl');
//if ($acl->has('workorder') == false) {
//	$acl->add( new Zend_Acl_Resource('workorder') );
//}
//$acl->allow('user','workorder');
// parent::init();
$sql = 'SELECT name AS id,name FROM base_enum WHERE link = ? ORDER BY sort';
$this->KindList = SQL::fetch_mix($sql, array('workorder-kind'));
$this->StatusList = SQL::fetch_mix($sql, array('workorder-status'));
$this->ItemStatusList = SQL::fetch_mix($sql, array('workorder-item-status'));