for ($row = 5; $row <= $data->rowcount(); $row++) {
if ($data->format($row, 3) != "") {
$arr_test = explode(" ", $data->format($row, 3));
$uom = str_replace('"', "", $arr_test[1]);
if (!in_array($uom, $unit_master)) {
$unit_master[] = $uom;
}
}
}
foreach ($unit_master as $unit_name) {
$sql_unit_master = "insert into ms_uom set\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tname = '" . $unit_name . "'";
$result_ins = mysql_query($sql_unit_master) or die("Error in query:" . $sql_unit_master . "<br>" . mysql_error() . ":" . mysql_errno());
}
$dep_id = 0;
for ($row = 5; $row <= $data->rowcount(); $row++) {
if ($data->bold($row, 1, 0)) {
$sql_department = "insert into ms_department set\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tname = '" . $data->value($row, 1, 0) . "'";
$result_ins = mysql_query($sql_department) or die("Error in query:" . $sql_department . "<br>" . mysql_error() . ":" . mysql_errno());
$dep_id = mysql_insert_id();
} else {
$unit_id = 0;
if ($data->format($row, 3) != "") {
$arr_test = explode(" ", $data->format($row, 3));
$uom = str_replace('"', "", $arr_test[1]);
}
$sql = "SELECT uom_id FROM ms_uom where name = '" . $uom . "'";
$result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error());
if (mysql_num_rows($result) > 0) {
$row_1 = mysql_fetch_array($result);
$unit_id = $row_1['uom_id'];
}
table.excel tbody td {
vertical-align:bottom;
}
table.excel tbody td {
padding: 0 3px;
border: 1px solid #EEEEEE;
}
</style>
</head>
<body>
<?
for ($row=5;$row<=$data->rowcount();$row++)
{
//for ($col=1;$col<=$xls->colcount();$col++) {
//echo $xls->val($row,$col); echo "-";
//echo $xls->raw($row,$col); echo "-";
//echo $sql_ins = "insert into ms_item_master set
// name='".$xls->val($row,1)."',
// opening_quantity = '".$xls->raw($row,2)."',
// uom_id='',
// opening_rate = '".$xls->raw($row,3)."'";
//}
}
?>
<?php
echo $data->bold(5, 1, $sheet = 0);
?>
</body>
</html>
