#!/bin/sh
cd /www/wwwroot/faithfulness
sudo -u www /usr/bin/php artisan tinker --execute="
echo 'labor_application_steps rows: '.DB::table('labor_application_steps')->count().PHP_EOL;
echo 'application_progresses rows: '.DB::table('application_progresses')->count().PHP_EOL;
echo 'workers: '.DB::table('workers')->count().PHP_EOL;
echo 'workers with labor_dept_no: '.DB::table('workers')->whereNotNull('labor_dept_no')->count().PHP_EOL;
echo 'steps sample: '.json_encode(DB::table('labor_application_steps')->latest('id')->first(), JSON_UNESCAPED_UNICODE).PHP_EOL;
echo 'progress sample: '.json_encode(DB::table('application_progresses')->latest('id')->first(), JSON_UNESCAPED_UNICODE).PHP_EOL;
" 2>&1 | grep -E "rows|workers|sample"