Subversion Repositories SmartDukaan

Rev

Rev 34075 | Rev 34103 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 34075 Rev 34098
Line 53... Line 53...
53 
</style>
 53 
</style>
54 
 
 54 
 
55 
<section class="wrapper">
 55 
<section class="wrapper">
56 
    <div class="row" style="margin: 0">
 56 
    <div class="row" style="margin: 0">
57 
        #if($isGtEqL3)
 57 
        #if($isGtEqL3)
58 
        <div class="col-md-12 text-right">
 58 
            <div class="col-md-12 text-right">
59 
            <h4>RBM Wise Today's ARR (Basis Product Movement)</h4>
 59 
                <h4>RBM Wise Today's ARR (Basis Product Movement)</h4>
60 
            <table style="float:right;margin-bottom: 10px;">
 60 
                <table style="float:right;margin-bottom: 10px;">
61 
                <tr>
 61 
                    <tr>
62 
                    <td>
 62 
                        <td>
63 
                        <input placeholder="Set Duration" name="rbmArrPeriod"
 63 
                            <input placeholder="Set Duration" name="rbmArrPeriod"
64 
                               id="rbmArrPeriod"
 64 
                                   id="rbmArrPeriod"
65 
                               type="text" value="" class="form-control input-sm" style="height: 34px;">
 65 
                                   type="text" value="" class="form-control input-sm" style="height: 34px;">
66 
                    </td>
 66 
                        </td>
67 
                    <td>
 67 
                        <td>
68 
                        <input class="btn btn-primary btn-sm rbm-target-achievement"
 68 
                            <input class="btn btn-primary btn-sm rbm-target-achievement"
69 
                               type="button"
 69 
                                   type="button"
70 
                               value="View">
 70 
                                   value="View">
71 
                    </td>
 71 
                        </td>
72 
                    <td>
 72 
                        <td>
73 
                        <input class="btn btn-primary btn-sm sold-catalog-report"
 73 
                            <input class="btn btn-primary btn-sm sold-catalog-report"
74 
                               type="button"
 74 
                                   type="button"
75 
                               value="Download row data">
 75 
                                   value="Download row data">
76 
                    </td>
 76 
                        </td>
77 
                </tr>
 77 
                    </tr>
78 
            </table>
 78 
                </table>
79 
        </div>
 79 
            </div>
80 
        #end
 80 
        #end
81 
        <div class="col-lg-12">
 81 
        <div class="col-lg-12">
82 
            <table id="rbm-arr-table" class="table table-border table-condensed table-bordered" style="width:100%">
 82 
            <table id="rbm-arr-table" class="table table-border table-condensed table-bordered" style="width:100%">
83 
                <tr>
 83 
                <tr>
84 
                    <th>RBM</th>
 84 
                    <th>RBM</th>
Line 88... Line 88...
88 
                    <th>%</th>
 88 
                    <th>%</th>
89 
                    <th>FAST (ACH/TGT)</th>
 89 
                    <th>FAST (ACH/TGT)</th>
90 
                    <th>%</th>
 90 
                    <th>%</th>
91 
                    <th>RUN (ACH/TGT)</th>
 91 
                    <th>RUN (ACH/TGT)</th>
92 
                    <th>%</th>
 92 
                    <th>%</th>
93 
                    <th>EOL (ACH/TGT)</th>
 93 
                    <th>SLOW (ACH/TGT)</th>
94 
                    <th>%</th>
 94 
                    <th>%</th>
95 
                    <th>Other (ACH/TGT)</th>
 95 
                    <th>Other (ACH/TGT)</th>
96 
                    <th>%</th>
 96 
                    <th>%</th>
97 
                </tr>
 97 
                </tr>
98 
                    #foreach($target in $rbmArrViewModels)
 98 
                #foreach($target in $rbmArrViewModels)
99 
                    <tr>
 99 
                    <tr>
100 
                        <td>$target.getRbmName()- $target.getWarehouseName()</td>
 100 
                        <td>$target.getRbmName()- $target.getWarehouseName()</td>
- 
 
 101 
 
101 
                        <td><span class="achieved-cell">$target.getTotalAchievedTarget()</span> / <span
 102 
                        <td><span class="achieved-cell">$target.getTotalAchievedTarget()</span> / <span
102 
                                class="target-cell">$target.getTodayTarget()</span></td>
 103 
                                class="target-cell">$target.getTodayTarget()</span></td>
103 
                        <td class="total-percent"></td>
 104 
                        <td class="total-percent"></td>
- 
 
 105 
 
104 
                        <td><span class="achieved-cell">$target.getTodayAchievedHidTarget()</span> / <span
 106 
                        <td><span class="achieved-cell">$target.getTodayAchievedHidTarget()</span> / <span
105 
                                class="target-cell">$target.getTodayHidTarget()</span></td>
 107 
                                class="target-cell">$target.getTodayHidTarget()</span></td>
106 
                        <td class="hid-percent"></td>
 108 
                        <td class="hid-percent"></td>
- 
 
 109 
 
107 
                        <td><span class="achieved-cell">$target.getTodayAchievedFastMovingTarget()</span> / <span
 110 
                        <td><span class="achieved-cell">$target.getTodayAchievedFastMovingTarget()</span> / <span
108 
                                class="target-cell">$target.getTodayFastMovingTarget()</span></td>
 111 
                                class="target-cell">$target.getTodayFastMovingTarget()</span></td>
- 
 
 112 
                        <td class="fast-percent"></td>
- 
 
 113 
 
- 
 
 114 
                        <td><span class="achieved-cell">$target.getTodayAchievedRunningTarget()</span> / <span
- 
 
 115 
                                class="target-cell">$target.getTodayRunningTarget()</span></td>
109 
                        <td class="run-percent"></td>
 116 
                        <td class="run-percent"></td>
- 
 
 117 
 
110 
                        <td><span class="achieved-cell">$target.getTodayAchievedSlowMovingTarget()</span> / <span
 118 
                        <td><span class="achieved-cell">$target.getTodayAchievedSlowMovingTarget()</span> / <span
111 
                                class="target-cell">$target.getTodaySlowMovingTarget()</span></td>
 119 
                                class="target-cell">$target.getTodaySlowMovingTarget()</span></td>
112 
                        <td class="slow-percent"></td>
 120 
                        <td class="slow-percent"></td>
113 
                        <td><span class="achieved-cell">$target.getTodayAchievedEolTarget()</span> / <span
 - 
 
114 
                                class="target-cell">$target.getTodayEolTarget()</span></td>
 - 
 
115 
                        <td class="eol-percent"></td>
 - 
 
- 
 
 121 
 
116 
                        <td><span class="achieved-cell">$target.getTodayAchievedOtherMovingTarget()</span> / <span
 122 
                        <td><span class="achieved-cell">$target.getTodayAchievedOtherMovingTarget()</span> / <span
117 
                                class="target-cell">$target.getTodayOtherMovingTarget()</span></td>
 123 
                                class="target-cell">$target.getTodayOtherMovingTarget()</span></td>
118 
                        <td class="other-percent"></td>
 124 
                        <td class="other-percent"></td>
119 
                    </tr>
 125 
                    </tr>
120 
                    #end
 126 
                #end
121 
                <!-- Add a row for totals -->
 127 
                <!-- Add a row for totals -->
122 
                <tr>
 128 
                <tr>
123 
                    <td><strong>Total</strong></td>
 129 
                    <td><strong>Total</strong></td>
124 
                    <td class="text-bold"><span class="achieved-cell">$totalAchieved </span> / <span
 130 
                    <td class="text-bold"><span class="achieved-cell">$totalAchieved </span> / <span
125 
                            class="target-cell">$totalTargetSum</span></td>
 131 
                            class="target-cell">$totalTargetSum</span></td>
Line 129... Line 135...
129 
                            class="target-cell">$totalHidSum</span></td>
 135 
                            class="target-cell">$totalHidSum</span></td>
130 
                    <td class="hid-percent text-bold"></td>
 136 
                    <td class="hid-percent text-bold"></td>
131 
 
 137 
 
132 
                    <td class="text-bold"><span class="achieved-cell">$totalFastAchievedSum</span> / <span
 138 
                    <td class="text-bold"><span class="achieved-cell">$totalFastAchievedSum</span> / <span
133 
                            class="target-cell">$totalFastSum</span></td>
 139 
                            class="target-cell">$totalFastSum</span></td>
- 
 
 140 
                    <td class="fast-percent text-bold"></td>
- 
 
 141 
 
- 
 
 142 
                    <td class="text-bold"><span class="achieved-cell">$totalRunningAchievedSum</span> / <span
- 
 
 143 
                            class="target-cell">$totalRunningSum</span></td>
134 
                    <td class="run-percent text-bold"></td>
 144 
                    <td class="run-percent text-bold"></td>
135 
 
 145 
 
136 
                    <td class="text-bold"><span class="achieved-cell">$totalSlowAchievedSum</span> / <span
 146 
                    <td class="text-bold"><span class="achieved-cell">$totalSlowAchievedSum</span> / <span
137 
                            class="target-cell">$totalSlowSum</span></td>
 147 
                            class="target-cell">$totalSlowSum</span></td>
138 
                    <td class="slow-percent text-bold"></td>
 148 
                    <td class="slow-percent text-bold"></td>
139 
 
 149 
 
140 
                    <td class="text-bold"><span class="achieved-cell">$totalEolAchievedSum</span> / <span
 - 
 
141 
                            class="target-cell">$totalEolSum</span></td>
 - 
 
142 
                    <td class="eol-percent text-bold"></td>
 - 
 
143 
 
 - 
 
144 
                    <td class="text-bold"><span class="achieved-cell">$totalOtherAchievedSum</span> / <span
 150 
                    <td class="text-bold"><span class="achieved-cell">$totalOtherAchievedSum</span> / <span
145 
                            class="target-cell">$totalOtherSum</span></td>
 151 
                            class="target-cell">$totalOtherSum</span></td>
146 
                    <td class="other-percent text-bold"></td>
 152 
                    <td class="other-percent text-bold"></td>
147 
                </tr>
 153 
                </tr>
148 
 
 154 
 
149 
            </table>
 155 
            </table>
150 
        </div>
 156 
        </div>
151 
    </div>
 157 
    </div>
152 
 
 158 
 
153 
    <div class="row" style="margin: 0">
 159 
    <div class="row" style="margin: 0">
154 
            <div class="col-md-12">
 160 
        <div class="col-md-12">
155 
                <br>
 161 
            <br>
156 
                <h4> > 15 Days Aging Sold </h4>
 162 
            <h4> > 15 Days Aging Sold </h4>
157 
                <table id="rbm-aging-table" class="table table-border table-condensed table-bordered"
 163 
            <table id="rbm-aging-table" class="table table-border table-condensed table-bordered"
158 
                       style="width:100%">
 164 
                   style="width:100%">
159 
                    <thead>
 165 
                <thead>
- 
 
 166 
                <tr>
- 
 
 167 
                    <th>RBM</th>
- 
 
 168 
                    <th>HID</th>
- 
 
 169 
                    <th>FASTMOVING</th>
- 
 
 170 
                    <th>RUNNING</th>
- 
 
 171 
                    <th>SLOWMOVING</th>
- 
 
 172 
                    <th>OTHER</th>
- 
 
 173 
                    <th>TOTAL</th>
- 
 
 174 
                </tr>
- 
 
 175 
                </thead>
- 
 
 176 
                <tbody>
- 
 
 177 
                    #foreach($model in $sold15daysOldAgingModels)
160 
                    <tr>
 178 
                    <tr>
161 
                        <th>RBM</th>
 179 
                        <th>$model.getRbmName()</th>
162 
                        <th>HID</th>
 180 
                        <td class="format-indian">$model.getHidBilled()</td>
163 
                        <th>FASTMOVING</th>
 181 
                        <td class="format-indian">$model.getFastmovingBilled()</td>
164 
                        <th>RUNNING</th>
 182 
                        <td class="format-indian">$model.getRunningBilled()</td>
165 
                        <th>EOL</th>
 183 
                        <td class="format-indian">$model.getSlowmovingBilled()</td>
166 
                        <th>OTHER</th>
 184 
                        <td class="format-indian">$model.getOthersBilled()</td>
167 
                        <th>TOTAL</th>
 185 
                        <td class="format-indian">$model.getTotalBilled()</td>
168 
                    </tr>
 186 
                    </tr>
169 
                    </thead>
 187 
                    #end
170 
                    <tbody>
 - 
 
171 
                        #foreach($model in $sold15daysOldAgingModels)
 - 
 
172 
                        <tr>
 188 
                <tr>
173 
                            <th>$model.getRbmName()</th>
 189 
                    <th class="border-top-bottom"> Total</th>
174 
                            <td class="format-indian">$model.getHidBilled()</td>
 190 
                    <td class="border-top-bottom format-indian">$totalSoldHid</td>
175 
                            <td class="format-indian">$model.getFastmovingBilled()</td>
 191 
                    <td class="border-top-bottom format-indian">$totalSoldFast</td>
176 
                            <td class="format-indian">$model.getRunningBilled()</td>
 192 
                    <td class="border-top-bottom format-indian">$totalSoldRun</td>
177 
                            <td class="format-indian">$model.getEolBilled()</td>
 193 
                    <td class="border-top-bottom format-indian">$totalSoldSlow</td>
178 
                            <td class="format-indian">$model.getOthersBilled()</td>
 194 
                    <td class="border-top-bottom format-indian">$totalSoldOther</td>
179 
                            <td class="format-indian">$model.getTotalBilled()</td>
 195 
                    <td class="border-top-bottom format-indian">$totalSoldAging</td>
180 
                        </tr>
 196 
                </tr>
181 
                        #end
 197 
                    #foreach($aging in $our15DaysOldAgingStocks)
182 
                    <tr>
 198 
                    <tr>
183 
                        <th class="border-top-bottom"> Total</th>
 199 
                        <th class="border-top-bottom"> 15 days Balance Value</th>
184 
                        <td class="border-top-bottom format-indian">$totalSoldHid</td>
 200 
                        <td class="border-top-bottom format-indian">$aging.getHidAgingStock()</td>
185 
                        <td class="border-top-bottom format-indian">$totalSoldFast</td>
 201 
                        <td class="border-top-bottom format-indian">$aging.getFastmovingAgingStock()</td>
186 
                        <td class="border-top-bottom format-indian">$totalSoldRun</td>
 202 
                        <td class="border-top-bottom format-indian">$aging.getRunningAgingStock()</td>
187 
                        <td class="border-top-bottom format-indian">$totalSoldEol</td>
 203 
                        <td class="border-top-bottom format-indian">$aging.getSlomovingAgingStock()</td>
188 
                        <td class="border-top-bottom format-indian">$totalSoldOther</td>
 204 
                        <td class="border-top-bottom format-indian">$aging.getOtherAgingStock()</td>
189 
                        <td class="border-top-bottom format-indian">$totalSoldAging</td>
 205 
                        <td class="border-top-bottom format-indian">$aging.getTotal()</td>
190 
                    </tr>
 206 
                    </tr>
191 
                        #foreach($aging in $our15DaysOldAgingStocks)
 - 
 
192 
                        <tr>
 - 
 
193 
                            <th class="border-top-bottom"> 15 days Balance Value</th>
 - 
 
194 
                            <td class="border-top-bottom format-indian">$aging.getHidAgingStock()</td>
 - 
 
195 
                            <td class="border-top-bottom format-indian">$aging.getFastmovingAgingStock()</td>
 - 
 
196 
                            <td class="border-top-bottom format-indian">$aging.getRunningAgingStock()</td>
 - 
 
197 
                            <td class="border-top-bottom format-indian">$aging.getEolAgingStock()</td>
 - 
 
198 
                            <td class="border-top-bottom format-indian">$aging.getOtherAgingStock()</td>
 - 
 
199 
                            <td class="border-top-bottom format-indian">$aging.getTotal()</td>
 - 
 
200 
                        </tr>
 - 
 
201 
                        #end
 207 
                    #end
202 
                    </tbody>
 208 
                </tbody>
203 
                </table>
 209 
            </table>
204 
            </div>
 210 
        </div>
205 
    </div>
 211 
    </div>
206 
</section>
 212 
</section>
207 
 
 213 
 
208 
<script>
 214 
<script>
209 
    function formatNumberIndian(num) {
 215 
    function formatNumberIndian(num) {
Line 231... Line 237...
231 
 
 237 
 
232 
    function formatTargets() {
 238 
    function formatTargets() {
233 
        const rows = document.querySelectorAll('#rbm-arr-table tbody tr');
 239 
        const rows = document.querySelectorAll('#rbm-arr-table tbody tr');
234 
        let totalAchieved = 0, totalTarget = 0;
 240 
        let totalAchieved = 0, totalTarget = 0;
235 
        let totalAchievedHid = 0, totalTargetHid = 0;
 241 
        let totalAchievedHid = 0, totalTargetHid = 0;
- 
 
 242 
        let totalAchievedFast = 0, totalTargetFast = 0;
236 
        let totalAchievedRun = 0, totalTargetRun = 0;
 243 
        let totalAchievedRunning = 0, totalTargetRunning = 0;
237 
        let totalAchievedSlow = 0, totalTargetSlow = 0;
 244 
        let totalAchievedSlow = 0, totalTargetSlow = 0;
238 
        let totalAchievedEol = 0, totalTargetEol = 0;
 - 
 
239 
        let totalAchievedOther = 0, totalTargetOther = 0;
 245 
        let totalAchievedOther = 0, totalTargetOther = 0;
240 
 
 246 
 
241 
        rows.forEach(row => {
 247 
        rows.forEach(row => {
242 
            const cells = row.querySelectorAll('td');
 248 
            const cells = row.querySelectorAll('td');
243 
            cells.forEach((cell, index) => {
 249 
            cells.forEach((cell, index) => {
Line 253... Line 259...
253 
                        totalTarget += targetValue || 0;
 259 
                        totalTarget += targetValue || 0;
254 
                    } else if (index === 3) {
 260 
                    } else if (index === 3) {
255 
                        totalAchievedHid += achievedValue || 0;
 261 
                        totalAchievedHid += achievedValue || 0;
256 
                        totalTargetHid += targetValue || 0;
 262 
                        totalTargetHid += targetValue || 0;
257 
                    } else if (index === 5) {
 263 
                    } else if (index === 5) {
258 
                        totalAchievedRun += achievedValue || 0;
 264 
                        totalAchievedFast += achievedValue || 0;
259 
                        totalTargetRun += targetValue || 0;
 265 
                        totalTargetFast += targetValue || 0;
260 
                    } else if (index === 7) {
 266 
                    } else if (index === 7) {
- 
 
 267 
                        totalAchievedRunning += achievedValue || 0;
- 
 
 268 
                        totalTargetRunning += targetValue || 0;
- 
 
 269 
                    } else if (index === 9) {
261 
                        totalAchievedSlow += achievedValue || 0;
 270 
                        totalAchievedSlow += achievedValue || 0;
262 
                        totalTargetSlow += targetValue || 0;
 271 
                        totalTargetSlow += targetValue || 0;
263 
                    } else if (index === 9) {
 - 
 
264 
                        totalAchievedEol += achievedValue || 0;
 - 
 
265 
                        totalTargetEol += targetValue || 0;
 - 
 
266 
                    } else if (index === 11) {
 272 
                    } else if (index === 11) {
267 
                        totalAchievedOther += achievedValue || 0;
 273 
                        totalAchievedOther += achievedValue || 0;
268 
                        totalTargetOther += targetValue || 0;
 274 
                        totalTargetOther += targetValue || 0;
269 
                    }
 275 
                    }
270 
 
 276