public static function getPODists($poId) { $dists= PoDists::model()->findAllByAttributes(array( 'PO_ID' => $poId, )); $i=0; if($dists){ foreach ($dists as $dist) { $return_array[$i]['PO_Dists_GL_Code']=$dist->PO_Dists_GL_Code; $return_array[$i]['Short_Hand']=$dist->Short_Hand; $return_array[$i]['PO_Dists_Amount']=$dist->PO_Dists_Amount; $return_array[$i]['PO_Dists_Description']=$dist->PO_Dists_Description; $i++; } for($i = count($return_array); $i < 4; $i++) { $return_array[$i] = array( 'PO_Dists_GL_Code' => '', 'Short_Hand'=>'', 'PO_Dists_Amount' => '', 'PO_Dists_Description' => '', ); } $empty=false; } else { for($i = 1; $i <= 4; $i++) { $return_array[$i] = array( 'PO_Dists_GL_Code' => '', 'Short_Hand'=>'', 'PO_Dists_Amount' => '', 'PO_Dists_Description' => '', ); } $empty=true; } return array('empty'=>$empty,'dists'=>$return_array); }
/** * Delete PO with rows in relative tables * @param $poId */ public static function deletePO($poId) { $po = Pos::model()->with('document.image')->findByPk($poId); if ($po) { $document = $po->document; $image = $document->image; $image->delete(); $document->delete(); PoDists::model()->deleteAllByAttributes(array( 'PO_ID' => $poId, )); PoDescDetail::model()->deleteAllByAttributes(array( 'PO_ID' => $poId, )); PoPmtsTraking::model()->deleteAllByAttributes(array( 'PO_ID' => $poId, )); // delete thumbnail $filePath = 'protected/data/thumbs/' . $po->Document_ID . '.jpg'; if (file_exists($filePath)) { @unlink($filePath); } // delete library links LibraryDocs::deleteDocumentLinks($po->Document_ID); $po->delete(); } }