/** * Load all TransactionTypes * @param string $strOrderBy * @param string $strLimit * @param array $objExpansionMap map of referenced columns to be immediately expanded via early-binding * @return TransactionType[] */ public static function LoadArrayByAssetFlag($blnAssetFlag, $strOrderBy = null, $strLimit = null, $objExpansionMap = null) { // Call to ArrayQueryHelper to Get Database Object and Get SQL Clauses TransactionType::ArrayQueryHelper($strOrderBy, $strLimit, $strLimitPrefix, $strLimitSuffix, $strExpandSelect, $strExpandFrom, $objExpansionMap, $objDatabase); $blnAssetFlag = $objDatabase->SqlVariable($blnAssetFlag, true); // Setup the SQL Query $strQuery = sprintf(' SELECT %s `transaction_type`.`transaction_type_id` AS `transaction_type_id`, `transaction_type`.`short_description` AS `short_description`, `transaction_type`.`asset_flag` AS `asset_flag`, `transaction_type`.`inventory_flag` AS `inventory_flag` %s FROM `transaction_type` AS `transaction_type` %s WHERE `asset_flag` %s %s %s', $strLimitPrefix, $strExpandSelect, $strExpandFrom, $blnAssetFlag, $strOrderBy, $strLimitSuffix); // Perform the Query and Instantiate the Result $objDbResult = $objDatabase->Query($strQuery); return TransactionType::InstantiateDbResult($objDbResult); }
protected function SetupTransactionType() { // Lookup Object PK information from Query String (if applicable) // Set mode to Edit or New depending on what's found $intTransactionTypeId = QApplication::QueryString('intTransactionTypeId'); if ($intTransactionTypeId) { $this->objTransactionType = TransactionType::Load($intTransactionTypeId); if (!$this->objTransactionType) { throw new Exception('Could not find a TransactionType object with PK arguments: ' . $intTransactionTypeId); } $this->strTitleVerb = QApplication::Translate('Edit'); $this->blnEditMode = true; } else { $this->objTransactionType = new TransactionType(); $this->strTitleVerb = QApplication::Translate('Create'); $this->blnEditMode = false; } }
protected function dtgTransactionType_Bind() { // Because we want to enable pagination AND sorting, we need to setup the $objClauses array to send to LoadAll() // Remember! We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below $this->dtgTransactionType->TotalItemCount = TransactionType::CountAll(); // Setup the $objClauses Array $objClauses = array(); // If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add // the OrderByClause to the $objClauses array if ($objClause = $this->dtgTransactionType->OrderByClause) { array_push($objClauses, $objClause); } // Add the LimitClause information, as well if ($objClause = $this->dtgTransactionType->LimitClause) { array_push($objClauses, $objClause); } // Set the DataSource to be the array of all TransactionType objects, given the clauses above $this->dtgTransactionType->DataSource = TransactionType::LoadAll($objClauses); }
/** * Main utility method to aid with data binding. It is used by the default BindAllRows() databinder but * could and should be used by any custom databind methods that would be used for instances of this * MetaDataGrid, by simply passing in a custom QQCondition and/or QQClause. * * If a paginator is set on this DataBinder, it will use it. If not, then no pagination will be used. * It will also perform any sorting (if applicable). * * @param QQCondition $objConditions override the default condition of QQ::All() to the query, itself * @param QQClause[] $objOptionalClauses additional optional QQClause object or array of QQClause objects for the query * @return void */ public function MetaDataBinder(QQCondition $objCondition = null, $objOptionalClauses = null) { // Setup input parameters to default values if none passed in if (!$objCondition) { $objCondition = QQ::All(); } $objClauses = $objOptionalClauses ? $objOptionalClauses : array(); // We need to first set the TotalItemCount, which will affect the calcuation of LimitClause below if ($this->Paginator) { $this->TotalItemCount = TransactionType::QueryCount($objCondition, $objClauses); } // If a column is selected to be sorted, and if that column has a OrderByClause set on it, then let's add // the OrderByClause to the $objClauses array if ($objClause = $this->OrderByClause) { array_push($objClauses, $objClause); } // Add the LimitClause information, as well if ($objClause = $this->LimitClause) { array_push($objClauses, $objClause); } // Set the DataSource to be a Query result from TransactionType, given the clauses above $this->DataSource = TransactionType::QueryArray($objCondition, $objClauses); }
public function actionAddbuild() { if (isset($_POST['goods_id'])) { $components = GoodsBuild::model()->findAllByAttributes(array('goods_id' => $_POST['goods_id'])); $type = TransactionType::model()->findByPk(1); $arModels = array(); foreach ($components as $model) { $arModels[] = array('component_id' => $model->component_id, 'component_name' => $model->component->component_name, 'warehouse_from' => $model->warehouse->warehouse_from, 'warehouse_to' => $model->warehouse->warehouse_to, 'component_qty' => $model->component_qty, 'type' => $type->type); } echo CJSON::encode($arModels); } }
function __construct($ledgerId, $employeeId, $type) { parent::__construct("Employee Benefit - " . $type); $this->drAccounts[] = Account::GetAccountByNo($employeeId, 'employees', 'PAYROLL'); $this->drRatios[] = 1; $this->crAccounts[] = Account::GetLedger($ledgerId); $this->crRatios[] = 1; }
/** * Static Helper Method to Create using PK arguments * You must pass in the PK arguments on an object to load, or leave it blank to create a new one. * If you want to load via QueryString or PathInfo, use the CreateFromQueryString or CreateFromPathInfo * static helper methods. Finally, specify a CreateType to define whether or not we are only allowed to * edit, or if we are also allowed to create a new one, etc. * * @param mixed $objParentObject QForm or QPanel which will be using this TransactionTypeMetaControl * @param integer $intTransactionTypeId primary key value * @param QMetaControlCreateType $intCreateType rules governing TransactionType object creation - defaults to CreateOrEdit * @return TransactionTypeMetaControl */ public static function Create($objParentObject, $intTransactionTypeId = null, $intCreateType = QMetaControlCreateType::CreateOrEdit) { // Attempt to Load from PK Arguments if (strlen($intTransactionTypeId)) { $objTransactionType = TransactionType::Load($intTransactionTypeId); // TransactionType was found -- return it! if ($objTransactionType) { return new TransactionTypeMetaControl($objParentObject, $objTransactionType); } else { if ($intCreateType != QMetaControlCreateType::CreateOnRecordNotFound) { throw new QCallerException('Could not find a TransactionType object with PK arguments: ' . $intTransactionTypeId); } } // If EditOnly is specified, throw an exception } else { if ($intCreateType == QMetaControlCreateType::EditOnly) { throw new QCallerException('No PK arguments specified'); } } // If we are here, then we need to create a new record return new TransactionTypeMetaControl($objParentObject, new TransactionType()); }
/** * Internally called method to assist with early binding of objects * on load methods. Can only early-bind references that this class owns in the database. * @param string $strParentAlias the alias of the parent (if any) * @param string $strAlias the alias of this object * @param array $objExpansionMap map of referenced columns to be immediately expanded via early-binding * @param QueryExpansion an already instantiated QueryExpansion object (used as a utility object to assist with object expansion) */ public static function ExpandQuery($strParentAlias, $strAlias, $objExpansionMap, QQueryExpansion $objQueryExpansion) { if ($strAlias) { $objQueryExpansion->AddFromItem(sprintf('LEFT JOIN `role_transaction_type_authorization` AS `%s__%s` ON `%s`.`%s` = `%s__%s`.`role_transaction_type_authorization_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`role_transaction_type_authorization_id` AS `%s__%s__role_transaction_type_authorization_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`role_id` AS `%s__%s__role_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`transaction_type_id` AS `%s__%s__transaction_type_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`authorization_level_id` AS `%s__%s__authorization_level_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`created_by` AS `%s__%s__created_by`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`creation_date` AS `%s__%s__creation_date`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`modified_by` AS `%s__%s__modified_by`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`modified_date` AS `%s__%s__modified_date`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $strParentAlias = $strParentAlias . '__' . $strAlias; } if (is_array($objExpansionMap)) { foreach ($objExpansionMap as $strKey => $objValue) { switch ($strKey) { case 'role_id': try { Role::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'transaction_type_id': try { TransactionType::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'authorization_level_id': try { AuthorizationLevel::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'created_by': try { UserAccount::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'modified_by': try { UserAccount::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } default: throw new QCallerException(sprintf('Unknown Object to Expand in %s: %s', $strParentAlias, $strKey)); } } } }
public static function GetSoapObjectFromObject($objObject, $blnBindRelatedObjects) { if ($objObject->objTransactionType) { $objObject->objTransactionType = TransactionType::GetSoapObjectFromObject($objObject->objTransactionType, false); } else { if (!$blnBindRelatedObjects) { $objObject->intTransactionTypeId = null; } } if ($objObject->objCreatedByObject) { $objObject->objCreatedByObject = UserAccount::GetSoapObjectFromObject($objObject->objCreatedByObject, false); } else { if (!$blnBindRelatedObjects) { $objObject->intCreatedBy = null; } } if ($objObject->dttCreationDate) { $objObject->dttCreationDate = $objObject->dttCreationDate->__toString(QDateTime::FormatSoap); } if ($objObject->objModifiedByObject) { $objObject->objModifiedByObject = UserAccount::GetSoapObjectFromObject($objObject->objModifiedByObject, false); } else { if (!$blnBindRelatedObjects) { $objObject->intModifiedBy = null; } } return $objObject; }
/** * Refresh this MetaControl with Data from the local RoleTransactionTypeAuthorization object. * @param boolean $blnReload reload RoleTransactionTypeAuthorization from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objRoleTransactionTypeAuthorization->Reload(); } if ($this->lblRoleTransactionTypeAuthorizationId) { if ($this->blnEditMode) { $this->lblRoleTransactionTypeAuthorizationId->Text = $this->objRoleTransactionTypeAuthorization->RoleTransactionTypeAuthorizationId; } } if ($this->lstRole) { $this->lstRole->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstRole->AddItem(QApplication::Translate('- Select One -'), null); } $objRoleArray = Role::LoadAll(); if ($objRoleArray) { foreach ($objRoleArray as $objRole) { $objListItem = new QListItem($objRole->__toString(), $objRole->RoleId); if ($this->objRoleTransactionTypeAuthorization->Role && $this->objRoleTransactionTypeAuthorization->Role->RoleId == $objRole->RoleId) { $objListItem->Selected = true; } $this->lstRole->AddItem($objListItem); } } } if ($this->lblRoleId) { $this->lblRoleId->Text = $this->objRoleTransactionTypeAuthorization->Role ? $this->objRoleTransactionTypeAuthorization->Role->__toString() : null; } if ($this->lstTransactionType) { $this->lstTransactionType->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstTransactionType->AddItem(QApplication::Translate('- Select One -'), null); } $objTransactionTypeArray = TransactionType::LoadAll(); if ($objTransactionTypeArray) { foreach ($objTransactionTypeArray as $objTransactionType) { $objListItem = new QListItem($objTransactionType->__toString(), $objTransactionType->TransactionTypeId); if ($this->objRoleTransactionTypeAuthorization->TransactionType && $this->objRoleTransactionTypeAuthorization->TransactionType->TransactionTypeId == $objTransactionType->TransactionTypeId) { $objListItem->Selected = true; } $this->lstTransactionType->AddItem($objListItem); } } } if ($this->lblTransactionTypeId) { $this->lblTransactionTypeId->Text = $this->objRoleTransactionTypeAuthorization->TransactionType ? $this->objRoleTransactionTypeAuthorization->TransactionType->__toString() : null; } if ($this->lstAuthorizationLevel) { $this->lstAuthorizationLevel->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstAuthorizationLevel->AddItem(QApplication::Translate('- Select One -'), null); } $objAuthorizationLevelArray = AuthorizationLevel::LoadAll(); if ($objAuthorizationLevelArray) { foreach ($objAuthorizationLevelArray as $objAuthorizationLevel) { $objListItem = new QListItem($objAuthorizationLevel->__toString(), $objAuthorizationLevel->AuthorizationLevelId); if ($this->objRoleTransactionTypeAuthorization->AuthorizationLevel && $this->objRoleTransactionTypeAuthorization->AuthorizationLevel->AuthorizationLevelId == $objAuthorizationLevel->AuthorizationLevelId) { $objListItem->Selected = true; } $this->lstAuthorizationLevel->AddItem($objListItem); } } } if ($this->lblAuthorizationLevelId) { $this->lblAuthorizationLevelId->Text = $this->objRoleTransactionTypeAuthorization->AuthorizationLevel ? $this->objRoleTransactionTypeAuthorization->AuthorizationLevel->__toString() : null; } if ($this->lstCreatedByObject) { $this->lstCreatedByObject->RemoveAllItems(); $this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null); $objCreatedByObjectArray = UserAccount::LoadAll(); if ($objCreatedByObjectArray) { foreach ($objCreatedByObjectArray as $objCreatedByObject) { $objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId); if ($this->objRoleTransactionTypeAuthorization->CreatedByObject && $this->objRoleTransactionTypeAuthorization->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) { $objListItem->Selected = true; } $this->lstCreatedByObject->AddItem($objListItem); } } } if ($this->lblCreatedBy) { $this->lblCreatedBy->Text = $this->objRoleTransactionTypeAuthorization->CreatedByObject ? $this->objRoleTransactionTypeAuthorization->CreatedByObject->__toString() : null; } if ($this->calCreationDate) { $this->calCreationDate->DateTime = $this->objRoleTransactionTypeAuthorization->CreationDate; } if ($this->lblCreationDate) { $this->lblCreationDate->Text = sprintf($this->objRoleTransactionTypeAuthorization->CreationDate) ? $this->objRoleTransactionTypeAuthorization->__toString($this->strCreationDateDateTimeFormat) : null; } if ($this->lstModifiedByObject) { $this->lstModifiedByObject->RemoveAllItems(); $this->lstModifiedByObject->AddItem(QApplication::Translate('- Select One -'), null); $objModifiedByObjectArray = UserAccount::LoadAll(); if ($objModifiedByObjectArray) { foreach ($objModifiedByObjectArray as $objModifiedByObject) { $objListItem = new QListItem($objModifiedByObject->__toString(), $objModifiedByObject->UserAccountId); if ($this->objRoleTransactionTypeAuthorization->ModifiedByObject && $this->objRoleTransactionTypeAuthorization->ModifiedByObject->UserAccountId == $objModifiedByObject->UserAccountId) { $objListItem->Selected = true; } $this->lstModifiedByObject->AddItem($objListItem); } } } if ($this->lblModifiedBy) { $this->lblModifiedBy->Text = $this->objRoleTransactionTypeAuthorization->ModifiedByObject ? $this->objRoleTransactionTypeAuthorization->ModifiedByObject->__toString() : null; } if ($this->lblModifiedDate) { if ($this->blnEditMode) { $this->lblModifiedDate->Text = $this->objRoleTransactionTypeAuthorization->ModifiedDate; } } }
<?php /*********************************************************************************** * The contents of this file are subject to the Mozilla Public License Version 2.0 * ("License"); You may not use this file except in compliance with the Mozilla Public License Version 2.0 * The Original Code is: Linet 3.0 Open Source * The Initial Developer of the Original Code is Adam Ben Hur. * All portions are Copyright (C) Adam Ben Hur. * All Rights Reserved. ************************************************************************************/ $dateisOn = $this->widget('zii.widgets.jui.CJuiDatePicker', array('name' => 'Transactions[from_date]', 'language' => substr(Yii::app()->language, 0, 2), 'value' => $model->from_date, 'options' => array('showAnim' => 'fold', 'dateFormat' => Yii::app()->locale->getDateFormat('short'), 'changeMonth' => 'true', 'changeYear' => 'true', 'constrainInput' => 'false'), 'htmlOptions' => array('placeholder' => Yii::t('app', 'From Date'))), true) . $this->widget('zii.widgets.jui.CJuiDatePicker', array('name' => 'Transactions[to_date]', 'language' => substr(Yii::app()->language, 0, 2), 'value' => $model->to_date, 'options' => array('showAnim' => 'fold', 'dateFormat' => Yii::app()->locale->getDateFormat('short'), 'changeMonth' => 'true', 'changeYear' => 'true', 'constrainInput' => 'false'), 'htmlOptions' => array('placeholder' => Yii::t('app', 'To Date'))), true); $this->beginWidget('MiniForm', array('header' => Yii::t('app', "Transactions"))); $yiidbdatetime = Yii::app()->locale->getDateFormat('yiidbdatetime'); $phpdatetime = Yii::app()->locale->getDateFormat('phpdatetime'); $this->widget('EExcelView', array('id' => 'transactions-grid', 'dataProvider' => $model->search(), 'ajaxUpdate' => true, 'ajaxType' => 'POST', 'afterAjaxUpdate' => "function() {\n\t\t\t\t\t\tjQuery('#Transactions_from_date').datepicker(jQuery.extend({showMonthAfterYear:false}, jQuery.datepicker.regional['" . substr(Yii::app()->language, 0, 2) . "'], {'showAnim':'fold','dateFormat':'" . Yii::app()->locale->getDateFormat('short') . "','changeMonth':'true','showButtonPanel':'true','changeYear':'true','constrainInput':'false'}));\n\t\t\t\t\t\tjQuery('#Transactions_to_date').datepicker(jQuery.extend({showMonthAfterYear:false}, jQuery.datepicker.regional['" . substr(Yii::app()->language, 0, 2) . "'], {'showAnim':'fold','dateFormat':'" . Yii::app()->locale->getDateFormat('short') . "','changeMonth':'true','showButtonPanel':'true','changeYear':'true','constrainInput':'false'}));\n }", 'filter' => $model, 'columns' => array(array('name' => 'num', 'htmlOptions' => array('style' => 'width:8%;')), array('name' => 'type', 'filter' => CHtml::listData(TransactionType::model()->findAll(), 'id', 'name'), 'value' => 'Yii::t("app",$data->Type->name)', 'htmlOptions' => array('style' => 'width:15%;')), array('name' => 'account_id', 'filter' => CHtml::listData(Accounts::model()->findAll(), 'id', 'name'), 'value' => 'CHtml::link(CHtml::encode(isset($data->Account)?$data->Account->name:$data->account_id),Yii::app()->createAbsoluteUrl("/accounts/transaction/".$data->account_id))', 'type' => 'raw', 'htmlOptions' => array('style' => 'width:15%;')), array('name' => 'refnum1', 'value' => '$data->refnumDocsLink()', 'filter' => '', 'type' => 'raw'), array('name' => 'refnum2', 'value' => 'CHtml::encode($data->refnum2)', 'type' => 'raw'), 'details', array('name' => 'valuedate', 'filter' => $dateisOn, 'value' => 'date("' . $phpdatetime . '",CDateTimeParser::parse($data->valuedate,"' . $yiidbdatetime . '"))', 'htmlOptions' => array('style' => 'width:8%;')), array('name' => 'reg_date', 'filter' => '', 'value' => 'date("' . $phpdatetime . '",CDateTimeParser::parse($data->reg_date,"' . $yiidbdatetime . '"))', 'htmlOptions' => array('style' => 'width:8%;')), array('header' => Yii::t('app', 'Debit'), 'cssClassExpression' => "'number'", 'name' => 'sum', 'filter' => '', 'value' => '($data->sum<0)?$data->sum:""'), array('header' => Yii::t('app', 'Credit'), 'cssClassExpression' => "'number'", 'name' => 'sum', 'filter' => '', 'value' => '($data->sum>0)?$data->sum:""')))); ?> <div class="row form-actions"> <?php $this->widget('bootstrap.widgets.TbButton', array('type' => 'primary', 'buttonType' => 'ajaxButton', "icon" => "glyphicon glyphicon-print", 'label' => Yii::t('app', "Print"))); ?> </div> <?php $this->endWidget(); //miniform ?> <script type="text/javascript"> jQuery(document).ready(function() { $("#yt0").click(function(e) {
/** * Is transaction type is buy * * @return bool */ public function isTypeBuy() { return $this->transactionType->getName() === self::TYPE_BUY; }
function __construct($ledgerId, $clientId) { parent::__construct("Sales Receipt"); $this->drAccounts[] = Account::GetLedger($ledgerId); $this->drRatios[] = 1; $this->crAccounts[] = Account::GetAccountByNo($clientId, 'clients', 'Debtors'); $this->crRatios[] = 1; //this info should originate from the database, insert ignore protocol included //$this->code = self::GetCode('PayPal'); //parent::__construct(); }
/** * Refresh this MetaControl with Data from the local Shortcut object. * @param boolean $blnReload reload Shortcut from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objShortcut->Reload(); } if ($this->lblShortcutId) { if ($this->blnEditMode) { $this->lblShortcutId->Text = $this->objShortcut->ShortcutId; } } if ($this->lstModule) { $this->lstModule->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstModule->AddItem(QApplication::Translate('- Select One -'), null); } $objModuleArray = Module::LoadAll(); if ($objModuleArray) { foreach ($objModuleArray as $objModule) { $objListItem = new QListItem($objModule->__toString(), $objModule->ModuleId); if ($this->objShortcut->Module && $this->objShortcut->Module->ModuleId == $objModule->ModuleId) { $objListItem->Selected = true; } $this->lstModule->AddItem($objListItem); } } } if ($this->lblModuleId) { $this->lblModuleId->Text = $this->objShortcut->Module ? $this->objShortcut->Module->__toString() : null; } if ($this->lstAuthorization) { $this->lstAuthorization->RemoveAllItems(); $this->lstAuthorization->AddItem(QApplication::Translate('- Select One -'), null); $objAuthorizationArray = Authorization::LoadAll(); if ($objAuthorizationArray) { foreach ($objAuthorizationArray as $objAuthorization) { $objListItem = new QListItem($objAuthorization->__toString(), $objAuthorization->AuthorizationId); if ($this->objShortcut->Authorization && $this->objShortcut->Authorization->AuthorizationId == $objAuthorization->AuthorizationId) { $objListItem->Selected = true; } $this->lstAuthorization->AddItem($objListItem); } } } if ($this->lblAuthorizationId) { $this->lblAuthorizationId->Text = $this->objShortcut->Authorization ? $this->objShortcut->Authorization->__toString() : null; } if ($this->lstTransactionType) { $this->lstTransactionType->RemoveAllItems(); $this->lstTransactionType->AddItem(QApplication::Translate('- Select One -'), null); $objTransactionTypeArray = TransactionType::LoadAll(); if ($objTransactionTypeArray) { foreach ($objTransactionTypeArray as $objTransactionType) { $objListItem = new QListItem($objTransactionType->__toString(), $objTransactionType->TransactionTypeId); if ($this->objShortcut->TransactionType && $this->objShortcut->TransactionType->TransactionTypeId == $objTransactionType->TransactionTypeId) { $objListItem->Selected = true; } $this->lstTransactionType->AddItem($objListItem); } } } if ($this->lblTransactionTypeId) { $this->lblTransactionTypeId->Text = $this->objShortcut->TransactionType ? $this->objShortcut->TransactionType->__toString() : null; } if ($this->txtShortDescription) { $this->txtShortDescription->Text = $this->objShortcut->ShortDescription; } if ($this->lblShortDescription) { $this->lblShortDescription->Text = $this->objShortcut->ShortDescription; } if ($this->txtLink) { $this->txtLink->Text = $this->objShortcut->Link; } if ($this->lblLink) { $this->lblLink->Text = $this->objShortcut->Link; } if ($this->txtImagePath) { $this->txtImagePath->Text = $this->objShortcut->ImagePath; } if ($this->lblImagePath) { $this->lblImagePath->Text = $this->objShortcut->ImagePath; } if ($this->lstEntityQtype) { $this->lstEntityQtype->SelectedValue = $this->objShortcut->EntityQtypeId; } if ($this->lblEntityQtypeId) { $this->lblEntityQtypeId->Text = $this->objShortcut->EntityQtypeId ? EntityQtype::$NameArray[$this->objShortcut->EntityQtypeId] : null; } if ($this->chkCreateFlag) { $this->chkCreateFlag->Checked = $this->objShortcut->CreateFlag; } if ($this->lblCreateFlag) { $this->lblCreateFlag->Text = $this->objShortcut->CreateFlag ? QApplication::Translate('Yes') : QApplication::Translate('No'); } }
public function dtgTransactionType_Bind() { // Get Total Count b/c of Pagination $this->dtgTransactionType->TotalItemCount = TransactionType::CountAll(); $objClauses = array(); if ($objClause = $this->dtgTransactionType->OrderByClause) { array_push($objClauses, $objClause); } if ($objClause = $this->dtgTransactionType->LimitClause) { array_push($objClauses, $objClause); } $this->dtgTransactionType->DataSource = TransactionType::LoadAll($objClauses); }
/** * Internally called method to assist with early binding of objects * on load methods. Can only early-bind references that this class owns in the database. * @param string $strParentAlias the alias of the parent (if any) * @param string $strAlias the alias of this object * @param array $objExpansionMap map of referenced columns to be immediately expanded via early-binding * @param QueryExpansion an already instantiated QueryExpansion object (used as a utility object to assist with object expansion) */ public static function ExpandQuery($strParentAlias, $strAlias, $objExpansionMap, QQueryExpansion $objQueryExpansion) { if ($strAlias) { $objQueryExpansion->AddFromItem(sprintf('LEFT JOIN `shortcut` AS `%s__%s` ON `%s`.`%s` = `%s__%s`.`shortcut_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`shortcut_id` AS `%s__%s__shortcut_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`module_id` AS `%s__%s__module_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`authorization_id` AS `%s__%s__authorization_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`transaction_type_id` AS `%s__%s__transaction_type_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`short_description` AS `%s__%s__short_description`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`link` AS `%s__%s__link`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`image_path` AS `%s__%s__image_path`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`entity_qtype_id` AS `%s__%s__entity_qtype_id`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $objQueryExpansion->AddSelectItem(sprintf('`%s__%s`.`create_flag` AS `%s__%s__create_flag`', $strParentAlias, $strAlias, $strParentAlias, $strAlias)); $strParentAlias = $strParentAlias . '__' . $strAlias; } if (is_array($objExpansionMap)) { foreach ($objExpansionMap as $strKey => $objValue) { switch ($strKey) { case 'module_id': try { Module::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'authorization_id': try { Authorization::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } case 'transaction_type_id': try { TransactionType::ExpandQuery($strParentAlias, $strKey, $objValue, $objQueryExpansion); break; } catch (QCallerException $objExc) { $objExc->IncrementOffset(); throw $objExc; } default: throw new QCallerException(sprintf('Unknown Object to Expand in %s: %s', $strParentAlias, $strKey)); } } } }
function __construct($entries, $amount, $classifier) { parent::__construct("Direct Posting - " . $classifier); foreach ($entries as $entry) { if ($entry['effect'] == "dr") { $this->drAccounts[] = Account::GetLedger($entry['lid']); $this->drRatios[] = floatval(floatval($entry['amount']) / floatval($amount)); } elseif ($entry['effect'] == "cr") { $this->crAccounts[] = Account::GetLedger($entry['lid']); $this->crRatios[] = floatval(floatval($entry['amount']) / floatval($amount)); } } }
function __construct($name) { parent::__construct($name); }
function __construct() { parent::__construct(); }
protected function lstTransactionType_Create() { $this->lstTransactionType = new QListBox($this); $this->lstTransactionType->Name = QApplication::Translate('Transaction Type'); $this->lstTransactionType->Required = true; if (!$this->blnEditMode) { $this->lstTransactionType->AddItem(QApplication::Translate('- Select One -'), null); } $objTransactionTypeArray = TransactionType::LoadAll(); if ($objTransactionTypeArray) { foreach ($objTransactionTypeArray as $objTransactionType) { $objListItem = new QListItem($objTransactionType->__toString(), $objTransactionType->TransactionTypeId); if ($this->objTransaction->TransactionType && $this->objTransaction->TransactionType->TransactionTypeId == $objTransactionType->TransactionTypeId) { $objListItem->Selected = true; } $this->lstTransactionType->AddItem($objListItem); } } }
/** * Refresh this MetaControl with Data from the local Transaction object. * @param boolean $blnReload reload Transaction from the database * @return void */ public function Refresh($blnReload = false) { if ($blnReload) { $this->objTransaction->Reload(); } if ($this->lblTransactionId) { if ($this->blnEditMode) { $this->lblTransactionId->Text = $this->objTransaction->TransactionId; } } if ($this->lstEntityQtype) { $this->lstEntityQtype->SelectedValue = $this->objTransaction->EntityQtypeId; } if ($this->lblEntityQtypeId) { $this->lblEntityQtypeId->Text = $this->objTransaction->EntityQtypeId ? EntityQtype::$NameArray[$this->objTransaction->EntityQtypeId] : null; } if ($this->lstTransactionType) { $this->lstTransactionType->RemoveAllItems(); if (!$this->blnEditMode) { $this->lstTransactionType->AddItem(QApplication::Translate('- Select One -'), null); } $objTransactionTypeArray = TransactionType::LoadAll(); if ($objTransactionTypeArray) { foreach ($objTransactionTypeArray as $objTransactionType) { $objListItem = new QListItem($objTransactionType->__toString(), $objTransactionType->TransactionTypeId); if ($this->objTransaction->TransactionType && $this->objTransaction->TransactionType->TransactionTypeId == $objTransactionType->TransactionTypeId) { $objListItem->Selected = true; } $this->lstTransactionType->AddItem($objListItem); } } } if ($this->lblTransactionTypeId) { $this->lblTransactionTypeId->Text = $this->objTransaction->TransactionType ? $this->objTransaction->TransactionType->__toString() : null; } if ($this->txtNote) { $this->txtNote->Text = $this->objTransaction->Note; } if ($this->lblNote) { $this->lblNote->Text = $this->objTransaction->Note; } if ($this->lstCreatedByObject) { $this->lstCreatedByObject->RemoveAllItems(); $this->lstCreatedByObject->AddItem(QApplication::Translate('- Select One -'), null); $objCreatedByObjectArray = UserAccount::LoadAll(); if ($objCreatedByObjectArray) { foreach ($objCreatedByObjectArray as $objCreatedByObject) { $objListItem = new QListItem($objCreatedByObject->__toString(), $objCreatedByObject->UserAccountId); if ($this->objTransaction->CreatedByObject && $this->objTransaction->CreatedByObject->UserAccountId == $objCreatedByObject->UserAccountId) { $objListItem->Selected = true; } $this->lstCreatedByObject->AddItem($objListItem); } } } if ($this->lblCreatedBy) { $this->lblCreatedBy->Text = $this->objTransaction->CreatedByObject ? $this->objTransaction->CreatedByObject->__toString() : null; } if ($this->calCreationDate) { $this->calCreationDate->DateTime = $this->objTransaction->CreationDate; } if ($this->lblCreationDate) { $this->lblCreationDate->Text = sprintf($this->objTransaction->CreationDate) ? $this->objTransaction->__toString($this->strCreationDateDateTimeFormat) : null; } if ($this->lstModifiedByObject) { $this->lstModifiedByObject->RemoveAllItems(); $this->lstModifiedByObject->AddItem(QApplication::Translate('- Select One -'), null); $objModifiedByObjectArray = UserAccount::LoadAll(); if ($objModifiedByObjectArray) { foreach ($objModifiedByObjectArray as $objModifiedByObject) { $objListItem = new QListItem($objModifiedByObject->__toString(), $objModifiedByObject->UserAccountId); if ($this->objTransaction->ModifiedByObject && $this->objTransaction->ModifiedByObject->UserAccountId == $objModifiedByObject->UserAccountId) { $objListItem->Selected = true; } $this->lstModifiedByObject->AddItem($objListItem); } } } if ($this->lblModifiedBy) { $this->lblModifiedBy->Text = $this->objTransaction->ModifiedByObject ? $this->objTransaction->ModifiedByObject->__toString() : null; } if ($this->lblModifiedDate) { if ($this->blnEditMode) { $this->lblModifiedDate->Text = $this->objTransaction->ModifiedDate; } } if ($this->lstReceipt) { $this->lstReceipt->RemoveAllItems(); $this->lstReceipt->AddItem(QApplication::Translate('- Select One -'), null); $objReceiptArray = Receipt::LoadAll(); if ($objReceiptArray) { foreach ($objReceiptArray as $objReceipt) { $objListItem = new QListItem($objReceipt->__toString(), $objReceipt->ReceiptId); if ($objReceipt->TransactionId == $this->objTransaction->TransactionId) { $objListItem->Selected = true; } $this->lstReceipt->AddItem($objListItem); } } // Because Receipt's Receipt is not null, if a value is already selected, it cannot be changed. if ($this->lstReceipt->SelectedValue) { $this->lstReceipt->Enabled = false; } else { $this->lstReceipt->Enabled = true; } } if ($this->lblReceipt) { $this->lblReceipt->Text = $this->objTransaction->Receipt ? $this->objTransaction->Receipt->__toString() : null; } if ($this->lstShipment) { $this->lstShipment->RemoveAllItems(); $this->lstShipment->AddItem(QApplication::Translate('- Select One -'), null); $objShipmentArray = Shipment::LoadAll(); if ($objShipmentArray) { foreach ($objShipmentArray as $objShipment) { $objListItem = new QListItem($objShipment->__toString(), $objShipment->ShipmentId); if ($objShipment->TransactionId == $this->objTransaction->TransactionId) { $objListItem->Selected = true; } $this->lstShipment->AddItem($objListItem); } } // Because Shipment's Shipment is not null, if a value is already selected, it cannot be changed. if ($this->lstShipment->SelectedValue) { $this->lstShipment->Enabled = false; } else { $this->lstShipment->Enabled = true; } } if ($this->lblShipment) { $this->lblShipment->Text = $this->objTransaction->Shipment ? $this->objTransaction->Shipment->__toString() : null; } }
public static function GetSoapArrayFromArray($objArray) { if (!$objArray) { return null; } $objArrayToReturn = array(); foreach ($objArray as $objObject) { array_push($objArrayToReturn, TransactionType::GetSoapObjectFromObject($objObject, true)); } return unserialize(serialize($objArrayToReturn)); }
function __construct($ledgerId, $supplierId) { parent::__construct("Purchases Payment"); $this->drAccounts[] = Account::GetAccountByNo($supplierId, 'suppliers', 'Creditors'); $this->drRatios[] = 1; $this->crAccounts[] = Account::GetLedger($ledgerId); $this->crRatios[] = 1; //this info should originate from the database, insert ignore protocol included //$this->code = self::GetCode('PayPal'); //parent::__construct(); }
<div class="form"> <div class="row"> <label>Transaction Type</label> <?php echo CHtml::dropDownList('transaction_type', '', CHtml::listData(TransactionType::model()->findAll(), 'id', 'type'), array('empty' => '-- select transcation type --')); ?> </div> <div class="row"> <label>Component Name</label> <?php $this->widget('zii.widgets.jui.CJuiAutoComplete', array('model' => new Components(), 'attribute' => 'component_name', 'sourceUrl' => array('/transactions/componentstransaction/cekcomponents'), 'options' => array('minLength' => '1', 'search' => 'js:function(event, ui){ $(\'#hospital_id\').val(-1); }', 'select' => 'js:function(event, ui){ document.getElementById(\'keterangan\').innerHTML = \'Code : \'+ui.item.code; document.getElementById(\'component_id\').value = ui.item.id; }'), 'htmlOptions' => array('style' => 'height:25px;width:200px;padding:0px 5px;', 'class' => 'mf'), 'htmlOptions' => array('style' => 'width:50%;'))); ?> <input type="hidden" name="component_id" id="component_id"> </div> <div class="row"> <b id="keterangan"> </b></div> <div class="row"> <label>From Warehouse</label> <?php echo CHtml::dropDownList('warehouse_from', '', CHtml::listData(Warehouse::model()->findAll(), 'id', 'name_warehouse'), array('empty' => '-- select warehouse --')); ?> </div>
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer the ID of the model to be loaded */ public function loadModel($id) { $model = TransactionType::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }