How do I locate php.ini?

Question

I want to create reports like below picture's report on SSRS.

Yellow parts mean SET_PHASE, Green parts mean PROD_PHASE

And my query result like this:

I want to show for per line, all order and I want to show for per order, SETUP and PRODUCTION depends on duratıon time.

SET_PHASE's duration time is SET_DURATION,

PROD_PHASE's duration time is PROD_DURATION

I hope so my query is clear :) Could you help me about issue?

---

Answer:

Hello Alan,

Current situation I have just these data:

PROD100059335   SETUP   PRODUCTION  1   14  LINE 4
PROD100058991   SETUP   PRODUCTION  1   5   LINE 6
PROD100059259   SETUP   PRODUCTION  2   24  LINE 4
PROD100059188   SETUP   PRODUCTION  1   3   LINE 2
PROD100059248   SETUP   PRODUCTION  1   15  LINE 2
PROD100059055   SETUP   PRODUCTION  2   23  LINE 2
PROD100058754   SETUP   PRODUCTION  5   18  LINE 6

And If I use your query I just show "PROD100058754", "PROD100059259", "PROD100059055" these order. I don't understand why other data lost.

until "DECLARE @n TABLE(n int)" part I can show other data. but after that I can not show.

And I applied procedure on SSRS my report shows like this:

I couldn't do correctly and I don't know how can I fix them:(

for example "PROD100059259" this order normally has setup phase but on the report I don't have yellow field.

Do you have any suggestions for me?

Solution 1

Try going into /etc and executing find -name "php.ini" This should tell you where php.ini is located.

Solution 2

If you can access the CLI, typing php --ini will show you which .ini file PHP is trying to load.

It's possible, but unlikely, that you have no php.ini file at all, and could create one in the place that php_info(); suggests.

If you are on shared hosting, you may not be able to navigate highter than /home/gmcnulty, so in this case you should look for the php directory in the highest level you can access.

It is normal for php.ini to live in /etc, but I have also seen it installed in /var/lib before.

Comments

[Alan Schofield]

This is possible (probably!). I've built something similar myself. The problem I can see you facing is the scale of the data. We would have to build a matrix report with each column representing a fixed amount of time. Looking at your sample data, and assuming the data is in either minutes/seconds or hours/minutes then PROD100057968 has a setup time of 1 minute and a production time of 192 hours which is 11000 times bigger. Either the setup time would be lost on the report or the report would required tens of thousands of columns, which is not feasible.

[Alan Schofield]

following on, you could compromise by scaling everything so it fits into 256 columns (SSRS Matrix maximum) but it would not be accurate. If this sounds OK let me know and I will see if I can put something together

[Aylin]

Hello, thanks for your answer. ı tried to use stacked bar. maybe I can do to use stacked bar but still I have some issue. my values 1 is SET_PHASE, value 2 is PROD_PHASE. category group is LINE and Series Group is STR_ORDER_ID but if I created to like this I couldn't use duration time and I don't know how to change color green and yellow for every order and I should to put gap every distinct order. Could you help me about these issues? and I don't know by this way(stacked bar) is it make sence?

[Alan Schofield]

Again, this would be possible but you'll have the same issue. When you have a small setup time and long production time, the setup time will be so small you just won't see it. I'll see if I can come up with something that will get the data in a sensible format and then you can choose what you want to do with it from there.

[Aylin]

[enter image description here][1] [1]: i.stack.imgur.com/7Msri.png

[Aylin]

I did like above the picture. and you are right I will face same issue but I couldn't find how to put duration time condition on chart. if I put duration condition, I can show our costumer. And we can find another option. I should change footer axis title field to setup duration and production duration. Do you know How could I do?

[Alan Schofield]

I understand what you are trying to do but try creating a simple dataset containing just the two values from row 7 of your sample data. Then add a stacked bar chart to display this data and you will see what I mean.

[superuser]

Hm, were you able to find the file you're looking for? The Permission denied message is there probably because you aren't running the command in superuser mode. Try sudo find -name "php.ini" and that should go away.

[Aylin]

Thanks for your help Alan! :) but still I couldn't do report. I don't understand how I create matrix report?

[Alan Schofield]

just right-click the design surface, Insert/Matrix. Drag LINE into the left column, Drag N into the right column header and optionally drag 'Operation' into the data cell (bottom right labelled data when its blank). That should create the row and column groups. You can see the groups at the bottom of the design area. Once that's done, test it, you'll see the operation names in each cell. Then delete the data cell as you don't need it, set the data column width to something small like 0.3cm and set the background color expression to the SWITCH statement in the example.

[Aylin]

Hello Alan, I couldn't answer below. that's why I edited my question on above. Do you have any suggestion for my issue_

[Alan Schofield]

There was a bug in the original code which I have corrected, I've also changed some other parts as the format of the data is not the same as it was before.

[Aylin]

Thanks a lot about your help :) I did like this but on productıon environment my procedure running very slowly that's why I thought maybe I can use range(gantt) chart but if I use gantt chart I face to this problem link do you give me any suggestıon about this issue?