public function actionApprove()
{
parent::actionApprove();
$id = $_POST['id'];
foreach ($id as $ids) {
$connection = Yii::app()->db;
$transaction = $connection->beginTransaction();
try {
$sql = 'call ApproveGI(:vid, :vlastupdateby)';
$command = $connection->createCommand($sql);
$command->bindValue(':vid', $ids, PDO::PARAM_INT);
$command->bindValue(':vlastupdateby', Yii::app()->user->name, PDO::PARAM_STR);
$command->execute();
$transaction->commit();
$this->GetSMessage('igiapprovesuccess');
} catch (Exception $e) {
$transaction->rollBack();
$this->GetMessage($e->getMessage());
}
}
Yii::app()->end();
}
public function actionApprove()
{
parent::actionApprove();
$id = $_POST['id'];
foreach ($id as $ids) {
//$model=$this->loadModel($ids);
$a = Yii::app()->user->name;
$connection = Yii::app()->db;
$transaction = $connection->beginTransaction();
try {
$sql = 'call ApproveEmployeeSchedule(:vid, :vlastupdateby)';
$command = $connection->createCommand($sql);
$command->bindvalue(':vid', $ids, PDO::PARAM_INT);
$command->bindvalue(':vlastupdateby', $a, PDO::PARAM_STR);
$command->execute();
$transaction->commit();
$this->GetSMessage('pprinsertsuccess');
} catch (Exception $e) {
$transaction->rollBack();
$this->GetMessage($e->getMessage());
}
}
}
