<?php

/**
* SET FOREIGN_KEY_CHECKS=0;
TRUNCATE team;
TRUNCATE player;
*/
require_once 'vendor/autoload.php';
use Subash\Classes\CSVFile;
use Subash\Classes\Teams;
use Subash\Classes\Player;
use Subash\Classes\UploadFileLog;
while (true) {
    logme("polling");
    $objFileLog = new UploadFileLog();
    $isQueuedItem = $objFileLog->getQueuedItem('PLD');
    if (count($isQueuedItem) > 0) {
        $objTeam = new Teams();
        $teams = $objTeam->getTeamIds();
        print_r($teams);
        $objPlayer = new Player();
        $players = $objPlayer->getPlayerIds();
        $filePath = $isQueuedItem['filename'];
        $uploadId = $isQueuedItem['id'];
        $fileObject = new CSVFile(__DIR__ . "/" . $filePath, true, ',', '"', '\\', true);
        $insertArray = [];
        $indexCount = 1;
        $fileObject->seek(PHP_INT_MAX);
        $totalCount = $fileObject->key();
        $fileObject->seek(0);
        $proccessed = 0;
<?php

/**
* SET FOREIGN_KEY_CHECKS=0;
TRUNCATE team;
TRUNCATE player;
*/
require_once 'vendor/autoload.php';
use Subash\Classes\CSVFile;
use Subash\Classes\Teams;
use Subash\Classes\Player;
use Subash\Classes\UploadFileLog;
while (true) {
    logme("polling");
    $objFileLog = new UploadFileLog();
    $isQueuedItem = $objFileLog->getQueuedItem('FX');
    if (count($isQueuedItem) > 0) {
        $objTeam = new Teams();
        $teams = $objTeam->getTeamIds();
        //print_r ( $teams );
        $filePath = $isQueuedItem['filename'];
        $uploadId = $isQueuedItem['id'];
        $fileObject = new CSVFile(__DIR__ . "/" . $filePath, true, ',', '"', '\\', true);
        $insertArray = [];
        $indexCount = 1;
        $fileObject->seek(PHP_INT_MAX);
        $totalCount = $fileObject->key();
        $fileObject->seek(0);
        $proccessed = 0;
        $objFileLog->startProcessing($uploadId, $totalCount, 'IP');
        logme("Start Processing on " . date('Y-M-d H:i:s'));