public function actionSelectLegerItem() { if (isset($_POST["select_leger_items_company_name"]) && $_POST["select_leger_items_company_name"] != "") { $array_post = $_POST; $company_id = $_POST["select_leger_items_company_name"]; $ret = SelectLedgerItem::model()->deleteAll("company_id ='" . $company_id . "'"); foreach ($array_post as $key => $value) { if ($key == 'select_leger_items_company_name') { continue; } $item = new SelectLedgerItem(); $item->company_id = $company_id; $item->item_id = $value; $item->save(); } } }
public function actionIndex() { if (isset($_POST["select_leger_items_company_name"]) && $_POST["select_leger_items_company_name"] != "") { $array_post = $_POST; $company_id = $_POST["select_leger_items_company_name"]; $selected_item = ""; foreach ($array_post as $key => $value) { if ($key == 'select_leger_items_company_name') { continue; } $selected_item .= $value . ';'; } $criteria = new CDbCriteria(); $criteria->addCondition("`company_id` = '" . $company_id + "'"); $item = SelectLedgerItem::model()->find($criteria); if (!isset($item)) { $item = new SelectLedgerItem(); $item->Company_id = $company_id; } $item->selected_item = $selected_item; $item->save(); } $model = new General(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['General'])) { $model->attributes = $_POST['General']; $model->total_1 = $model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1; $model->total_2 = $model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank; $model->total_3 = $model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation; $model->netcurrentLiabilities = $model->netcurrentLiabilities = $model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank - ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation); $model->total_4 = $model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 + $model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank - $model->otherPayable - $model->amountOwnSubsidy - $model->amountOwnDirect - $model->purchasePayable - $model->bankOverdraft - $model->taxation; $model->shareHolderfund = $model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost; $model->total_5 = $model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest; $model->total_6 = $model->purchasePayable1 + $model->taxLiabilities; $model->total_7 = $model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest + $model->purchasePayable1 + $model->taxLiabilities; $model->lossProfitFromOperations = $model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses; $model->lossProfitbeforetaxation = $model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit; $model->lossProfitaftertaxation = $model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit + $model->taxationFinance; $model->netlossProfitforthefinancialyear = $model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit + $model->taxationFinance + $model->minoritySharedholder; if ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation > 0) { $model->currentRatio = ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank) / ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation); } if ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation > 0) { $model->quickRatio = ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank - 0 - 0) / ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation); } if (($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost) * 100 > 0) { $model->debtToEquity = ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation + ($model->purchasePayable1 + $model->taxLiabilities)) / ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost) * 100; } if ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 + ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank) > 0) { $model->debtTototalassets = ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation + ($model->purchasePayable1 + $model->taxLiabilities)) / ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 + ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank)); } if ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest > 0) { $model->totalCapitalisation = ($model->purchasePayable1 + $model->taxLiabilities) / ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest); } if ($model->financeCost > 0 || $model->financeCost < 0) { $model->interestCoverage = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit) / $model->financeCost; } if ($model->revenue + $model->otherOperatingIncome > 0) { $model->grossProfitmargin = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses) / ($model->revenue + $model->otherOperatingIncome); } if ($model->revenue + $model->otherOperatingIncome > 0) { $model->netProfitMargin = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit + $model->taxationFinance) / ($model->revenue + $model->otherOperatingIncome); } if ($model->revenue > 0) { $model->grossOperatingmargin = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses) / $model->revenue; } if ($model->revenue > 0) { $model->netOperatingmargin = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit + $model->financeCost) / $model->revenue; } if ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost > 0) { $model->returnOnequity = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit + $model->taxationFinance) / ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost); } if ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 + ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank) > 0) { $model->returnOnassets = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit + $model->financeCost) / ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 + ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank)); } if ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest + ($model->purchasePayable1 + $model->taxLiabilities) > 0) { $model->returnOncapitalemployed = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses) / ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest + ($model->purchasePayable1 + $model->taxLiabilities)); } if ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest > 0) { $model->earningPershare = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses + $model->financeCost + $model->sharedOfLossprofit) / ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest); } if ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 + ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank) > 0) { $model->totalAssetturnover = $model->revenue / ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 + ($model->tradeReceivable + $model->otherReceivable + $model->amountSubsidy + $model->amountAssociated + $model->fixedDeposit + $model->cash_bank)); } if ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1 > 0) { $model->fixedAssetsturnover = $model->revenue / ($model->pro_1 + $model->intangible_1 + $model->development_1 + $model->invest_sub_1 + $model->invest_aso_1 + $model->other_1); } if ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest > 0) { $model->gearingRatiodebt = ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation + ($model->purchasePayable1 + $model->taxLiabilities)) / ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest); } if ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation + ($model->purchasePayable1 + $model->taxLiabilities) + ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest) > 0) { $model->gearingRatiofinance = ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation + ($model->purchasePayable1 + $model->taxLiabilities)) / ($model->otherPayable + $model->amountOwnSubsidy + $model->amountOwnDirect + $model->purchasePayable + $model->bankOverdraft + $model->taxation + ($model->purchasePayable1 + $model->taxLiabilities) + ($model->shareCapital + $model->sharePremium + $model->preferenceShare + $model->foreignExchange + $model->AccLost + $model->preferenceShare1 + $model->minorityInterest)); } if ($model->financeCost > 0 || $model->financeCost < 0) { $model->interestCover = ($model->revenue + $model->otherOperatingIncome + $model->directOperatingExpenses + $model->administrationExpenses + $model->otherOperatingExpenses) / -$model->financeCost; } if ($model->save()) { $this->redirect(array('select_general')); } } $this->render('index', array('model' => $model)); }