function handle(DataObject $model)
{
$db = DB::Instance();
$query = 'SELECT max(complaint_number) FROM ' . $model->getTableName() . ' WHERE usercompanyid=' . EGS_COMPANY_ID . ' AND "type"=' . $db->qstr($model->type);
$current = $db->GetOne($query);
return $current + 1;
}
function handle(DataObject $model)
{
$jn = $model->job_no;
if (empty($jn)) {
$db = DB::Instance();
$query = 'SELECT max(despatch_number) FROM ' . $model->getTableName() . ' WHERE usercompanyid=' . EGS_COMPANY_ID;
$current = $db->GetOne($query);
return $current + 1;
}
}
function handle(DataObject $model)
{
$db =& DB::Instance();
$query = 'SELECT max(' . $this->position_field . ') FROM ' . $model->getTableName();
if ($model->isField('usercompanyid')) {
$query .= ' WHERE usercompanyid=' . $db->qstr(EGS_COMPANY_ID);
}
$position = $db->GetOne($query);
$position++;
return $position;
}
function handle(DataObject $model)
{
$jn = $model->identifierField;
$unique = $model->checkUniqueness($jn);
$value = $model->getIdentifierValue();
if (!empty($jn) && $unique && empty($value)) {
$db = DB::Instance();
$query = 'SELECT ' . $this->function . '(' . $jn . ') FROM ' . $model->getTableName() . ' WHERE usercompanyid=' . EGS_COMPANY_ID;
$current = $db->GetOne($query);
// $current = ($current==0)?$this->counter:$current;
return bcadd($current, $this->counter, 0);
}
}
function handle(DataObject $model)
{
$db = DB::Instance();
$id = $db->GenID($model->getTableName() . '_id_seq');
return $id;
}
