Speedup_your_catalog_update_using_our_Direct_SQL_Update_extension - Version 1.3

Version Notes

added task status to check the direct SQL update status. No need anymore to check your cron_schedule table:

Status: pending, error, missed or succes
Created At, Scheduled and At Finished At times

Download this release

Release Info

Developer Magento Core Team
Extension Speedup_your_catalog_update_using_our_Direct_SQL_Update_extension
Version 1.3
Comparing to
See all releases


Code changes from version 1.2 to 1.3

Files changed (3) hide show
  1. app/code/community/Ayasoftware/SQLupdate/etc/config.xml +1 -1
  2. app/design/adminhtml/default/default/template/sqlupdate/schedule.phtml +49 -0
  3. package.xml +7 -8
app/code/community/Ayasoftware/SQLupdate/etc/config.xml CHANGED
@@ -1,7 +1,7 @@
1
  <config>
2
  <modules>
3
  <Ayasoftware_SQLupdate>
4
- <version>1.2</version>
5
  <depends>
6
  <!-- no dependencies -->
7
  </depends>
1
  <config>
2
  <modules>
3
  <Ayasoftware_SQLupdate>
4
+ <version>1.3</version>
5
  <depends>
6
  <!-- no dependencies -->
7
  </depends>
app/design/adminhtml/default/default/template/sqlupdate/schedule.phtml CHANGED
@@ -48,6 +48,55 @@ $timecreated = date("Y-m-d H:i:s");
48
  <h2>How to use this module</h2>
49
  <h4 class="icon-head head-edit-form fieldset-legend"><?=$this->__ ( 'The SQL Update is by default Scheduled to be automatically run at midnight 00:00 ' )?></h4>
50
  <h4 class="icon-head head-edit-form fieldset-legend"><?=$this->__ ( 'If you pick a new Scheduling for your SQL Update, we will replace the default (only this time) ' )?></h4>
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
51
  </div>
52
  <script type="text/javascript">
53
  var editForm = new varienForm('edit_form');
48
  <h2>How to use this module</h2>
49
  <h4 class="icon-head head-edit-form fieldset-legend"><?=$this->__ ( 'The SQL Update is by default Scheduled to be automatically run at midnight 00:00 ' )?></h4>
50
  <h4 class="icon-head head-edit-form fieldset-legend"><?=$this->__ ( 'If you pick a new Scheduling for your SQL Update, we will replace the default (only this time) ' )?></h4>
51
+ <br />
52
+ <br />
53
+ <hr />
54
+ <br />
55
+ <br />
56
+ <h2>Task Status</h2>
57
+
58
+ <?php
59
+
60
+ $jobCode = "direct_sql_update";
61
+ ?>
62
+ <table border="1" class="entry-edit" cellspacing="10" cellpadding="10">
63
+ <tr>
64
+ <td>Job Code</td>
65
+ <td>Status</td>
66
+ <td>Created At</td>
67
+ <td>Scheduled At</td>
68
+ <td>Finished At</td>
69
+ </tr>
70
+ <?php
71
+ try {
72
+ $sql_update = Mage::getModel ( 'cron/schedule' )->getCollection ()->addFieldToFilter ( 'job_code', array ('in' => array ($jobCode ) ) );
73
+ foreach ( $sql_update->getIterator () as $record ) {
74
+ echo "<tr>";
75
+ echo "<td>";
76
+ echo $record->getJobCode ();
77
+ echo "</td>";
78
+ echo "<td>";
79
+ echo $record->getStatus ();
80
+ echo "</td>";
81
+ echo "<td>";
82
+ echo $record->getCreatedAt ();
83
+ echo "</td>";
84
+ echo "<td>";
85
+ echo $record->getScheduledAt ();
86
+ echo "</td>";
87
+ echo "<td>";
88
+ echo $record->getFinishedAt ();
89
+ echo "</td>";
90
+ echo "</tr>";
91
+ }
92
+
93
+ } catch ( Exception $e ) {
94
+ throw new Exception ( Mage::helper ( 'cron' )->__ ( 'Unable to save Cron.' ) );
95
+ }
96
+ echo "</table>";
97
+ ?>
98
+
99
+
100
  </div>
101
  <script type="text/javascript">
102
  var editForm = new varienForm('edit_form');
package.xml CHANGED
@@ -1,7 +1,7 @@
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Speedup_your_catalog_update_using_our_Direct_SQL_Update_extension</name>
4
- <version>1.2</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/osl-3.0.php">Extension license name (OSL v3.0)</license>
7
  <channel>community</channel>
@@ -24,15 +24,14 @@ Extension Features:
24
  - User-friendly interface
25
  - Provide a detailed updates report saved to a log File.
26
  - Based on Dweeves script (Follow thread )</description>
27
- <notes>Extension tested on Magento CE 1.3.X.Y , 1.4.X.Y and Magento Enterprise Edition (1.8.0.0).
28
 
29
-
30
- - Update Admin Interface (new date/time picker)
31
- - Added missed files</notes>
32
  <authors><author><name>EL Hassan Matar</name><user>auto-converted</user><email>el.hassan.matar@gmail.com</email></author></authors>
33
- <date>2010-09-06</date>
34
- <time>16:52:13</time>
35
- <contents><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="sqlupdate.xml" hash="77ad8d193fe5f92ea54ca471858836eb"/></dir><dir name="template"><dir name="sqlupdate"><file name="schedule.phtml" hash="22ab1d54363e178e63839930d4069bbb"/></dir></dir></dir></dir></dir></target><target name="magecommunity"><dir name="Ayasoftware"><dir name="SQLupdate"><dir name="Block"><dir name="System"><file name="Html.php" hash="9b9e6aa706535e58e86ea1260910cb17"/></dir></dir><dir name="controllers"><dir name="Adminhtml"><file name="SqlupdateController.php" hash="2fd2836a321c738679656f73de64f7c5"/></dir></dir><dir name="etc"><file name="config.xml" hash="24646eb59f0cdcf12778f00f55915f79"/><file name="system.xml" hash="45031a024e40a09cf1906fea75a6d03f"/></dir><dir name="Helper"><file name="Data.php" hash="ecbe414b1c243fb379266dbd15047993"/></dir><dir name="Model"><file name="DBHelper.php" hash="5f991190b397853c5dee307110b21060"/><file name="Massimport.php" hash="1e8c0605f2a0d07272c9ac766f9a45cb"/><file name="Observer.php" hash="fcc7212083cd72920ff117f3299afcc8"/></dir></dir></dir></target><target name="mage"><dir name="js"><dir name="ayasoftware"><file name="behaviors.js" hash="803fbd82d3a132633288f31edb12f5ca"/><file name="behaviour.js" hash="782fb396b22aff61b4e4b03d144fd1d7"/><file name="datepicker.css" hash="7889f5fe2cf572b8bce80d7d8d1ac5c2"/><file name="datepicker.js" hash="56234bdc9ebbb7f58da1344664f9bbb1"/><file name="datetimepicker.js" hash="39a363522d2654d5a35a7469a753481f"/><file name="prototype-1.6.0.2.js" hash="6f804651639c56d134e892125179b76d"/><file name="prototype-base-extensions.js" hash="eec08721b9e8b4fd05ecd20653978355"/><file name="prototype-date-extensions.js" hash="babd1760797624cbac3479a16647a5fd"/></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Ayasoftware_SQLupdate.xml" hash="8ef6e3f0f41e0960a02484cefd1afd48"/></dir></target></contents>
36
  <compatible/>
37
  <dependencies/>
38
  </package>
1
  <?xml version="1.0"?>
2
  <package>
3
  <name>Speedup_your_catalog_update_using_our_Direct_SQL_Update_extension</name>
4
+ <version>1.3</version>
5
  <stability>stable</stability>
6
  <license uri="http://www.opensource.org/licenses/osl-3.0.php">Extension license name (OSL v3.0)</license>
7
  <channel>community</channel>
24
  - User-friendly interface
25
  - Provide a detailed updates report saved to a log File.
26
  - Based on Dweeves script (Follow thread )</description>
27
+ <notes>added task status to check the direct SQL update status. No need anymore to check your cron_schedule table:
28
 
29
+ Status: pending, error, missed or succes
30
+ Created At, Scheduled and At Finished At times</notes>
 
31
  <authors><author><name>EL Hassan Matar</name><user>auto-converted</user><email>el.hassan.matar@gmail.com</email></author></authors>
32
+ <date>2010-09-11</date>
33
+ <time>23:01:56</time>
34
+ <contents><target name="magedesign"><dir name="adminhtml"><dir name="default"><dir name="default"><dir name="layout"><file name="sqlupdate.xml" hash="77ad8d193fe5f92ea54ca471858836eb"/></dir><dir name="template"><dir name="sqlupdate"><file name="schedule.phtml" hash="cc730bfe6daff1140ef3137ab17a80b3"/></dir></dir></dir></dir></dir></target><target name="magecommunity"><dir name="Ayasoftware"><dir name="SQLupdate"><dir name="Block"><dir name="System"><file name="Html.php" hash="9b9e6aa706535e58e86ea1260910cb17"/></dir></dir><dir name="controllers"><dir name="Adminhtml"><file name="SqlupdateController.php" hash="2fd2836a321c738679656f73de64f7c5"/></dir></dir><dir name="etc"><file name="config.xml" hash="c908062aff6a90ed7542efe00ae6f9e0"/><file name="system.xml" hash="45031a024e40a09cf1906fea75a6d03f"/></dir><dir name="Helper"><file name="Data.php" hash="ecbe414b1c243fb379266dbd15047993"/></dir><dir name="Model"><file name="DBHelper.php" hash="5f991190b397853c5dee307110b21060"/><file name="Massimport.php" hash="1e8c0605f2a0d07272c9ac766f9a45cb"/><file name="Observer.php" hash="fcc7212083cd72920ff117f3299afcc8"/></dir></dir></dir></target><target name="mage"><dir name="js"><dir name="ayasoftware"><file name="behaviors.js" hash="803fbd82d3a132633288f31edb12f5ca"/><file name="behaviour.js" hash="782fb396b22aff61b4e4b03d144fd1d7"/><file name="datepicker.css" hash="7889f5fe2cf572b8bce80d7d8d1ac5c2"/><file name="datepicker.js" hash="56234bdc9ebbb7f58da1344664f9bbb1"/><file name="datetimepicker.js" hash="39a363522d2654d5a35a7469a753481f"/><file name="prototype-1.6.0.2.js" hash="6f804651639c56d134e892125179b76d"/><file name="prototype-base-extensions.js" hash="eec08721b9e8b4fd05ecd20653978355"/><file name="prototype-date-extensions.js" hash="babd1760797624cbac3479a16647a5fd"/></dir></dir></target><target name="mageetc"><dir name="modules"><file name="Ayasoftware_SQLupdate.xml" hash="8ef6e3f0f41e0960a02484cefd1afd48"/></dir></target></contents>
35
  <compatible/>
36
  <dependencies/>
37
  </package>