INSERT
INTO `table` (`LOGIN_ID`, `Start`, `End`, `Session_ID`)
VALUES (:loginId, :start, :end, :sessionId)
ON DUPLICATE KEY UPDATE `End` = GREATEST(`End`, :end)SELECT `o`.`datestart`, `o`.`time`, `cl`.`fio`, `clt`.`type`, `s`.`servicename`,
`o`.`id` as `order_id`, `o`.`orderstatusid`, `o`.`paymentid`,
`oget`.`name` as `getname` , `odo`.`name` as `doname`
FROM (
SELECT `datestart`, `time`, `id`, `orderstatusid`, `paymentid`
FROM `cs_orders`
WHERE CONCAT(o.datestart,' ',o.time)
BETWEEN '2020-05-13 00:00:00' AND '2020-05-13 16:38:00'
) AS `o`
JOIN `cs_client` AS `cl` ON `cl`.`idpromin` = `o`.`idEKB`
JOIN `cs_clientstypes` AS `clt` ON `clt`.`id` = `cl`.`prioritet`
JOIN `cs_service` AS `s` ON `s`.`id` = `o`.`serviceid`
JOIN `operators` AS `odo` ON `odo`.`login` = `o`.`logindo`
JOIN `operators` AS `oget` ON `oget`.`login` = `o`.`loginget`
ORDER BY `order_id` DESC
LIMIT 20$arr = ['863|20', '863|50', '822|100', '822|100'];
$result = array_reduce(
$arr,
function ($carry, $item) {
$els = explode('|', $item);
$carry[+$els[0]] = ($carry[+$els[0]] ?? 0) + $els[1];
return $carry;
},
[]
);
print_r($result);
// Array (
// [863] => 70
// [822] => 200
// )$searchClear.click(function (e) {
e.stopPropagation();
$searchTrigger.removeClass("active");
});<operation name="getRefbook">
<documentation>
Возвращает полную указанную версию справочника, если это возможно
</documentation>
<input message="typens:getRefbook"> </input>
<output message="typens:getRefbookResponse"> </output>
</operation><message name="getRefbook">
<part name="userKey" type="xsd:string"> </part>
<part name="refbookCode" type="xsd:string"> </part>
<part name="version" type="xsd:string"> </part>
</message>$client->getRefbook([
'userKey' => '1111f0cf-b111-1d11-a111-1cee1111d111',
'refbookCode' => '1.2.643.5.1.13.2.1.1.194',
'version' => '1.0'
]);function func($arg1, $arg2 = null) {}
$refFunc = new ReflectionFunction('func');
print $refFunc->getNumberOfParameters(); // 2
print $refFunc->getNumberOfRequiredParameters(); // 1const intervals = [
{ start: '11:00:00', end: '13:00:00' },
{ start: '15:00:00', end: '17:00:00' }
]
const findIntersection = (intervals, start, end) =>
intervals.find(
interval => start < interval.end && interval.start < end
)
findIntersection(intervals, '09:00:00', '11:00:00')
// undefined
findIntersection(intervals, '09:00:00', '12:00:00')
// Object { start: "11:00:00", end: "13:00:00" }It returns its first operand if it exists and is not NULL; otherwise it returns its second operand.Как видите, в оригинальном тексте речь идёт не о равенстве с NULL, а о том, что значение не является NULL.
$arr = json_decode($json, true);
$newJson = json_encode([
'total' => count($arr),
'totalNotFiltered ' => count($arr),
'rows' => array_map(
function ($uid, $el) {
$el['uid'] = $uid;
return $el;
},
array_keys($arr),
array_values($arr)
)
]);