App script

-
function doGet(e) {

var action = e.parameter.action;

if(action=="getNews"){
return getNews(e);
}

if(action=="addView"){
return addView(e);
}

if(action=="report"){
return reportNews(e);
}

return ContentService.createTextOutput("API Running");

}



function doPost(e){

var data=JSON.parse(e.postData.contents);

if(data.action=="postNews"){
return postNews(data);
}

}



/* POST NEWS */

function postNews(data){

var sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("NEWS");

var id=new Date().getTime();

sheet.appendRow([
id,
data.headline,
data.text,
data.username,
data.photo,
data.email,
data.latitude,
data.longitude,
new Date().getTime(),
0,
0
]);

return ContentService.createTextOutput("posted");

}



/* GET NEWS */

function getNews(e){

var lat=parseFloat(e.parameter.lat);
var lon=parseFloat(e.parameter.lon);

var sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("NEWS");

var data=sheet.getDataRange().getValues();

var result=[];

var now=new Date().getTime();

for(var i=1;i<data.length;i++){

var row=data[i];

var id=row[0];
var headline=row[1];
var text=row[2];
var email=row[3];
var nlat=row[4];
var nlon=row[5];
var time=row[6];
var views=row[7];
var reports=row[8];

var distance=getDistance(lat,lon,nlat,nlon);

var hours=(now-time)/3600000;

/* 5km limit */

if(distance<=5 && hours<=24){

result.push({
id:id,
headline:headline,
text:text,
time:time,
views:views
});

}

}

/* SORT BY VIEWS */

result.sort(function(a,b){

return b.views-a.views;

});

/* LIMIT 100 */

result=result.slice(0,100);

return ContentService
.createTextOutput(JSON.stringify(result))
.setMimeType(ContentService.MimeType.JSON);

}



/* VIEW COUNT */

function addView(e){

var id=e.parameter.id;

var sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("NEWS");

var data=sheet.getDataRange().getValues();

for(var i=1;i<data.length;i++){

if(data[i][0]==id){

var views=data[i][7];

sheet.getRange(i+1,8).setValue(views+1);

break;

}

}

return ContentService.createTextOutput("view added");

}



/* REPORT SYSTEM */

function reportNews(e){

var id=e.parameter.id;

var sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("NEWS");

var data=sheet.getDataRange().getValues();

for(var i=1;i<data.length;i++){

if(data[i][0]==id){

var reports=data[i][8]+1;

sheet.getRange(i+1,9).setValue(reports);

/* DELETE IF 5 REPORT */

if(reports>=5){

sheet.deleteRow(i+1);

}

break;

}

}

return ContentService.createTextOutput("reported");

}



/* DISTANCE CALCULATION */

function getDistance(lat1, lon1, lat2, lon2) {

var R = 6371;

var dLat = (lat2-lat1) * Math.PI/180;

var dLon = (lon2-lon1) * Math.PI/180;

var a =
Math.sin(dLat/2) * Math.sin(dLat/2) +
Math.cos(lat1 * Math.PI/180) * Math.cos(lat2 * Math.PI/180) *
Math.sin(dLon/2) * Math.sin(dLon/2);

var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));

var d = R * c;

return d;

}



/* AUTO DELETE OLD NEWS */

function deleteOldNews(){

var sheet=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("NEWS");

var data=sheet.getDataRange().getValues();

var now=new Date().getTime();

for(var i=data.length-1;i>0;i--){

var time=data[i][6];

var hours=(now-time)/3600000;

if(hours>24){

sheet.deleteRow(i+1);

}

}

}

इस ब्लॉग से लोकप्रिय पोस्ट

The History of the World – A Simple and Long Article for English Learners

-
ठीक है, अब मैं आपको अगला बड़ा और आसान इंग्लिश आर्टिकल दे रहा हूँ। इस बार का विषय है — 🇺🇳 The United Nations (UN) – A Simple and Long English Article for English Learners The United Nations , also called the UN , is an international organization. It was created to maintain peace, help countries work together, and solve world problems. The UN was formed after World War 2 , when countries realized they needed a system to prevent such big wars in the future. 📅 When and Where Was the UN Founded? Date: 24 October 1945 Place: San Francisco, USA Started with: 51 member countries Today: 193 member countries The headquarters of the UN is in New York City, USA . 🎯 Main Goals of the UN Maintain World Peace – Stop wars and conflicts. Protect Human Rights – Ensure fairness and freedom for all people. Help in Development – Support poor countries in education, health, and jobs. Provide Humanitarian Aid – Help during natural disasters or wars. Promote International...
और पढ़ें

High Level Advance Random English Words

-
Adversity Prosperity Struggle Transformation Evolution Redemption Downfall Ascension Resilience Endurance Perseverance Triumph Defeat Suffering Growth Maturity Awakening Enlightenment Disillusionment Acceptance Rejection Isolation Belonging Alienation Fulfillment Emptiness Ambition Obsession Sacrifice Commitment Betrayal Loyalty Reconciliation Regret Remorse Redirection Reinvention Self-discovery Self-realization Identity Purpose Destiny Fate Misfortune Fortune Breakthrough Collapse Reconstruction Rebirth Renewal Adaptation Adjustment Survival Vulnerability Strength Wisdom Ignorance Awareness Realization Reflection Introspection Confusion Clarity Conflict Resolution Acceptance Resistance Liberation Oppression Fear Courage Hope Despair Motivation Exhaustion Burnout Recovery Healing Restoration Closure Transition Stagnation Progress Regression Achievement Failure Legacy
और पढ़ें

1. The Art of Self-Discipline

-
 The Art of Self-Discipline: A Complete, Practical, and Inspiring Guide Overview Self-discipline is the quiet architecture of a meaningful life. It is not punishment. It is not self-hatred. It is a rational, compassionate structure that lets you act on your best judgment—especially when you do not “feel like it.” Motivation is a spark; self-discipline is the wiring, the switch, and the circuit breaker that keep the lights on. This guide blends psychology, philosophy, neuroscience, and real-world practice. The language is advanced but the sentences are simple and direct. Use it as a handbook, not a lecture. Part I — Foundations What Self-Discipline Actually Is Definition: The consistent ability to align daily actions with chosen values and long-term goals, under a system of clear rules, supportive environments, and measured feedback. Key property: It is built, not found. It grows through repetition, design, and reflection—not through mood. Discipline vs. Motivation Motivation is vol...
और पढ़ें