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