source: branches/1.1dev/bin/file_importer.php

#!/usr/bin/env php
<?php
/**
 * file_importer.cli.php
 * Code by Strangecode :: www.strangecode.com :: This document contains copyrighted information
 */

require realpath(dirname(__FILE__) . '/..') . '/config/cli_config.inc.php';

// Test arguments.
if ($_SERVER['argc'] == 2 && is_dir($_SERVER['argv'][1])) {
    $file_dir = preg_replace('/\/$/', '', $_SERVER['argv'][1]);
} else {
    die("You must specify the directory of files to import as the only argument.\n");
}

// Get array of all files.
$files = getFilesRecursive($file_dir, 1);

// Loop through files.
// dump($files);
$file_count = 0;
if (is_array($files) && !empty($files)) {
    foreach ($files as $file) {
        if ($fp = fopen($file, 'r')) {
            echo ++$file_count . "\n";
            $file_text = join('', file($file));
            fclose($fp);

            // Do something with file contents.
            preg_match('/BALANCE:\s*\$([\.\d]+)/', $file_text, $amt);
            $file_date = date('Y-m-d', strtotime(preg_replace('|[^_]*_|', '', basename($file))));
//             dbQuery("
//                 INSERT INTO invoice_tbl (
//                     client_id,
//                     invoice_type,
//                     invoice_date,
//                     invoice_amount,
//                     invoice_status,
//                     payment_type,
//                     invoice_text,
//                     email_sent_datetime,
//                     added_datetime
//                 ) VALUES (
//                     '" . mysql_real_escape_string(0) . "',
//                     '" . mysql_real_escape_string('hosting') . "',
//                     '" . mysql_real_escape_string($file_date) . "',
//                     '" . mysql_real_escape_string($amt[1]) . "',
//                     '" . mysql_real_escape_string('Paid') . "',
//                     '" . mysql_real_escape_string('') . "',
//                     '" . mysql_real_escape_string($file_text) . "',
//                     '" . mysql_real_escape_string($file_date) . "',
//                     NOW()
//                 )
//             ");

        } else {
            logMsg('Could not open file: ' . $file, LOG_INFO, __FILE__, __LINE__);
        }
    }
    logMsg('Proccessing complete: ' . $file_count . ' files total.', LOG_INFO, __FILE__, __LINE__);
} else {
    logMsg('No files available in that directory.', LOG_INFO, __FILE__, __LINE__);
}




/**
 * Find all files in directories recursivly with a specified file extension.
 *
 * @param  string $dir               the full path to the directory to scan
 * @param  array  $valid_extensions  valid extensions
 * @param  int    $recurs_lev        how many levels deep to scan. Set this
 *                                   to a low number to prevent infinite loops
 *
 * @return array   multi-dimentional array of found files on success
 */
function getFilesRecursive($dir, $recurs_lev=0, $return=true)
{
    static $output;

    $dir_handle = opendir($dir);
    while ($dir_handle && ($file = readdir($dir_handle)) !== false) {
        if (!preg_match('/^\./', $file)) {
            if (is_dir($dir . '/' . $file) && $recurs_lev > 0) {
                getFilesRecursive($dir . '/' . $file, $valid_extensions, $recurs_lev - 1);
            } else if (!is_dir($dir . '/' . $file)) {
                $output[] = $dir . '/' . $file;
            }
        }
    }
    if ($return) {
        return $output;
    }
}

?>