object(Test)#1 (2) {
["name":"Test":private]=>
string(16) "Васенька"
["age"]=>
int(43)
}
class Test#1 (2) {
private $name =>
string(16) "Васенька"
public $age =>
int(43)
}
const commonParts = (str1, str2, size) => {
const re = new RegExp(`.{1,${size}}`, 'g');
const arr1 = str1.match(re);
const arr2 = str2.match(re);
return arr1.filter((e, i) => arr2[i] === e);
}
commonParts('1342567', '1242566', 2); // [ "42", "56" ]
commonParts('1342567', '1242566', 3); // [ "256" ]
WITH `cte` (`id`, `row`) AS (
SELECT `id`, ROW_NUMBER() OVER `win`
FROM `product`
WINDOW `win` AS (PARTITION BY `sku` ORDER BY `quantity` = 0, `price`)
)
UPDATE `cte`
JOIN `product` USING (`id`)
SET `product`.`status` = (`cte`.`row` = 1)
UPDATE `product` AS `p`
LEFT JOIN (
SELECT `t`.`sku`, MIN(`p`.`id`) AS `id`
FROM (
SELECT `sku`, MIN(`price`) AS `price`
FROM `product`
WHERE `quantity` != 0
GROUP BY `sku`
) AS `t`
JOIN `product` AS `p`
ON `p`.`sku` = `t`.`sku` AND `p`.`price` = `t`.`price`
WHERE `p`.`quantity` != 0
GROUP BY `t`.`sku`
) AS `i` ON `i`.`id` = `p`.`id`
SET `p`.`status` = (`i`.`id` IS NOT NULL);
const position = await new Promise (
(resolve, reject) => navigator.geolocation.getCurrentPosition(
(p) => resolve(p),
(e) => reject(e),
),
);