se/SE/bash_force_classified_table_by_GroupID.php

<?php
/**
 * 2017-08-16 by a.binder - force A_CLASSIFIED/A_ADM_COMPANY by GroupID - use for single table
 * 
 *
 */

ini_set('max_execution_time', 300);
ini_set('memory_limit', '512M');

define('DS', DIRECTORY_SEPARATOR);
define('APP_PATH_ROOT', dirname(__FILE__));
define('APP_PATH_WWW', dirname(__FILE__));
define('APP_PATH_CONFIG', APP_PATH_ROOT . DS . 'config');

// set ini to log errors into error log file
ini_set('display_startup_errors', '0');
ini_set('log_errors', '1');
ini_set('error_log', '/var/log/apache2/error_log');// TODO: php.ini ?

require_once APP_PATH_ROOT . DS . 'se-lib' . DS . 'Lib.php';
Lib::loadClass('V');
Lib::loadClass('Config');
Lib::loadClass('DB');
Lib::loadClass('User');
Lib::loadClass('UserStorageFactory');
Lib::loadClass('UsersLdapHelper');


if (isset($_SERVER["argv"][3])) {
	$_SERVER['SERVER_NAME'] = $_SERVER["argv"][1];
	$groupID = $_SERVER["argv"][2];
	$Table = $_SERVER["argv"][3];
}

else {
	die("\n The second argument should be server domain - e.g. biuro.biall-net.pl and third idGroup e.g. 3,  and last should be table name e.g. CRM_PROCES \n");
}

$groupsNetwork=UsersLdapHelper::getGroupsByID($groupID);
	foreach ($groupsNetwork as $vGroup) {
		echo "Will try to update table ".$Table." set A_CLASSIFIED='".$vGroup->cn."', A_ADM_COMPANY='".$vGroup->cn."' ; ";
		$query = "update table `".$Table."` set `A_CLASSIFIED`='".$vGroup->cn."', `A_ADM_COMPANY`='".$vGroup->cn."' ";
		DB::getPDO()->query($query);
	}

//print_r($groupsNetwork);

die(".EOF - OK\n");

?>