function SaveHat($sql, $suppliers)
{
try {
$conn = new MyDb();
$id = $conn->SaveDataWithTransaction($sql, true, false);
if ($id != 0) {
$suppliers_sql = " insert into map_hat_supplier ";
$supplier_array = explode(',', $suppliers);
foreach ($supplier_array as $sid) {
$dataArray = array("map_hat_id" => "'" . $id . "'", "map_supplier_id" => "'" . $sid . "'");
$sqltemp = $suppliers_sql . parent::GetInsertSQL($dataArray);
$conn->SaveDataWithTransaction($sqltemp, false, false);
}
}
$conn->CommitTransaction();
$conn->Close();
return $id;
} catch (Exception $e) {
$conn->Close();
echo $e->getMessage();
}
return 0;
}