Click here to Skip to main content
15,394,560 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
PinnedForum Guidelines - PLEASE READ Pin
Chris Maunder28-Jul-09 2:39
cofounderChris Maunder28-Jul-09 2:39 
Questionimplement ElFinder in PHP language Pin
Alexis Sanchez Vanegas19-May-22 4:28
MemberAlexis Sanchez Vanegas19-May-22 4:28 
QuestionAapanel upload project laravel Pin
marziyeh barooei9-May-22 1:05
Membermarziyeh barooei9-May-22 1:05 
Questionhow do I get total quantity from this code Pin
wixily jnr28-Apr-22 13:29
Memberwixily jnr28-Apr-22 13:29 
AnswerRe: how do I get total quantity from this code Pin
Richard MacCutchan28-Apr-22 21:31
mveRichard MacCutchan28-Apr-22 21:31 
QuestionROLES ET PRIVILEGES UTILISATEURS D'UN SITE Pin
ameb290825-Apr-22 4:06
Memberameb290825-Apr-22 4:06 
QuestionHow can I do a google search and get results in backend using JS or PHP? Pin
Social Bookmarking Site14-Apr-22 15:27
MemberSocial Bookmarking Site14-Apr-22 15:27 
Questionproblem in pagination click Pin
irfankundi7861-Apr-22 23:39
Memberirfankundi7861-Apr-22 23:39 
AnswerRe: problem in pagination click Pin
Richard Deeming3-Apr-22 21:36
mveRichard Deeming3-Apr-22 21:36 
GeneralRe: problem in pagination click Pin
irfankundi7864-Apr-22 4:01
Memberirfankundi7864-Apr-22 4:01 
QuestionGUI for Linux Server Pin
Deepak Vasudevan25-Jan-22 3:29
MemberDeepak Vasudevan25-Jan-22 3:29 
QuestionError in page rendering in php Pin
Rahul Gupta Jan202217-Jan-22 1:16
MemberRahul Gupta Jan202217-Jan-22 1:16 
AnswerRe: Error in page rendering in php Pin
Richard Deeming17-Jan-22 1:53
mveRichard Deeming17-Jan-22 1:53 
Questionhow to add date while importing data in csv from mysql query Pin
him_mca16-Jan-22 20:00
Memberhim_mca16-Jan-22 20:00 
Questioni want make check user offline with mysql Pin
Ping tester1-Jul-21 10:56
MemberPing tester1-Jul-21 10:56 
QuestionHow to print for each primary key all the foreign keys column related to it? Pin
EliotSimpleMan5-May-21 14:40
MemberEliotSimpleMan5-May-21 14:40 
AnswerRe: How to print for each primary key all the foreign keys column related to it? Pin
SeanChupas13-May-21 1:50
MemberSeanChupas13-May-21 1:50 
QuestionHow do I calculate the column in PHP union all function Pin
Developer Account18-Apr-21 23:12
MemberDeveloper Account18-Apr-21 23:12 
<pre>I have an issue while calculating the column-like bank statement. actually, I am trying to calculate Opening Balance/today In /today Out / Closing Bal in MySQL PHP. I have two tables. material_infor `IN +` entry and material_approvefor `OUT -`. I am considering my opening balance was `123`.

I am new in PHP and I am here using Union All function. Please help me to create the function for getting Opening / In today / out today/closing calculation in my code.



`table- material_in`

| id   | components_key | insert_date | credit      |
|------|----------------|-------------|-------------|
| 1    | 12345          | 2021-04-16  | 100         |
| 2    | 12345          | 2021-04-16  | 50          |



`table- material_approve`

| id   | components_key | insert_date | debit       |
|------|----------------|-------------|-------------|
| 1    | 12345          | 2021-04-16  | 30          |
| 2    | 12345          | 2021-04-16  | 2           |



<pre>I am trying the code - 

    SELECT
        `u`.`component_key`,
        `u`.`insert_date`,
        `u`.`transaction_qty`
    FROM
        (
        SELECT
            `components_key` AS `component_key`,
            `insert_date`,
            `credit` AS `transaction_qty`
        FROM
            `material_in`
        UNION ALL
        SELECT
            `components_key`,
            `insert_date`,
            `debit` AS `transaction_qty`
        FROM
            `material_approve`
        ) u
    WHERE
        `u`.`component_key` = '12345'
    ORDER BY
        `u`.`insert_date`
    DESC


the output comes - 

| components_key | insert_date | transaction_qty|
|-------------|-------------|------------|
| 12345      | 2021-04-16  | 100         |
| 12345      | 2021-04-16  | 50          |
| 12345      | 2021-04-16  | 30          |
| 12345      | 2021-04-16  | 2           |

`output will be-`

| components_key | insert_date | openbal| today_in | today_out | closebal
|-----------|-------------|-------------|----------|-----------|---------|
|12345      | 2021-04-16  | 123         | 100      | 30        | 193     | 
|12345      | 2021-04-16  | 193         | 243      | 2         | 241     |

//openbal + today_in - today_out  = closebal

AnswerRe: How do I calculate the column in PHP union all function Pin
SeanChupas13-May-21 1:51
MemberSeanChupas13-May-21 1:51 
QuestionPHP :: VSCode always opens a new blank window (untitled-1) Pin
Gustavo Laufer AU4-Apr-21 22:00
MemberGustavo Laufer AU4-Apr-21 22:00 
AnswerRe: PHP :: VSCode always opens a new blank window (untitled-1) Pin
SeanChupas5-Apr-21 3:15
MemberSeanChupas5-Apr-21 3:15 
Questioni have this errors in my project please i need help Pin
frank saki24-Mar-21 11:55
Memberfrank saki24-Mar-21 11:55 
AnswerRe: i have this errors in my project please i need help Pin
Richard Deeming24-Mar-21 22:12
mveRichard Deeming24-Mar-21 22:12 
QuestionHow can I echo the numbers using list() function in foreach loop? Pin
Best Tutor24-Feb-21 9:33
MemberBest Tutor24-Feb-21 9:33 
QuestionRe: How can I echo the numbers using list() function in foreach loop? Pin
Richard MacCutchan24-Feb-21 21:56
mveRichard MacCutchan24-Feb-21 21:56 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.