ZC Inventory Report Module

[gaffettape]

Tried installing this again and seems to be working correctly now, which is great.

I was wondering if there was a way to show and sort via model number, the same way you can via ID#, price, total etc.?

Thanks.

[Ajeh]

You'd need to customize a few things ...

In the case statement add:

// bof: add products_model
    case('products_model'):
        $dir_model = $op_dir;
        break;
// eof: add products_model

                <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=cd.categories_name&dir=<?php echo $dir_name; ?>&cat=<?php echo $cat; ?>"><b>Master Category</b></a></td>
<!-- // bof: add products_model -->
          <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_model&dir=<?php echo $dir_model; ?>&cat=<?php echo $cat; ?>"><b>Model</b></a></td>
<!-- // eof: add products_model -->
                <td class="dataTableHeadingContent" align="center"><a href="./stats_inventory_report.php?page=<?php echo $_GET['page']; ?>&sort=products_quantity&dir=<?php echo $dir_quantity; ?>&cat=<?php echo $cat; ?>"><b><?php echo TABLE_HEADING_QUANTITY; ?></b></a></td>

// bof: add products_model
  $products_query_raw = "select p.products_id, products_quantity, pd.products_name, p.products_model, p.products_price, (products_quantity * p.products_price) as total, categories_name from ".TABLE_PRODUCTS." p left join ".TABLE_PRODUCTS_DESCRIPTION." pd using(products_id) LEFT JOIN ".TABLE_CATEGORIES_DESCRIPTION." cd ON(cd.categories_id = p.master_categories_id AND cd.language_id = '$lang_id') $db_category_where group by p.products_id order by $sort $dir";
// eof: add products_model

                <td class="dataTableContent" align="left"><?php echo $products->fields['categories_name']; ?>&nbsp;</td>
<!-- // bof: add products_model -->
          <td class="dataTableContent" align="left"><?php echo $products->fields['products_model']; ?>&nbsp;</td>
<!-- // eof: add products_model -->
                <td class="dataTableContent" align="center"><?php echo $products->fields['products_quantity']; ?>&nbsp;</td>

              <tr class="dataTableHeadingRow">
<!-- // bof: add products_model -->
                <td colspan="6">&nbsp;</td>
<!-- // bof: add products_model -->
                <td class="dataTableHeadingContent" align="right"><?php echo $currencies->format($total); ?></td>

[gaffettape]

Wow, thanks Linda!

It's always appreciated when you go out of your way to help out like that! (Not to take anything away from the addon author, of course.)

I had a go at making the changes to the file myself but I ended up with mismatched table headings and contents. Would it be possible for you to post the entire customized stats_inventory_report.php file?

Thanks

[Ajeh]

See if this helps ...

[gaffettape]

See if this helps ...

Perfect!

Thank you so much, really appreciate it

[Ajeh]

You are most welcome ... glad that this is working for you ...

[wmorris]

I like this mod,,,, it would be nice if there is a button would say "Print Report" to have a print out on paper is this possible?

[muteyaar]

Hi,
Thanks for the required file which gives the report with model number.

But this file has one problem........ The GENERATE CSV FILE link is missing.
Can you please check and rectify the problem and please upload the new file? It will be very much appreciated, as csv download link is a must.
thanks in advance.

muteyaar

[mprough]

That is not currently part of the module, it's not missing...........................

[muteyaar]

That is not currently part of the module, it's not missing...........................

The CSV DOWNLOAD link is there at the top right of the page when we upload the original files.
But as there is no option of MODEL number, I tried to search and found that Ajeh had given a new file to be replaced in this thread at page number 3.
That file shows the model number very finely, but the CSV FILE DOWNLOAD link (GENERATE CSV) is missing in that case, which is a must have option, because we can only utilize this module properly if we are able to download the csv file of inventory.

I hope you will help me out in this regard.
thank you in advance and waiting for your reply.
- muteyaar