* Дополнительные пожелания
* З/П руб.
* Адрес организации
* Контактные данные
*/
$try_count = 5;
//max num of rows, which script will skip
do {
//this row can be empty, so, check it
$names_row = array_shift($sheetData);
//slice the columns names
$try_count--;
} while (!$names_row['A'] && $try_count > 0);
if (!$names_row['A']) {
mail('*****@*****.**', 'NY86.ru empty vac file', print_r($sheetData, true));
$db->deleteDateRec($datestring);
//if it still empty, rollback to prev
exit;
}
$column_name = [];
foreach ($names_row as $col => $name) {
$column_name[$name] = $col;
}
//$st = microtime(true);
$date = date('Ymd');
foreach ($sheetData as $row => $data) {
$values['pro'] = $data[$column_name['Профессия']];
$values['org'] = $data[$column_name['Организация']];
$values['add'] = $data[$column_name['Дополнительные пожелания']];
$values['sal'] = $data[$column_name['З/П руб.']];
$values['adr'] = $data[$column_name['Адрес организации']];
