- Модуль: timeman
- Путь к файлу: ~/bitrix/modules/timeman/lib/update/timemanversion19converter.php
- Класс: BitrixTimemanUpdateTimemanVersion19Converter
- Вызов: TimemanVersion19Converter::saveTempViolations
private function saveTempViolations($connection)
{
$violationSql = 'REPLACE INTO `b_timeman_converter_violation_rules` (FORM_DATA, ENTITY_CODE, VIOLATION_RULES_SAVED) VALUES ';
$violationValues = [];
foreach ($this->violationForms as $entityCode => $violationForm)
{
$formData = [
'UF_TM_MAX_START' => $violationForm->maxExactStart,
'UF_TM_MIN_FINISH' => $violationForm->minExactEnd,
'UF_TM_MIN_DURATION' => $violationForm->minDayDuration,
'UF_TM_ALLOWED_DELTA' => $violationForm->maxAllowedToEditWorkTime,
];
$violationValues[] = '("' . $connection->getSqlHelper()->forSql(json_encode($formData)) . '",'
. '"' . $connection->getSqlHelper()->forSql($violationForm->entityCode) . '",'
. ($this->violationRulesSaved ? '1' : '0')
. ')';
}
if (!empty($violationValues))
{
$violationSql .= implode(",n", $violationValues);
$connection->query($violationSql);
}
}