Yii Gridview List

Controller Code 

Out View

Code View

Yii : Custom Running Numbers

Yii Gen Custom Running Numbers Max ID

$criteria = new CDbCriteria; $criteria->select = 'max(carrent_id) AS maxCarrentID'; $row = $CarRental->model()->find($criteria); $nextID = $row['maxCarrentID']; $CurYear = substr(date('Ym'), 2, 4); $year = substr($nextID, 0, 4); $number = substr($nextID, 5, 4) + 1; if ($nextID = 0) { $CurYear = substr(date('Ym'), 2, 4); $runNumber = sprintf('%04d', 1); $newCarrentID = $CurYear . "-" . $runNumber; } else { // check Diff Year if ($CurYear = $year) { $CurYear = substr(date('Ym'), 2, 4); $runNumber = sprintf('%04d', $number); $newCarrentID = $CurYear . "-" . $runNumber; } else { $CurYear = substr(date('Ym'), 2, 4); $runNumber = sprintf('%04d', 1); $newCarrentID = $CurYear . "-" . $runNumber; } }

Yii DateFormat Input To Mysql Format

Yii Learning | Yii Chang Date Format From dd/mm/yyyy to yyyy-mm-dd

date('Y-m-d', CDateTimeParser::parse($_POST['tbAccjvs']['JVDATE'], 'dd/mm/yyyy'));

Good Luck By Yii Learning

Yii Function : createMultipleInsertCommand

Yii 1.1.14

$builder = Yii::app()->db->schema->commandBuilder; $command=$builder->createMultipleInsertCommand('tbl_accjvs', array( array('MemberID'=>$MemberID,'MINOR_CODE'=>$minorCode,'JVACC_CODE'=>$jvcrCode,'JVDATE'=>$jvDate,'JVNO'=>'','JVITEM'=>$jvItem,'JVAMT'=>$jvAmt, 'JVCR'=>'Y', 'JVDR'=>'N', 'JVREMARK'=>$jvRemark,'JVPOSTDATE'=>$jvPostDate,'JVUPDATE'=>$jvPostDate), array('MemberID'=>$MemberID,'MINOR_CODE'=>$minorCode,'JVACC_CODE'=>$jvdrCode,'JVDATE'=>$jvDate,'JVNO'=>'','JVITEM'=>$jvItem,'JVAMT'=>$jvAmt, 'JVCR'=>'N', 'JVDR'=>'Y', 'JVREMARK'=>$jvRemark,'JVPOSTDATE'=>$jvPostDate,'JVUPDATE'=>$jvPostDate), )); $command->execute();