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