function generateStock($p_item, $p_comp_id)
{
global $mysqli;
/** @var $result mysqli_result */
$mysqli->autocommit(FALSE);
$mysqli->query("DROP TEMPORARY TABLE IF EXISTS item_stock_temp");
$sql = "" . "CREATE TEMPORARY TABLE item_stock_temp (" . " I_CODE INT," . " G_CODE INTEGER," . " OP_QTY DECIMAL(22, 2)," . " OP_FLAG VARCHAR(5)," . " COST_RATE DECIMAL(7,2)," . " TRANS_DATE DATE" . ")";
$mysqli->query($sql);
$sql = "" . "SELECT year_id, start_date" . " FROM sys_financial_year" . " WHERE is_active = 'Yes'" . " AND company_ref_id = {$p_comp_id}";
$result = $mysqli->query($sql);
$row = $result->fetch_assoc();
$v_current_year = $row['year_id'];
$v_year_opn_date = $row['start_date'];
if ($p_item == 'ALL') {
$result = $mysqli->query("SELECT i_code FROM item_master WHERE company_ref_id = {$p_comp_id}");
$iCodes = array();
while ($row = $result->fetch_assoc()) {
$iCodes[] = $row['i_code'];
}
foreach ($iCodes as $v_i_code) {
insertStock($mysqli, $v_i_code, $v_current_year, $v_year_opn_date);
}
} else {
insertStock($mysqli, $p_item, $v_current_year, $v_year_opn_date);
}
$mysqli->commit();
$mysqli->autocommit(TRUE);
}
}
echo json_encode($jsonArray);
}
if ($_GET['action']) {
$action = $_GET['action'];
switch ($action) {
case 'insertStock':
$name = $_GET['name'];
$symbol = $_GET['symbol'];
$ysymbol = $_GET['ysymbol'];
$valuta = $_GET['valuta'];
$isin = $_GET['isin'];
$sektor = $_GET['sektor'];
$icb = $_GET['icb'];
$owned = $_GET['owned'];
insertStock($con, $name, $symbol, $ysymbol, $valuta, $isin, $sektor, $icb, $owned);
break;
case 'insertStockHistory':
$ysymbol = $_GET['symbol'];
$date = $_GET['date'];
$open = $_GET['open'];
$high = $_GET['high'];
$low = $_GET['low'];
$close = $_GET['close'];
$volume = $_GET['volume'];
$adj_close = $_GET['adj_close'];
insertStockHistory($con, $ysymbol, $date, $open, $high, $low, $close, $volume, $adj_close);
break;
case 'updateStockHistory':
updateStockHistory($con);
break;
