<?php $form=$this->beginWidget('CActiveForm', array ('id'=>'coa_adding_form'));?>
<div class="row popup_row">
<table>
<tr>
<td><?php echo $form->DropDownList(CoaClass::model(),'COA_Class_ID',CHtml::listData($coa_classes,'COA_Class_ID','Class_Shortcut'));?></td>
<td><?php echo $form->TextField($coa,'COA_Name');?></td>
<td><?php echo $form->TextField($coa,'COA_Acct_Number');?></td>
<td><?php echo $form->TextField($coa,'COA_Budget');?></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td style="text-align: right;padding-right: 30px;">
<a href="#" id="confirm_coa_adding">Save</a><br>
<a href="#" id="cancel_coa_adding">Cancel</a>
</td>
</tr>
</table>
</div>
/**
* Copy COAs from another project
* @param $clientID
* @param $projectID
* @param $clientFromCopyId
* @param $projectFromCopyId
*/
public static function copyCOAs($clientID, $projectID, $client_to_id, $project_to_id)
{
$clientID = intval($clientID);
$projectID = intval($projectID);
$project_to_id = intval($project_to_id);
$client_to_id = intval($client_to_id);
$coasToCopy = Coa::getClientsCOAs($clientID, $projectID);
foreach($coasToCopy as $coaToCopy) {
$coaClass = CoaClass::model()->findByAttributes(array(
'Project_ID' => $project_to_id,
'Class_Shortcut' => $coaToCopy->class->Class_Shortcut,
));
if ($coaClass) {
$coa = Coa::model()->findByAttributes(array(
'Project_ID' => $project_to_id,
'COA_Acct_Number' => $coaToCopy->COA_Acct_Number,
));
if (!$coa) {
$coa = new Coa();
$coa->COA_Budget = 0;
$coa->COA_Current_Total = 0;
}
$coa->Client_ID = $client_to_id;
$coa->COA_Acct_Number = $coaToCopy->COA_Acct_Number;
$coa->Project_ID = $project_to_id;
$coa->COA_Name = $coaToCopy->COA_Name;
$coa->COA_Class_ID = $coaClass->COA_Class_ID;
if ($coa->validate()) {
$coa->save();
}
}
}
}
/**
* Get List of Classes for a defined project
*/
public static function getCoaClassesList($project_id) {
/*$coa_classes = CoaClass::model()->findAllByAttributes(
array('Project_ID' => $project_id)
);*/
/*$sql = 'select COA_Class_ID,Class_Shortcut from coa_class where Project_ID='.$project_id;
$list= Yii::app()->db->createCommand($sql)->queryAll();
$result = array();
foreach ($list as $item) {
$result[] = $item['Class_Shortcut'];
}
return $result;*/
return CoaClass::model()->findAllByAttributes(
array('Project_ID' => $project_id)
);
}
