本文整理汇总了PHP中SQLQBuilder::simpleDelete方法的典型用法代码示例。如果您正苦于以下问题:PHP SQLQBuilder::simpleDelete方法的具体用法?PHP SQLQBuilder::simpleDelete怎么用?PHP SQLQBuilder::simpleDelete使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQLQBuilder
的用法示例。
在下文中一共展示了SQLQBuilder::simpleDelete方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: copyQuota
/**
* Copy leave quota between years
*
* Copy leave quota from $fromYear to $toYear
*
* @param int $fromYear
* @param int $toYear
* @return boolean
*/
public function copyQuota($fromYear, $toYear)
{
$sqlBuilder = new SQLQBuilder();
$table = "`" . self::LEAVEQUOTA_DB_TABLE_EMPLOYEE_LEAVE_QUOTA . "`";
$insertFields[0] = "`" . self::LEAVEQUOTA_DB_FIELD_YEAR . "`";
$insertFields[1] = "`" . self::LEAVEQUOTA_DB_FIELD_LEAVE_TYPE_ID . "`";
$insertFields[2] = "`" . self::LEAVEQUOTA_DB_FIELD_EMPLOYEE_ID . "`";
$insertFields[3] = "`" . self::LEAVEQUOTA_DB_FIELD_NO_OF_DAYS_ALLOTED . "`";
$selectFields[0] = "{$toYear}";
$selectFields[1] = "`" . self::LEAVEQUOTA_DB_FIELD_LEAVE_TYPE_ID . "`";
$selectFields[2] = "`" . self::LEAVEQUOTA_DB_FIELD_EMPLOYEE_ID . "`";
$selectFields[3] = "`" . self::LEAVEQUOTA_DB_FIELD_NO_OF_DAYS_ALLOTED . "`";
$selectConditions[0] = "`" . self::LEAVEQUOTA_DB_FIELD_YEAR . "` = '{$fromYear}'";
$selectQuery = $sqlBuilder->simpleSelect($table, $selectFields, $selectConditions);
$deleteConditions[0] = "`" . self::LEAVEQUOTA_DB_FIELD_YEAR . "` = '{$toYear}'";
$deleteQuery = $sqlBuilder->simpleDelete($table, $deleteConditions);
$query = $sqlBuilder->simpleInsert($table, $selectQuery, $insertFields);
$dbConnection = new DMLFunctions();
$dbConnection->executeQuery($deleteQuery);
$result = $dbConnection->executeQuery($query);
if ($result) {
return true;
}
return false;
}