What is happening:
| DATE | COUNTER |
|---|---|
| 2012-01-01 | 32 |
| 2012-01-02 | 28 |
| 2012-01-04 | 12 |
| 2012-01-05 | 23 |
As you can see, on 2012-01-03 dates there isn't any data. So the goal is to create a query (without procedure) to produce below result:
meirzadotcom
/ Readme.MD
Last active
August 29, 2015 14:27
MySQL: Return "0" even when data doesn't exist
meirzadotcom
/ Apaini_RecyclerItemClickListener.MD
Created
June 25, 2015 05:02
RecyclerItemClickListener (onItemClick & onItemLongClick)
Support onItemLongClick
meirzadotcom
/ apaini_RecyclerRippleSelector.MD
Last active
August 29, 2015 14:23
RecyclerView Ripple Selector
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public class AndroidLifeCycle extends Activity { | |
| String tag = "AndroidLifeCycleEvents"; | |
| @Override | |
| public void onCreate(Bundle savedInstanceState) { | |
| super.onCreate(savedInstanceState); | |
| setContentView(R.layout.main); | |
| Log.d(tag, "In the onCreate() event"); | |
| } | |
| public void onStart() |
meirzadotcom
/ Apaini_PreferenceActivity.MD
Last active
August 29, 2015 14:23
Implementasi PreferenceActivity (ActionBarCompat, PreferenceFragment)
PreferenceActivity support ActionBarCompat and PreferenceFragment.
meirzadotcom
/ MainActivity.java
Created
June 15, 2015 07:59
Implementation of android.support.v7.widget.SearchView
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @Override | |
| public boolean onCreateOptionsMenu(Menu menu) { | |
| MenuInflater inflater = getMenuInflater(); | |
| inflater.inflate(R.menu.menu_main, menu); | |
| SearchManager searchManager = (SearchManager) getSystemService(Context.SEARCH_SERVICE); | |
| MenuItem searchItem = menu.findItem(R.id.action_search); | |
| ComponentName cn = new ComponentName(this, SearchableActivity.class); | |
| SearchView searchView = (SearchView) searchItem.getActionView(); |
meirzadotcom
/ gist:6473532
Last active
December 22, 2015 12:39
Geoserver WMS: Tiled and SingleTile Layer
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Tiled Layer | |
| the_layer = new OpenLayers.Layer.WMS( | |
| "My Layer", | |
| "http://localhost:8080/geoserver/merapi/wms", | |
| { | |
| layers: 'merapi:desa', | |
| isBaseLayer: false, | |
| tiled: true, | |
| format: 'image/png', | |
| tilesOrigin : map.maxExtent.left + ',' + map.maxExtent.bottom, |
meirzadotcom
/ gist:5590908
Last active
December 17, 2015 09:58
Python: Calling method without threading
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| tampil = """{"data1":"Ini Data 1","data2":"Ini Data 2""" | |
| class TestClass(): | |
| def run(self): | |
| tampil_class = """","data3":"Ini Data 3"}""" | |
| return tampil_class | |
| t = TestClass() | |
| tampil_class = t.run() |
NewerOlder