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));
}
