php - yii changing removing and renameing column names -


i have return sends list of items in auction. trying clean array before export excel spread sheet. can use yii or php clean select before exporting, need know how it. know how mysql statement frowned upon in yii world.

this current code:

$auction = btmauctions::model()->findbypk($id); $listings = $auction->btmlistings; $filename = 'last_lot_export.csv'; $csv = new ecsvexport($listings); $csv->tocsv($filename); // returns string default yii::app()->getrequest()->sendfile( $auction->name.'_lots.csv' , file_get_contents( $filename ) );

this exports csv looks this:

id| auction_id| lot| description | manufacturer | model|more_info|  condition 21  10  12  fanuc circuit board fanuc   a20b-9000-0180/09c      3 20  10  1   fanuc circuit board fanuc   a20b-0008-0242/023a     4 22  10  18  fanuc circut board  fanuc   a20b-1003-0010/12b  * little dirty    3 23  10  19  fanuc circuit board fanuc   a20b-1003-0020/03a  *very dirty!!! *plastic broken on risers!! cosmetic only!!  3

what need clean cvs automatically before exporting looks this:

lot|info              | manufacturer| model|  more info |         condition 12  fanuc circuit board  fanuc   a20b-9000-0180/09c                     3 1   fanuc circuit board  fanuc   a20b-0008-0242/023a                    4 18  fanuc circut board   fanuc   a20b-1003-0010/12b * little dirty    3 19  fanuc circuit board  fanuc   a20b-1003-0020/03a *very dirty!!!

to summarize changes, need delete first 2 columns, , rename 'description' column 'info'

should human readable headers

$headers = array('header_to_change'=>'new value'); $csv->setheaders($headers);  // or  $csv->setheader($currentheadervalue, $newheadervalue);

and export columns want select columns. looks ecsvexport class use carraydataprovider input. therefore select columns want export , fill carraydataprovider , export class.

but can use "setcallback" function remove unwanted column entries or "setexclude" function. both functions there example in link given above.


-

Comments

Post a Comment

Popular posts from this blog

OpenCV OpenCL: Convert Mat to Bitmap in JNI Layer for Android -

there several posts converting mat bitmap using utils.mattobitmap() function. i'm assuming function can called in java layer after importing utils class. i want transfer data memory address pointed uint32_t* bmpcontent; in code below. jniexport void jnicall java_com_nod_nodcv_nodcvactivity_runfilter( jnienv *env, jclass clazz, jobject outbmp, jbytearray indata, jint width, jint height, jint choice, jint filter) { int outsz = width*height; int insz = outsz + outsz/2; androidbitmapinfo bmpinfo; if (androidbitmap_getinfo(env, outbmp, &bmpinfo) < 0) { throwjavaexception(env,"gaussianblur","error retrieving bitmap meta data"); return; } if (bmpinfo.format != android_bitmap_format_rgba_8888) { throwjavaexception(env,"gaussianblur","expecting rgba_8888 format"); return; } uint32_t* bmpcontent; if (androidbitmap_lockpixels(env, outbmp,(void**)&bmpcontent)...
Read more

android - org.xmlpull.v1.XmlPullParserException: expected: START_TAG {http://schemas.xmlsoap.org/soap/envelope/}Envelope -

i trying hit soap api in application login purpose , getting above mentioned error , can 1 tell me going wrong , first time soap apis. here code hit soap :- vector<object> args = new vector<object>(); hashtable<string, object> hashtable = new hashtable<string, object>(); hashtable.put("email", "mss.siddhart28@gmail.com"); hashtable.put("password", "siddharth"); args.add(hashtable); soapserializationenvelope envelope = new soapserializationenvelope( soapenvelope.ver11); envelope.dotnet = true; envelope.xsd = soapserializationenvelope.xsd; envelope.enc = soapserializationenvelope.enc; (new marshalhashtable()).register(envelope); httptransportse androidhttptransport = new httptransportse( "http://tempuri.org/", 15000); androidhttptransport.debug = true; string result = ""; try { soapobject request = new soapobject("http:...
Read more

python - How to remove the Xframe Options header in django? -

i have made page has iframe . inside iframe want show multiple different links article facebook, or news, or youtube video or other possible url. but, due xframe header, unable so. referred following link: https://docs.djangoproject.com/en/1.8/ref/clickjacking/ , django xframeoptionsmiddleware (x-frame-options) - allow iframe client ip but didn't help. my settings.py file's middleware_classes is: middleware_classes = ( 'django.contrib.sessions.middleware.sessionmiddleware', 'django.middleware.common.commonmiddleware', 'django.middleware.csrf.csrfviewmiddleware', 'django.contrib.auth.middleware.authenticationmiddleware', 'django.contrib.auth.middleware.sessionauthenticationmiddleware', 'django.contrib.messages.middleware.messagemiddleware', 'django.middleware.clickjacking.xframeoptionsmiddleware', ) from http://django-secure.readthedocs.org/en/latest/middleware.html , found using ...
Read more