Example #1
0
        //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['Адрес организации']];
        $values['con'] = $data[$column_name['Контактные данные']];
        $values['dat'] = $date;
        $db->insertValues($values);
    }
    //echo microtime(true) - $st;
    echo 'Writed';
} else {
    echo 'Exist';
}
unset($db);